i am having a possibly similar issue after upgrading to 1.5.9.
During the install it prompted me that it was changing the fogstorage password. i copied the note which was:
The current fogstorage database password does not meet high
security standards. We will generate a new password and update
all the settings on this FOG server for you. Please take note
of the following credentials that you need to manually update
on all your storage nodes’ /opt/fog/.fogsettings configuration
files and re-run (!) the FOG installer:
snmysqluser=‘fogstorage’
snmysqlpass=‘redacted’
i changed the referenced settings, changing the user to fogstorage from fogmaster. then reran the install as noted. then ran the database update from fog web ui and got error:
Failed to query: Error: SQLSTATE[42000]: Syntax error or access violation: 1142 ALTER command denied to user ‘fogstorage’@‘localhost’ for table ‘nfsGroupMembers’ Error Message: Error Code: “42000”, Error Message: [“42000”,1142,“ALTER command denied to user ‘fogstorage’@‘localhost’ for table ‘nfsGroupMembers’”], Debug: SQL: [92] ALTER TABLE nfsGroupMembers
ADD COLUMN ngmHelloInterval
VARCHAR(8) AFTER `ngmMaxBitrate
in cli (after hitting enter):
Update fogstorage database password…Failed!