Dell Venue 11 Pro

Wayne Workman · Oct 7, 2015, 10:18 PM

After Upgrade to trunk - localhost/fog/management page keeps going to Database Schema Installer / Updater after I completed the update.

I tried a:
service mysql restart

Did you go through the installer completely? It sounds like you didn’t come back to the installation script after updating the database scheme.

Beyond that, Ubuntu 13 and 14 are slightly troublesome with MySQL and FOG only because our developers don’t have time to perfect the installer for those versions. The latest FOG Trunk has been verified to work on Ubuntu 15.04. If you have a reason to stay with Ubuntu 14, you might look towards the bottom of this article and try those steps: https://wiki.fogproject.org/wiki/index.php/Troubleshoot_MySQL

Or, You could do a clean installation using CentOS 7 or Fedora 21 or 22 using this guide: https://wiki.fogproject.org/wiki/index.php/Fedora_21_Server
Personally, I’d recommend going with this option simply because there are less known problems with these distributions. At both work and home, I use Fedora 21, but I know FOG Trunk works fine on Fedora 22 and CentOS 7.

Tom Elliott · Oct 8, 2015, 4:55 PM

@dutchers4 more info please? Error logs, and a disk space usage of the fog server would be extremely helpful.

Wayne Workman · Oct 7, 2015, 5:29 PM

Also, @ch3i might be able to help with the errors in Ubuntu 14. The guy is a whiz at Ubuntu.

dutchers4 · Oct 8, 2015, 4:55 PM

@Tom-Elliott As I am very new to Linux (Windows Server and Network Admin) what would be the easiest way to get you the needed information.

Wayne Workman · Oct 8, 2015, 5:00 PM

@dutchers4 for disk usage: df -h

For the logs, I don’t know which ones he’s asking for specifically. https://help.ubuntu.com/community/LinuxLogFiles

If I had to guess, probably Apache logs. /var/log/apache2/error.log so viewing that with something like tail -100 /var/log/apache2/error.log would show you the last 100 lines in the file.

You can post the info here using the codebox tool. It’s right above the text editor box for forum posts.

dutchers4 · Oct 8, 2015, 6:34 PM

[Thu Oct 08 13:31:59.970940 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.970940 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.970977 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971007 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971037 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971066 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971098 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971128 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971157 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971186 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971218 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971252 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971283 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971313 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971342 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971374 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971406 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971436 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971474 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971505 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971538 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.971569 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.991950 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::mysqli(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /var/www/html/fog/lib/db/MySQL.class.php on line 39, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.992012 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::mysqli(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: Name or service not known in /var/www/html/fog/lib/db/MySQL.class.php on line 39, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.992558 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater
[Thu Oct 08 13:31:59.992756 2015] [:error] [pid 26258] [client ::1:52519] PHP Fatal error:  Call to a member function save() on null in /var/www/html/fog/lib/pages/SchemaUpdaterPage.class.php on line 38, referer: http://localhost/fog/management/?node=schemaupdater
hbcadministrator@HBCELGFOG01:~$

dutchers4 · Oct 8, 2015, 6:40 PM

I have 15 GB Free of Disk Space on /dev/sda1 and 1.2 TB Free on /dev/sdb1

Wayne Workman · Oct 8, 2015, 6:54 PM

@dutchers4 Make sure MySQL is running

sudo service mysql restart

dutchers4 · Oct 8, 2015, 1:10 PM

sudo service mysql restart
mysql stop/waiting
mysql start/running, process 31786
hbcadministrator@HBCELGFOG01:~$ sudo tail -25 /var/log/apache2/error.log
[Thu Oct 08 14:03:52.583384 2015] [:error] [pid 31644] [client 10.21.0.61:54362] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://10.21.0.4/fog/management/?node=schemaupdater
[Thu Oct 08 14:03:52.594358 2015] [:error] [pid 31644] [client 10.21.0.61:54362] PHP Warning:  mysqli::real_escape_string(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 191, referer: http://10.21.0.4/fog/management/?node=schemaupdater

I trimmed it down… After Restarting Service

Sebastian Roth · Oct 9, 2015, 11:35 AM

Are you still seeing the update schema page? Looking through the error logs again I noticed this:

... php_network_getaddresses: getaddrinfo failed: Name or service not known ...

Sounds a bit like the hostname cannot be resolved. But as I see in the other errors you have the database on the same host as the webserver (as pretty much everyone else) using localhost as hostname. Maybe your /etc/hosts files is gone wild. Please take a look and post the content of /etc/hosts file on your FOG server.

dutchers4 · Oct 9, 2015, 5:42 PM

127.0.0.1	localhost
127.0.1.1	HBCELGFOG01

# The following lines are desirable for IPv6 capable hosts
::1     localhost ip6-localhost ip6-loopback
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters

Sebastian Roth · Oct 13, 2015, 1:34 AM

@dutchers4 Sorry for taking so long to answer. Your /etc/hosts looks good to me. Re-reading all the posts here and thinking about this a little more I wonder if restarting MySQL just is not enough. See here: https://github.com/fogproject/fogproject/issues/1

dutchers4 · Oct 13, 2015, 8:52 PM

Still no go, Still showing the Database Schema Installer.

Sebastian Roth · Oct 13, 2015, 3:34 PM

Do you still see errors in your apache log?

Maybe try upgrading again and running the FOG install script. Sorry for not having a clear answer. It’s very hard to find an issue not sitting in front of the machine. Need more information.

Edit: MySQL logs to syslog in standard configuration. See what you get from those logs by running this command: grep mysql /var/log/syslog (output might be long! See if you find errors)

Sebastian Roth · Oct 20, 2015, 8:55 AM

@dutchers4 Any news on this?

Wayne Workman · Oct 20, 2015, 10:31 PM

I was really strongly wanting to see this thread solved…

Dell Venue 11 Pro

260

12.0k

17.3k

155.2k