Upgrade Gone Wrong......

[Arsenal101]

Checked Apache Error log

[Fri Jun 17 07:32:38.645107 2016] [:error] [pid 8300] [client 10.1.100.20:57664] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.ph$

[Tom Elliott]

details…

Version you installed?

OS and version of OS is this system that is having issues?

[Arsenal101]

@Tom-Elliott Sorry On Ubuntu Server 12.04 LTS

When I type git log i get this:

root@SAU-FOG:~/fogproject# git log -1
commit 6882c92a66ad1be84433095f651d2c51acda058c
Merge: 4c19c7c ac0de27
Author: Tom Elliott tommygunsster@gmail.com
Date: Fri Jun 17 07:50:34 2016 -0400

Merge svn with dev-branch

root@SAU-FOG:~/fogproject#

[Quazz]

Just a guess but try

sudo ufw disable

[Arsenal101]

@Quazz No go, Same error

[Sebastian Roth]

@Arsenal101 said:

PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php

You DB does not seem to run properly. service mysql status, ps aux | grep mysql and see if you are able to connect using the command line client mysql -u root -p

[Arsenal101]

@Sebastian-Roth When I run the first command you mentioned It says:

root@SAU-FOG:~/fogproject/bin# service mysql, ps aux | grep mysql
utility, e.g. service mysql ps
The script you are attempting to invoke has been converted to an Upstart
job, but ps is not supported for Upstart jobs.

Maybe I am entering it wrong. Still kind of lame at linux

[Arsenal101]

@Sebastian-Roth I can connect to mysql no problem though.

[Quazz]

@Arsenal101 They’re two separate commands.

[Arsenal101]

@Quazz Still doesnt like it… I have tried Service mysql status - comes back with service running and the PID,

service mysql ps aux comes back with the upstart job error.
service mysql ps same…
service mysql aux same…

I am at a loss

If I do a tail /var/log/apache2/error.log i get serveral lines all the same error PHP Fatal Error Class 'System" not found in /var/www/fog/commons/init.php

???

[Tom Elliott]

@Arsenal101 What version did you install?

[Arsenal101]

@Tom-Elliott Should be the latest SVN 5705 i think.

I just found this https://forums.fogproject.org/topic/6298/fatal-error-message-when-opening-the-fog-page-http-ip-fog-management

Which looks like the problem I am having? I am just not sure exactly how to remedy it.

[Tom Elliott]

@Arsenal101 You think?

What does it show on the GUI? Top left next to (maybe inside) the cloud.

[Arsenal101]

@Tom-Elliott I can’t get to the GUI… I get a PHP error 500 and the page wont load. So I am not sure.

[Tom Elliott]

@Arsenal101 Okay, try this:

rm -rf /var/www/fog /var/www/html/fog

Re-run the installer.

[Arsenal101]

@Tom-Elliott You’re then MAN!!!

That did it. Once I was able to get the GUI back up it said that It couldn’t communicate with the database. I was able to connect with the database using root and blank password but when I checked the config.class.php I had some text where the password field is. I wiped that out, saved it and refreshed the page and it was asking me to update the database Schema which it should. I took a SQL backup and updated it.

Should be back up and running. downloading an image now! Maybe that will fix my slow imaging problem too who knows.

[Tom Elliott]

@Arsenal101 To ensure all goes smoothly on the next upgrade, edit the /opt/fog/.fogsettings file.

Look at the snmysqluser= snmysqlpass= and snmysqlhost fields and make sure they’re set properly.

In your case:

snmysqluser='root'
snmysqlpass=''
snmysqlhost='IP/Hostname of FOG here'