Problem updating fog: Backing up Database ... failed

[K.Hays]

@Sebastian-Roth That got me further! But when i got to the Updating database schema there is no update option on the web page.

[Wayne Workman]

@K.Hays I suspect db issues. Try to connect to the DB, use the credentials in your .fogsettings file.

mysql -u fog -h fog -pfoggy -D fog
Note that no space between -p and foggy is intentional.

The snmysqlhost being set to fog is suspicious… normally this is left blank, is set to localhost or 127.0.0.1 for the main server.

[K.Hays]

@Wayne-Workman it said unknown host

[Wayne Workman]

@K.Hays Now try mysql -u fog -pfoggy -D fog

[K.Hays]

@Wayne-Workman Access denied for user ‘fog’@‘localhost’ (using password: YES)
d430@

[Wayne Workman]

@K.Hays Ok, now try mysql -u root -D fog

[K.Hays]

@Wayne-Workman that worked, as in it let me in mysql

[Wayne Workman]

@K.Hays Ok. then inside of /opt/fog/.fogsettings set snmysqluser to root, and blank out snmysqlpass and snmysqlhost, re-run the installer, and you should be good to go.

[K.Hays]

@Wayne-Workman That worked! Any idea to what caused this whole thing? Im going to have to update my other servers, and obviously this one in the future and would like to avoid this whole ordeal again haha

[Wayne Workman]

@K.Hays said in Problem updating fog: Backing up Database ... failed:

Any idea to what caused this whole thing?

Somebody messed with the .fogsettings file and put in the wrong information. If things in there are wrong and you update - things in fog will be wrong.

For you and future readers, information on the .fogsettings file and passwords are in these two articles:
https://wiki.fogproject.org/wiki/index.php?title=.fogsettings
https://wiki.fogproject.org/wiki/index.php?title=Password_Central

[K.Hays]

@Wayne-Workman Ok ill be sure to look for that in the future. Thanks to everyone who helped! Ill be sure too update frequently now haha