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:

    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` )
    

    Thanks again!

    Jeff



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

    sudo service mysql restart
    

Log in to reply
 

473
Online

38916
Users

10688
Topics

101382
Posts

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