Problem with new FOG 1.5.9 installation
If you install fog 1.5.9, this is the problem:
Update fogstorage database password.........................Failed! Starting The PHP 7.3 FastCGI Process Manager... Nov 15 06:00:03 backup systemd: Started The PHP 7.3 FastCGI Process Manager. ERROR 1146 (42S02) at line 1: Table 'fog.globalSettings' doesn't exist
in mysql logs
2020-11-15 6:55:07 40 [Warning] Access denied for user 'fogmaster'@'localhost' (using password: YES) 2020-11-15 6:55:07 41 [Warning] Access denied for user 'fogstorage'@'localhost' (using password: NO)
The problem occurs on Ubuntu 16.04 -20.04, as well as on Debian 10.06.
Can you please tell me what you can do?
on all your storage nodes
This is not for your FOG master node. Hope you have a copy of the old fogsettings file or we might be able to get the last fogmaster DB credentials from a backup of the config.class.php file in /home/fog_web_1.5.9.BACKUP/…
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:
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: 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:  ALTER TABLE
ngmHelloIntervalVARCHAR(8) AFTER `ngmMaxBitrate
in cli (after hitting enter):
Update fogstorage database password…Failed!
@filisdiez At one point the installer waits for your action. You are asked to open the FOG web UI to update the schema (create the database layout and populate it). As far as I see this error occurs if you don’t do the schema update but proceed with the installer.