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

    Fog getting hung up on Database Schema Installer / Updater

    Scheduled Pinned Locked Moved
    FOG Problems
    5
    9
    6.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.
    • D
      DigitalSauce
      last edited by

      Hello,

      When I went to check the state of my fog server today I connected through the web browser. I was prompted with the Database Schema Installer / Updater. Thinking nothing of it I clicked to have it update. Unfortunately now I get prompted with it every time I connect. I never get to log in. If I reboot my sever I have a small window of time where I can connect and log into the web management, but it will quickly boot me off to update Schema.

      Any help would be great.

      1 Reply Last reply Reply Quote 0
      • M
        Michael Mullins
        last edited by

        I reinstalled Unbuntu and Fog today because of a Multicast issue. It updated like it was supposed to. I then tried another multicast which failed. After that, same problem your having. I tried restarting MySQL, but it fails. Reboot also doesn’t work.

        1 Reply Last reply Reply Quote 0
        • N
          NickConrad
          last edited by

          [quote=“DigitalSauce, post: 30571, member: 24673”]Hello,

          When I went to check the state of my fog server today I connected through the web browser. I was prompted with the Database Schema Installer / Updater. Thinking nothing of it I clicked to have it update. Unfortunately now I get prompted with it every time I connect. I never get to log in. If I reboot my sever I have a small window of time where I can connect and log into the web management, but it will quickly boot me off to update Schema.

          Any help would be great.[/quote]

          [CODE]sudo service mysql restart[/CODE]

          This resolved the same issue when I saw it yesterday.

          1 Reply Last reply Reply Quote 0
          • M
            Michael Mullins
            last edited by

            For me MySQL would not restart after it did this.

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

              Try this:
              [url]https://github.com/mastacontrola/fogproject/issues/1[/url]

              Then try restarting mysql.

              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
                tlawson
                last edited by

                Hello,

                I have this same issue however the suggested fix in [url]https://github.com/mastacontrola/fogproject/issues/1[/url] does not solve the issue.

                EDIT: Also i can no longer see the iPXE boot menu as described here:
                [url]http://fogproject.org/forum/threads/database-update-failed-1-1-0-to-1-1-1.10809/#post-30568[/url]

                and my apache error log shows the following when i try and run the update:
                [Wed Jun 18 10:26:44 2014] [error] [client 10.50.253.181] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 89
                [Wed Jun 18 10:26:44 2014] [error] [client 10.50.253.181] PHP Warning: MySQL::sqlerror(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 180

                Thanks,
                Taylor Lawson

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

                  Can you give these steps a shot as well?
                  [url]http://howterrorisminindia.blogspot.com/2013/03/error-2002-hy000-cant-connect-to-local.html[/url]

                  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
                    tlawson
                    last edited by

                    [quote=“Tom Elliott, post: 30629, member: 7271”]Can you give these steps a shot as well?
                    [url]http://howterrorisminindia.blogspot.com/2013/03/error-2002-hy000-cant-connect-to-local.html[/url][/quote]

                    The path mentioned in this that needs to be linked already exists and the ps -aux shows up with no .socks files.

                    This part is a little out of my normal field so sorry if i am missing something.

                    Thanks,
                    Taylor Lawson

                    1 Reply Last reply Reply Quote 0
                    • T
                      tlawson
                      last edited by

                      However the extra steps mentioned here [url]http://fogproject.org/forum/threads/database-update-failed-1-1-0-to-1-1-1.10809/#post-30630[/url] did fix the issue. Seems like /var/www/fog/lib/fog/Config.class.php had a randomly generated password in it for the database the same as /opt/fog/.fogsettings.

                      Thanks,
                      Taylor Lawson

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

                      187

                      Online

                      12.0k

                      Users

                      17.3k

                      Topics

                      155.2k

                      Posts
                      Copyright © 2012-2024 FOG Project