Fog upgrade 1.1.1 --> 1.1.2 database error
-
This is more of a workaround than a solution
I had the same issue with the installer, the mysql configuration in /var/www/html/fog/lib/fog/Config.class.php ended up being incorrect this led to the upgrade script in the fog GUI not detecting my current settings and trying to do a CREATE as in the first post. Putting the correct information allowed the update script to complete successfully.
-
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.
-
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.
-
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.
-
This post is deleted! -
Im have the same issue but updating my setting didnt help me at all
-
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=“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!
-
[quote=“Rui Araújo, post: 31804, member: 24515”]Thank you so much! It solved my problem too! :D[/quote]
no problem anything to help -
Thank you for the thread! This just saved me hours of work!
-
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?
-
This one is done. Now I’m working on the non-booting machines issues.
-
[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.
-
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
-
This post is deleted! -
Simple logical fix, as always thanks for the continued progress guys
-
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.
