Fog upgrade 1.1.1 --> 1.1.2 database error

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

[RipAU]

Ahhh yep, fixing up the root password and localhost fixed the issue.
I was confused as it seemed to work perfect the way it was on previous installations.

Thank you very much. I’ll start the upgrade on my storage nodes now as well.

[hariskar]

I had the same issue because during installation in the last message I pressed Enter without reading it. But the message was first to update database and then press enter. So I uninstalled fog and reinstalled correctly.

[darkxeno]

This post is deleted!

[darkxeno]

Im have the same issue but updating my setting didnt help me at all

[darkxeno]

just fixed it I went in to the /var/www/fog/lib/fog/Config.class.php and removed the password from there and it fixed it

[Rui Araújo]

[quote=“darkxeno, post: 31683, member: 4011”]just fixed it I went in to the /var/www/fog/lib/fog/Config.class.php and removed the password from there and it fixed it[/quote]
Thank you so much! It solved my problem too!

[darkxeno]

[quote=“Rui Araújo, post: 31804, member: 24515”]Thank you so much! It solved my problem too! :D[/quote]
no problem anything to help

[Bob Martens]

Thank you for the thread! This just saved me hours of work!

[Bob Martens]

It looks like now that it is updated, it is still going to the scheme updater package. How can I get back to my login screen?

[Bob Martens]

This one is done. Now I’m working on the non-booting machines issues.

[Quintin Giesbrecht]

[quote=“darkxeno, post: 31683, member: 4011”]just fixed it I went in to the /var/www/fog/lib/fog/Config.class.php and removed the password from there and it fixed it[/quote]

Thanks! that did it for me as well.

[Will-TGS]

I had the same problem as RipAU; 100+ database errors when attempting v1.1.1 > v1.1.2 upgrade.

As John Hough found, my [I].fogsettings[/I] file (located at /opt/fog/) was as follows:
[CODE]ipaddress=“10.0.115.43”;
interface=“eth0”;
routeraddress=" option routers 10.0.115.254;“;
plainrouter=“10.0.115.254”;
dnsaddress=” option domain-name-servers 10.0.115.4; “;
dnsbootimage=“10.0.115.4”;
password=“98180b”;
osid=“2”;
osname=“Debian”;
dodhcp=“n”;
bldhcp=“0”;
installtype=“N”;
snmysqluser=”"
snmysqlpass=“98180b”;
snmysqlhost=“”;
installlang=“0”;
donate=“0”;
fogupdateloaded=“1”[/CODE]
The problems were obvious, particularly [I]routeraddress, dnsaddress, snmysqluser, snmysqlpass[/I] (I never set one?) and some semicolons in the wrong place, so I amended the file to look like:
[CODE]ipaddress=“10.0.115.43”;
interface=“eth0”;
routeraddress=“10.0.115.254”;
plainrouter=“10.0.115.254”;
dnsaddress=“10.0.115.4”;
dnsbootimage=“10.0.115.4”;
password=“”;
osid=“2”;
osname=“Debian”;
dodhcp=“n”;
bldhcp=“0”;
installtype=“N”;
snmysqluser=“root”
snmysqlpass=“”;
snmysqlhost=“localhost”;
installlang=“0”;
donate=“0”;
fogupdateloaded=“1”[/CODE]

I ran [I]./install.sh[/I] again and the upgrade went OK.

As Tom Elliot said, he fixed a many installer errors, but not all. Kudos to Tom for keeping FOG development going

[Matthew Gicking]

This post is deleted!

[Robbie McHugh]

Simple logical fix, as always thanks for the continued progress guys

[Excel Group]

Can confirm I edited the .fogsettings and Config.class.php files and the database then upgraded perfect fine, just editing the .fogsettings still wasn’t working hence changing the Config too.