Database Schema Installer / Updater Loop

[craigj1222]

We have been using FOG without issue for the last few months, but after we attempted to image a machine, we received a PXE boot error. When I went to login to the web GUI, I saw the following message:

Even if I hit the “Install/Upgrade Now” button, it just loops back to this page. I have tried restarting the MySQL service, FOG server itself, viewed the Apache error log, among many other things from the various forums and threads I’ve found online. The only message that appears in the Apache log is the following:

[Mon Aug 01 14:04:07.919920 2016] [:error] [pid 1320] [client 10.99.1.55:52363] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/html/fog/lib/db/mysql.class.php on line 50, referer: http://fogserver.sappbros.net/fog/management/index.php?node=schemaupdater

Any help would be much appreciated and I’m happy to provide as many logs and as much information as I can. Thanks in advance for your help!

[Tom Elliott]

I see you’re running version 79xx or so, would you try updating to the rc builds? What OS is fog server running.

[craigj1222]

@Tom-Elliott

I appreciate the reply. Yeah, we would definitely be willing to update to a RC version and we are running Ubuntu 16.04.

[Tom Elliott]

@craigj1222 When you install Ubuntu, did you follow a guide?

https://wiki.fogproject.org/wiki/index.php?title=Ubuntu_16.04

[Wayne Workman]

There are extra steps for Ubuntu 16.

First, because you already tried installing fog, you must remove all PHP packages (or format and reinstall Ubuntu 16) After doing that, when you are ready, run the installer with php_ver='7.0' php_verAdds='-7.0' ./installfog.sh When the installer asks you to update the database, there’s 1 extra step. (in another SSH session) Go to mysql and modify the password setting with ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '';
Then you go to the web interface and update the DB as normal, come back to the installer and complete it as usual.

[craigj1222]

@Tom-Elliott

I actually didn’t do the install and the person that did no longer works for our company. My gut says that he followed that exact guide, though, as some of the documentation he “wrote” were snippets from it. It worked for months before we had an issue, so I assumed he had everything setup correctly, but I might be mistaken.

[craigj1222]

@Wayne-Workman

I appreciate all the helpful information about the Ubuntu 16 install.

We actually had FOG working for months before this happened and deployed many images successfully. I’m not entirely sure what changed all of a sudden to cause this because we didn’t go in and do anything except try to deploy another image. We then received this error and when I logged into the GUI, I saw the page I referenced in my first post.

[Wayne Workman]

@craigj1222 check that mysql is running. Check free space on the /images partition.

[craigj1222]

@Wayne-Workman @Tom-Elliott

I checked both and didn’t see any issue. I’m a little hesitant to upgrade to the RC after seeing the exact same issue posted in this thread not being resolved when they did so:
https://forums.fogproject.org/topic/8212/http-service-ipxe-bg-png-error-0x3e11613b-fog-ui-stuck-in-loop/14

[Wayne Workman]

@craigj1222 that’s a completely separate issue. I can offer assistance via Team Viewer, message me.