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

FOG Is Inoperable After Server Reboot

Scheduled Pinned Locked Moved
FOG Problems
6
10
8.5k
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.
  • B
    BanjoZach
    last edited by Aug 18, 2014, 3:49 PM

    Hello. I am new to Ubuntu and FOG, however I have learned a great deal about both in the past week. Does anyone know why I get asked to Update the Database Schema for a second time, after I reboot the server? I have installed clean versions of Ubuntu 13 and 14.04 (Latest Version), as well as clean installs of FOG (1.2.0 and 1.1.0) multiple times. I install FOG, install the schema, and everything works fine, untill I reboot the server. Once I do this, the FOG webpage tells me to update my schema again. If I click ‘Download and Install Schema’ it then gives me a very long page of what appears to be mysql errors. I have beat my head against the wall with this issue. By default, I have NOT been using a mysql password, but I have tried it both ways. Also, I am logged in as ‘Root’ when installing FOG.

    Thank you for your help in advance.

    1 Reply Last reply Reply Quote 0
    • A
      Andy Abplanalp Developer
      last edited by Aug 18, 2014, 3:58 PM

      run “service mysql restart” after the reboot and see if you can get in

      1 Reply Last reply Reply Quote 0
      • B
        BanjoZach
        last edited by Aug 18, 2014, 4:02 PM

        I’ll try that. Thank you.

        But if im not mistaken, I think I have tried that, and I get a message saying something regarding mysql not being installed.

        1 Reply Last reply Reply Quote 0
        • A
          Andy Abplanalp Developer
          last edited by Aug 18, 2014, 4:06 PM

          If that works, chances are you’ll have to run “service FOGMulticastManager restart && service FOGImageReplicator restart && service FOGScheduler restart” to get everything running properly.

          1 Reply Last reply Reply Quote 0
          • B
            BanjoZach
            last edited by Aug 18, 2014, 4:09 PM

            That’s kinda weird. Is there anything I can do so I don’t have to do this every time? Perhaps an older version? I guess it could be a problem with the MySQL that Ubuntu downloads during install.

            1 Reply Last reply Reply Quote 0
            • M
              madskillz23
              last edited by Aug 18, 2014, 4:25 PM

              [CODE]chkconfig --levels 235 mysqld on [/CODE]

              That will do it assuming mysql is installed correctly. If not manually install mysql then run that command.

              1 Reply Last reply Reply Quote 0
              • B
                BanjoZach
                last edited by Aug 18, 2014, 9:43 PM

                Ok, it did it again. Here is a screenshot after the server reboot. It wants me to update the schema again. When I try, this is what it gives me. And it’s pages long…

                [url=“/_imported_xf_attachments/1/1298_Screenshot from 2014-08-18 16:43:16.png?:”]Screenshot from 2014-08-18 16:43:16.png[/url]

                1 Reply Last reply Reply Quote 0
                • C
                  cadyfish
                  last edited by Aug 19, 2014, 1:56 AM

                  Banjo,

                  That error occurs when the SQL database information doesn’t match what is in fog. This is what I would suggest doing.
                  [LIST]
                  []Open up [CODE]sudo nano /var/www/fog/lib/fog/Config.class.php[/CODE]
                  [LIST]
                  [
                  ]Notate both the host, username & password
                  [/LIST]
                  []Open up [CODE]sudo nano /opt/fog/.fogsettings[/CODE]
                  [LIST]
                  [
                  ]Fill in the following portions
                  [/LIST]
                  [/LIST]
                  snmysqluser=“{root}”
                  snmysqlpass=“{password if you have one}”
                  snmysqlhost=“{localhost}”
                  [LIST]
                  []Reset the mySQL database password to be what is in the config files
                  [LIST]
                  [
                  ]run [CODE]sudo dpkg-reconfigure mysql-server-5.5[/CODE] replace the last two numbers if using a different version of mySQL
                  [*]enter in the new password
                  [/LIST]
                  [/LIST]
                  If you still have issues re-run the installer. I tested with a VM using 14.04 and it resolved the same issue

                  W 1 Reply Last reply Aug 5, 2015, 2:28 AM Reply Quote 2
                  • M
                    Michael Dutcher
                    last edited by Sep 30, 2014, 12:08 AM

                    I just wanted to say that the reconfiguring of the MySQL database did it for me after I had this error following a kernel update. The kernel update fixed an issue I was having with [FONT=Calibri][COLOR=#000000]kswapd0 running my CPU to 100%. Now my server’s cpu is running at expected norms and my server is functioning normal. Thanks![/COLOR][/FONT]

                    1 Reply Last reply Reply Quote 0
                    • W
                      Wayne Workman @cadyfish
                      last edited by Wayne Workman Aug 4, 2015, 8:29 PM Aug 5, 2015, 2:28 AM

                      @cadyfish Thank you for your answer greatly. This post has been added to the WiKi here: https://wiki.fogproject.org/wiki/index.php/Troubleshoot_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!
                      Daily Clean Installation Results:
                      https://fogtesting.fogproject.us/
                      FOG Reporting:
                      https://fog-external-reporting-results.fogproject.us/

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

                      155

                      Online

                      12.0k

                      Users

                      17.3k

                      Topics

                      155.2k

                      Posts
                      Copyright © 2012-2024 FOG Project