Install/update your database - blank white page

[ManofValor]

Doing a fresh install of FOG svn trunk on CentOS 7 and when I get to the Install/Update your database link I get a blank white page. I did not get any errors during the install and when I go to the IP addr only I get a page that says;

Testing 123…

This page is used to test the proper operation of the Apache HTTP server after it has been installed. If you can read this page it means that this site is working properly. This server is powered by CentOS.

Any info I’m missing that you need? Be back to check on this tomorrow.

Thanks

[Tom Elliott]

Anythign from the apache error logs?

Ubuntu: tail -100 /var/log/apache2/error.log
Redhat: tail -100 /var/log/httpd/error_log

[ManofValor]

@Tom-Elliott I’m on centos BTW, not sure if that matters on the command.

[root@localhost fogadmin]# tail -100 /var/log/apache2/error.log
tail: cannot open ‘/var/log/apache2/error.log’ for reading: No such file or directory
[root@localhost fogadmin]# tail -100 /var/log/httpd/error.logtail: cannot open ‘/var/log/httpd/error.log’ for reading: No such file or directory
[root@localhost fogadmin]# 

[Sebastian Roth]

@ManofValor As Tom said: tail -100 /var/log/httpd/error_log (for RedHat based systems like CentOS)

[ManofValor]

@Sebastian-Roth I did both as you can see.

[ManofValor]

Not sure what I did wrong but:

[root@localhost fogadmin]# tail -100 /var/log/httpd/error_log
[Sun Feb 21 03:26:01.608843 2016] [auth_digest:notice] [pid 1481] AH01757: generating secret for digest authentication ...
[Sun Feb 21 03:26:01.610182 2016] [lbmethod_heartbeat:notice] [pid 1481] AH02282: No slotmem from mod_heartmonitor
[Sun Feb 21 03:26:01.611983 2016] [ssl:warn] [pid 1481] AH02292: Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Sun Feb 21 03:26:01.632996 2016] [mpm_prefork:notice] [pid 1481] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.4.45 configured -- resuming normal operations
[Sun Feb 21 03:26:01.633018 2016] [core:notice] [pid 1481] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'

[Tom Elliott]

@ManofValor error_log is much different from error.log

[ManofValor]

@Tom-Elliott Oops…

[Tom Elliott]

@ManofValor So now that you know how to tail the log, can you “get the blank page” while tailing the log and get us some output?

[ManofValor]

@Tom-Elliott Well this time I got the right screen but when I clicked on Install/Update I got this:

and it just kept going

[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.