• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

Cannot update schema after 0.32 --> 1.1.0 upgrade

Scheduled Pinned Locked Moved
FOG Problems
3
6
1.6k
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S
    skooltech
    last edited by Jun 12, 2014, 8:53 PM

    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

    1 Reply Last reply Reply Quote 0
    • T
      Tom Elliott
      last edited by Jun 12, 2014, 8:54 PM

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

      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

      1 Reply Last reply Reply Quote 0
      • S
        skooltech
        last edited by Jun 12, 2014, 9:09 PM

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

        1 Reply Last reply Reply Quote 0
        • T
          Tom Elliott
          last edited by Jun 13, 2014, 4:46 PM

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

          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

          1 Reply Last reply Reply Quote 0
          • T
            T3charmy
            last edited by Jun 13, 2014, 4:54 PM

            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.

            1 Reply Last reply Reply Quote 0
            • S
              skooltech
              last edited by Jun 13, 2014, 5:47 PM

              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]

              1 Reply Last reply Reply Quote 0
              • 1 / 1
              1 / 1
              • First post
                5/6
                Last post

              165

              Online

              12.0k

              Users

              17.3k

              Topics

              155.2k

              Posts
              Copyright © 2012-2024 FOG Project