Problem updating fog: Backing up Database ... failed

[Sebastian Roth]

@K-Hays What do you see in the last 20 lines of the install logs (/path/to/checked/out/fogproject/bin/error_log/…)??

[K.Hays]

@Sebastian-Roth

The script you are attempting to invoke has been converted to an Upstart
job, but lsb-header is not supported for Upstart jobs.
insserv: warning: script 'friendly-recovery' missing LSB tags and overrides
insserv: Default-Start undefined, assuming empty start runlevel(s) for script `friendly-recovery'
insserv: Default-Stop  undefined, assuming empty stop  runlevel(s) for script `friendly-recovery'
The script you are attempting to invoke has been converted to an Upstart
job, but lsb-header is not supported for Upstart jobs.
insserv: warning: script 'cron' missing LSB tags and overrides
insserv: Default-Start undefined, assuming empty start runlevel(s) for script `cron'
insserv: Default-Stop  undefined, assuming empty stop  runlevel(s) for script `cron'
 * Starting FOG Computer Imaging Solution: FOGMulticastManager
   ...fail!
 * Starting FOG Computer Imaging Solution: FOGImageReplicator
   ...fail!
 * Starting FOG Computer Imaging Solution: FOGSnapinReplicator
   ...fail!
 * Starting FOG Computer Imaging Solution: FOGScheduler
   ...fail!
 * Starting FOG Computer Imaging Solution: FOGPingHosts
   ...fail!
 * Stopping NFS kernel daemon
   ...done.
 * Unexporting directories for NFS kernel daemon...
   ...done.
 * Exporting directories for NFS kernel daemon...
   ...done.
 * Starting NFS kernel daemon
   ...done.

This is the other error log. There is two, one for the new version which i posted below, and one for the old version which is posted here.

[K.Hays]

@Sebastian-Roth Im currently on Version 7084, and was trying to upgrade to 1.3.0-RC-8.

[Quazz]

@K.Hays Could you post your /opt/fog/.fogsettings file here?

[K.Hays]

This post is deleted!

[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