Cannot update schema after 0.32 --> 1.1.0 upgrade

[skooltech]

Hi there,

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!

Jeff

[Tom Elliott]

Try:
[code]sudo service mysql restart[/code]

[skooltech]

I’ve restarted mysql and then restarted the server itself for good measure. No luck.

[Tom Elliott]

Is the password set in /var/www/fog/commons/config.php db_settings?

[T3charmy]

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.

[skooltech]

Hi Tom,

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:
[CODE]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 )[/CODE]

Thanks again!

Jeff

[COLOR=#555555] [/COLOR]