Install/update your database - blank white page

[ManofValor]

Log gave me a bunch of these;

[root@localhost bin]# tail -100 /var/log/httpd/error_log
[Wed Feb 24 15:55:37.283070 2016] [:error] [pid 28155] [client 10.10.1.40:45996] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52, referer: http://10.10.1.40/fog/management/?node=schemaupdater
[Wed Feb 24 15:55:37.283135 2016] [:error] [pid 28155] [client 10.10.1.40:45996] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40, referer: http://10.10.1.40/fog/management/?node=schemaupdater
[Wed Feb 24 15:55:37.283149 2016] [:error] [pid 28155] [client 10.10.1.40:45996] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52, referer: http://10.10.1.40/fog/management/?node=schemaupdater
[Wed Feb 24 15:55:37.283207 2016] [:error] [pid 28155] [client 10.10.1.40:45996] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40, referer: http://10.10.1.40/fog/management/?node=schemaupdater
[Wed Feb 24 15:55:37.283221 2016] [:error] [pid 28155] [client 10.10.1.40:45996] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52, referer: http://10.10.1.40/fog/management/?node=schemaupdater
[Wed Feb 24 15:55:37.283278 2016] [:error] [pid 28155] [client 10.10.1.40:45996] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40, referer: http://10.10.1.40/fog/management/?node=schemaupdater```

[Sebastian Roth]

@ManofValor See it written… “Access denied”. FOG is not able to login to the database. Either the database is not running (ps ax | grep mysql) or your password is screwed: https://wiki.fogproject.org/wiki/index.php/Troubleshoot_MySQL

[ManofValor]

Ok, I tried fog install again and got through all that, thought I put a password for mysql but didn’t, but I got another error. I’ll see if I can figure it out, if not i’ll start another post. Thanks guys.

[Sebastian Roth]

@ManofValor Tom probably found the issue and fixed the code. Can you please upgrade again and see if it works?

[ManofValor]

@Sebastian-Roth Upgrade fog or system upgrade?

[Tom Elliott]

@ManofValor upgrade fog.

[ManofValor]

@Tom-Elliott Should be version 4888, right?

[ManofValor]

[root@localhost bin]# svn up
Updating '.':
At revision 4888.

[Tom Elliott]

@ManofValor you’re in the bin directory you need to go up one directory and run the svn up command then go back to bin and reinstall.

[ManofValor]

@Tom-Elliott oh right, thank you.

[ManofValor]

Just got the same exact output.

[root@localhost trunk]# svn up
Updating '.':
At revision 4888.
[root@localhost trunk]# 

[Tom Elliott]

@ManofValor Have you rerun the installer?

[ManofValor]

@Tom-Elliott Yes. Per my other post I also keep getting this;

 * Press [Enter] key when database is updated/installed.

 * Setting up storage..........................................OK
 * Setting up and starting DHCP Server.........................Error: either "dev" is duplicate, or "Server" is a garbage.
Server: Unknown host
ifconfig: `--help' gives usage information.
../lib/common/functions.sh: line 1757: -o: command not found
grep: Server: No such file or directory
Failed!

[Wayne Workman]

@ManofValor @Developers

I see the error… that’s totally my fault.

the second grep is still written as a variable… I’ll do a pull request with a patch.

[Tom Elliott]

fixed the dev/Server garbage stuff by merging @Wayne-Workman request.

[ManofValor]

@Wayne-Workman @Tom-Elliott I upgraded again but same problem.

 * Press [Enter] key when database is updated/installed.

 * Setting up storage..........................................OK
 * Setting up and starting DHCP Server.........................grep: Server: No such file or directory
Server: Unknown host
ifconfig: `--help' gives usage information.
Error: either "dev" is duplicate, or "Server" is a garbage.
Failed!

Another things is when I click on the fog/management link to update, it goes straight to the login page instead of update page. Is that because of the trouble I have been having with this other stuff?

[Wayne Workman]

@ManofValor PM me when you have time.

[Wayne Workman]

 * Press [Enter] key when database is updated/installed.

 * Setting up storage..........................................OK
 * Setting up and starting DHCP Server.........................grep: Server: No such file or directory
Server: Unknown host
ifconfig: `--help' gives usage information.
Error: either "dev" is duplicate, or "Server" is a garbage.
Failed!

I think the repo data wasn’t totally up to date - but after I got it updated, DHCP still failed - and because the subnet mask was detected incorrectly. This is the exact issue I’ve outlined here:
https://forums.fogproject.org/topic/6779/subnet-incorrectly-detected-for-isc-dhcp

I’ve patched this up totally on a fork, I’m waiting for the @Developers to merge it. With the patch, when users enter a different IP than what is suggested, the subnet mask and interface is recalculated to match the given IP, so too is the interface if something other than what is suggested is supplied.

Also, I’ve implemented intelligent code that finds all interfaces and tests each one for internet access - the first one that succeeds these tests is what’s suggested to the user. Fix can be found here till the devs merge it, then I’ll delete the fork (as usual):
https://github.com/wayneworkman/fogproject

[Tom Elliott]

@Wayne-Workman Code added.