Cannot update schema after 0.32 --> 1.1.0 upgrade
I successfully (I thought) ran the install script for 1.1.0 on my Ubuntu 12.04 server, but when I go to the management page to update the database schema, I click the button and get “Update/Install Failed!” and a whole slew of errors.
I don’t know if it’s related or not, but when using mysqldump to back up the database as advised on the fog database schema update page, I had to specify the root user name and password in order to get it to work.
[INDENT=1]sudo mysqldump --allow-keywords -x -v fog>fogbackup.sql didn’t work (“Got error: 1045 Access denied for user ‘root’@‘localhost’ (using password: NO) when trying to connect”)[/INDENT]
[INDENT=1]sudo mysqldump --allow-keywords -x -v -uroot -p[password] fog>fogbackup.sql worked like a champ![/INDENT]
Any help would be greatly appreciated!
Thanks for that! Adding the password to the correct config.php file was the ticket! I was able to do the schema update with only this (hopefully inconsequential) error:
The following errors occured Update ID: 36 - 5 Database Error: Duplicate entry '400-28' for key 'gmHostID' Database SQL: ALTER TABLE `fog`.`groupMembers` ADD UNIQUE ( `gmHostID`, `gmGroupID` )
I notice everytime I restart the server in order to get fog to work I need to restart the MySQL service after the server is fully booted. That might just be an issue with Ubuntu 14.04. Just a thought to try.
Is the password set in /var/www/fog/commons/config.php db_settings?
I’ve restarted mysql and then restarted the server itself for good measure. No luck.
sudo service mysql restart