Problem updating fog: Backing up Database ... failed

[K.Hays]

This post is deleted!

[Sebastian Roth]

@K-Hays Sorry for the delay. I am preparing to move house these days and don’t get much time for FOG stuff…

Sorry didn’t see that you already posted this:

ln: failed to create symbolic link ‘/var/www/fog/fog’: File exists
...
--2016-08-12 14:22:17--  http://10.40.0.7//fog//maintenance/backup_db.php
Connecting to 10.40.0.7:80... connected.
HTTP request sent, awaiting response... 500 Internal Server Error
2016-08-12 14:22:17 ERROR 500: Internal Server Error.

Maybe something went wrong with those links. If you don’t have any modifications (kernels, initrds or whatever) within /var/www/ then I’d ask you to completely delete those and re-run the installer. See what you have in that directory, possibly there is /var/www/html/fog and /var/www/fog…

[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