• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • 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.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
    DigitalSauce
    last edited by Jun 17, 2014, 6:35 PM

    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 Jun 17, 2014, 7:50 PM

      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 Jun 17, 2014, 7:56 PM

        [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 Jun 17, 2014, 8:02 PM

          For me MySQL would not restart after it did this.

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

            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 Jun 18, 2014, 12:24 AM

              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
              • T
                Tom Elliott
                last edited by Jun 18, 2014, 1:18 AM

                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 Jun 18, 2014, 1:50 AM

                  [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 Jun 18, 2014, 1:56 AM

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

                    128

                    Online

                    12.2k

                    Users

                    17.4k

                    Topics

                    155.5k

                    Posts
                    Copyright © 2012-2024 FOG Project