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

    Database Schema Installer / Updater

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    4
    11
    3.8k
    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.
    • D
      Danny R
      last edited by

      Reinstalled FOG yesterday was working fine. I shut the machine down last night. Put it into our rack and booted it backup. Tried to get into it this morning and I’m getting

      Database Schema Installer / Updater

      If I click Install / Upgrade now it just gives tons of SQL errors. The list goes on and on here is one error for example.

      Update ID: 1 - 1

      Database Error:

      Database SQL:

      CREATE TABLE fog.groupMembers (
      gmID int(11) NOT NULL auto_increment,
      gmHostID int(11) NOT NULL,
      gmGroupID int(11) NOT NULL,
      PRIMARY KEY (gmID),
      KEY new_index (gmHostID),
      KEY new_index1 (gmGroupID)
      ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC

      It ends at Update ID: 113-0

      ch3iC Wayne WorkmanW 2 Replies Last reply Reply Quote 0
      • ch3iC
        ch3i Moderator @Danny R
        last edited by ch3i

        @Danny-R Which FOG version ?

        D 1 Reply Last reply Reply Quote 0
        • Wayne WorkmanW
          Wayne Workman
          last edited by

          Sounds like MySQL (or MariaDB) didn’t start up…

          What OS version?

          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!
          Daily Clean Installation Results:
          https://fogtesting.fogproject.us/
          FOG Reporting:
          https://fog-external-reporting-results.fogproject.us/

          D 1 Reply Last reply Reply Quote 0
          • D
            Danny R @ch3i
            last edited by

            @ch3i said:

            @Danny-R Wich FOG version ?

            FOG 1.2.0

            1 Reply Last reply Reply Quote 0
            • D
              Danny R @Wayne Workman
              last edited by

              @Wayne-Workman Ubuntu 14.04

              ch3iC 1 Reply Last reply Reply Quote 0
              • ch3iC
                ch3i Moderator @Danny R
                last edited by ch3i

                @Danny-R Try on your Ubuntu :

                service mysql status | grep "Uptime"
                

                And post the result please.

                D 1 Reply Last reply Reply Quote 0
                • Tom ElliottT
                  Tom Elliott
                  last edited by

                  This issue is well known about particularly on Ubuntu. It isn’t so much the service failed to start, but rather the service crashed later on down the road.

                  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
                  • Wayne WorkmanW
                    Wayne Workman @Danny R
                    last edited by

                    @Danny-R So, in this situation, you should just be able to restart MySQL…

                    service mysql restart
                    

                    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!
                    Daily Clean Installation Results:
                    https://fogtesting.fogproject.us/
                    FOG Reporting:
                    https://fog-external-reporting-results.fogproject.us/

                    D 1 Reply Last reply Reply Quote 0
                    • D
                      Danny R @ch3i
                      last edited by

                      @ch3i That command did not work however a SQL restart resolved the issue.

                      Thanks,

                      1 Reply Last reply Reply Quote 0
                      • D
                        Danny R @Wayne Workman
                        last edited by

                        @Wayne-Workman

                        That did it thanks!

                        Tom ElliottT 1 Reply Last reply Reply Quote 0
                        • Tom ElliottT
                          Tom Elliott @Danny R
                          last edited by

                          @Danny-R

                          To prevent this from happening down the road, you could try following these instructions:
                          https://github.com/fogproject/fogproject/issues/1

                          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
                          • 1 / 1
                          • First post
                            Last post

                          246

                          Online

                          12.0k

                          Users

                          17.3k

                          Topics

                          155.2k

                          Posts
                          Copyright © 2012-2024 FOG Project