Update FOG to 1.4.4 from 1.3.x and FOG can't load

[george1421]

@elias-santiago My question was more about, does your fog server use a proxy to reach the internet, where you set http_proxy=<server_ip>:<port> if that was the case then you need to be sure to include the no_proxy clause or you will get the backup error. But since your fog server can reach the internet directly this isn’t the cause of your error.

[george1421]

@elias-santiago In the same directory as the installfog.sh script, there is a log directory. In that directory there should be an error log file for the version you are currently installing. See if that log file contains why the backup failed.

[Elias Santiago]

@george1421 I have never set the proxy setting, in what file do I find it?

The fog server connects directly to internet.

[Elias Santiago]

@george1421 There seems to be some issue with mysql (never had it before), there is a line in the installer error log that says:

ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)

How do I fix that? I know my way around servers and everything, but in Unix I’m still somewhat of a novice.

[Elias Santiago]

@george1421 said in Update FOG to 1.4.4 from 1.3.x and FOG can't load:

@elias-santiago has the database password changed for some reason? Have you changed the root user mysql password?

If you look in the file /opt/fog/.fogsettings. There should be the mysql user ID and password listed there. See if you can use that to login to the mysql console with mysql -u root -p fog and when prompted use the mysql password listed in the .fogsettings file.

Since you are also running ubuntu you may want to review this post: https://forums.fogproject.org/topic/10006/ubuntu-is-fog-s-enemy

I already did what you recommended about Ubuntu.

[george1421]

@elias-santiago just to confirm one more time. You know the password to log into mysql using mysql -u root -p fog right? If you can have your confirmed in your /opt/fog/.fogsettings file that snmysqluser='root' and snmysqlpass= the password you used to login to mysql and snmysqlhost='127.0.0.1'

There is something wrong here. The error says the .fogsettings file is wrong.

[Elias Santiago]

@george1421 said in Update FOG to 1.4.4 from 1.3.x and FOG can't load:

@elias-santiago just to confirm one more time. You know the password to log into mysql using mysql -u root -p fog right? If you can have your confirmed in your /opt/fog/.fogsettings file that snmysqluser='root' and snmysqlpass= the password you used to login to mysql and snmysqlhost='127.0.0.1'

There is something wrong here. The error says the .fogsettings file is wrong.

snmysqlhost = ‘localhost’

NOT ‘127.0.0.1’

[Elias Santiago]

@george1421 something weird is going on. After I did the Ubuntu stuff you mentioned (removing the unattended-updates) I can’t login to mysql using the same line and password as before!

How do I fix that?

[Elias Santiago]

@george1421 I tried mysql -u root -p fog now and can’t login! This was after removing the “unattended-updates” from Ubuntu.

[george1421]

@elias-santiago As part of that post did you also execute the ALTER user command? If so the password for the root user is now <blank>.

If you can no longer log into the mysql server using a known password (or blank) then you will need to follow the process to reset the root account for mysql: https://support.rackspace.com/how-to/mysql-resetting-a-lost-mysql-root-password/

[Elias Santiago]

@george1421 I did run the ALTER user part.

I’m trying the mysql reset password, it should be the mysql password in the .fogsettings file or it should be ‘fog’ (since the line shows “mysqld -u root -p fog” ??

[Elias Santiago]

When I setup this server, I setup the user ‘cit’ as the root user. Could that be it?

What FOG requires the root user password to be? I don’t mean the mysql password but the actual root USER password?

[Sebastian Roth]

@Elias-Santiago AFAIK this issue has nothing to do with system user accounts. Don’t confuse those with mysql accounts.

… or it should be ‘fog’ (since the line shows “mysqld -u root -p fog” ??

No, see the mysql command line syntax: mysql -u <MYSQL_USERNAME> -p <DATABASE_NAME> (the -p simply tells mysql to ask you for a password on the console to use to connect to the database - would be trying without password otherwise!)

[Elias Santiago]

george1421 managed to fix my setup. For some reason there were concurrent mysql daemons running. After closing all mysqld’s, we tried again and everything went perfectly with the installer. Thank you so much george1421 for your help!

[george1421]

I worked with the OP over DM for quite a while and then setup a TV session. The root cause here is that ubuntu is the enemy of fog (bug). Then during the execution of the ALTER USER step in the link I provided below the password for the mysql root user became confused. We ran through the mysql root user password reset process to reset the password which worked. But the upgrade still failed to backup the current database. Long story short, there was a second background mysql process running causing the process the fog installer was managing to fail causing the backup of the database to fail. Once we found this back ground mysql process running we killed it and then restarted mysql. This time the install succeeded as designed.

Case closed.