Cannot update schema after 0.32 --> 1.1.0 upgrade



  • 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



  • 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]



  • 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.


  • Senior Developer

    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.


  • Senior Developer

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


Log in to reply
 

339
Online

39.3k
Users

11.0k
Topics

104.4k
Posts

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.