Posts made by John Hough

Did some more troubleshooting based on those Apache errors, I did a diff between the DatabaseManager.class.php between the versions and noticed the changes in where it is checking for the DATABASE_TYPE. I went into the Config.class.php that is used with 1.1.2 and found a static password entry for the root user when connecting to the MySQL database. I removed the static password leaving just the “” on the line, I then loaded up the page and the database update processed without problems.

I am experiencing the same issue, if I reinstall 1.1.1 I can get back in. While trouble shooting it I made copies of my before and after .fogsettings file in the /opt/fog directory and noticed a couple of things.

First this is the one from the 1.1.1 installation:

Created by the FOG Installer

Version: 1.1.1

Install time: Thu 26 Jun 2014 10:56:41 AM MDT

ipaddress=“172.16.0.13”;
interface=“bond0”;
routeraddress=“# option routers x.x.x.x;”;
plainrouter=“”;
dnsaddress=“# option domain-name-servers x.x.x.x; “;
dnsbootimage=””;
password=“b5a9cd”;
osid=“2”;
osname=“Debian”;
dodhcp=“n”;
bldhcp=“0”;
installtype=“N”;
snmysqluser=“root”;
snmysqlpass=“”;
snmysqlhost=“localhost”;
installlang=“0”;
donate=“1”;
fogupdateloaded=“1”

Next is the one after 1.1.2 was installed:

Created by the FOG Installer

Version: 1.1.1

Install time: Thu 26 Jun 2014 11:12:18 AM MDT

ipaddress=“172.16.0.13”;
interface=“bond0”;
routeraddress=“# option routers x.x.x.x;”;
plainrouter=“”;
dnsaddress=“# option domain-name-servers x.x.x.x; “;
dnsbootimage=””;
password=“a41d31”;
osid=“2”;
osname=“Debian”;
dodhcp=“n”;
bldhcp=“0”;
installtype=“N”;
snmysqluser=“root”
snmysqlpass=“a41d31”;
snmysqlhost=“localhost”;
installlang=“0”;
donate=“1”;
fogupdateloaded=“1”

The installer changed the password entries and I noticed the semicolon is missing after the mysqluser line as well as the fogupdateloaded line.

However I do not believe that this is the problem, my apache2 error log fills up with these errors with 1.1.2 installed and not with 1.1.1 installed.

[Thu Jun 26 11:49:59.404576 2014] [:error] [pid 4933] [client 172.16.3.24:52333] PHP Warning: MySQL::sqlerror(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 180
[Thu Jun 26 11:49:59.404833 2014] [:error] [pid 4933] [client 172.16.3.24:52333] PHP Warning: mysqli::escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 247
[Thu Jun 26 11:49:59.404906 2014] [:error] [pid 4933] [client 172.16.3.24:52333] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 89
[Thu Jun 26 11:49:59.404946 2014] [:error] [pid 4933] [client 172.16.3.24:52333] PHP Warning: MySQL::sqlerror(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 180