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

    Strange error: Just booted my fog server got database installer / updater

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    3
    6
    1.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.
    • J
      Julianh
      last edited by

      Hi All,

      I just booted up my physical fog server, connected to it and got the “Database Schema installer/updater” screen. But I haven’t changed anything. I’ve left it untouched. I have loads of images on it, 120+. so I really don’t want to lose the database.

      I tried
      cd ~;mysqldump --allow-keywords -x -v fog > fogbackup.sql

      to back it up, but got the error

      – Connecting to localhost…
      mysqldump: Got error: 2002: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) when trying to connect
      root@fog1:~#

      This couldn’t have come at a worse time, as I’m supposed to deploy some images tonight, change them, image them up, then re image the servers back with another image.

      Could someone offer me a little help in backing up the database, and then fixing it.

      Thanks

      Julian

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

        Try restarting MySQL.

        I think restarting MySQL might actually fix your issue.

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

          What’s the output of

          sudo df -h
          

          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
          • J
            Julianh
            last edited by

            Thanks Wayne & Tom,

            I issued the “reboot” command to reboot the Fog server, hoping the SQL server would restart with it, but unfortunatley it didn’t.

            I restarted the SQL server, but it failed to initialize, I can’t remember the exact error, but it was basically not enough disk space.

            I was imaging up a load of servers last time, the disk was at 90%+ full. So I guess the SQL service didn’t have enough space to initialize. I deleted some images, which I’ve copied to a USB drive, rebooted the server, hey presto it all came up ok.

            First problem solved. 🙂

            So it looks like I’m adding another 4TB disk to the server.

            I looked up this guide, is it still relevant to version 1.20?

            https://wiki.fogproject.org/wiki//index.php?title=Adding_Storage_to_a_FOG_Server

            Thanks again, your help is much apprechiated.

            Can this be marked as solved, to help the next person.

            Thanks

            Julian

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

              This post is deleted!
              1 Reply Last reply Reply Quote 0
              • Wayne WorkmanW
                Wayne Workman
                last edited by Wayne Workman

                There might be relevant parts in that article, but it was last updated in 2011.

                I should re-write it… I’ll put it on my to-do list (I actually have a to-do list here).

                If you can get another HDD in, format it, mount it, etc, you could simply add a new storage node and point the path to your new HDD. Set your permissions on that new directory as 777 and it ought to work.

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

                170

                Online

                12.1k

                Users

                17.3k

                Topics

                155.3k

                Posts
                Copyright © 2012-2024 FOG Project