FOG Project

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

    Database connection unavailable

    FOG Problems
    2
    9
    117
    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.
    • S
      Sunks last edited by

      Hello,

      My web interface of fog is suddenly no longer accessible. Everything was wirking fine yesterday, i uploaded an image and today i got MariaDB error. I recently Updated/Compiled the latest version of iPXE with the fog tutorial, maybe its related ?

      My fog is version 1.5.9 installed on ubuntu 18.04.4

      The command “systemctl status mariadb.service” result :
      0552faa4-93b0-4089-9cec-b4289410eb2a-image.png

      When i rerun the installer i get this :
      9676ce40-4888-4408-8d1d-9662bdcb6701-image.png

      Got no idea what to do with that.
      Thanks!

      george1421 1 Reply Last reply Reply Quote 0
      • S
        Sunks @george1421 last edited by

        @george1421 said in Database connection unavailable:

        botched uploads

        Nice thanks for the tips, worked

        1 Reply Last reply Reply Quote 0
        • george1421
          george1421 Moderator @Sunks last edited by

          @sunks Look in /images/dev for directory names that are named like mac addresses. Unless you are actively capturing an image. If those directories exist and not currently capturing an image, those are botched uploads and can be deleted to recover disk space.

          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!

          S 1 Reply Last reply Reply Quote 0
          • S
            Sunks @george1421 last edited by

            @george1421 My fogserver is a VM

            Deleting the “/var/lib/mysql/tc.log” file resolved the issue.
            My disk was probably full but the DB could not restart until i delete the tc.log file

            But my VM have 150Gb allocated. I don’t know why i have only 85Gb available. I will check that.

            Thanks !

            george1421 1 Reply Last reply Reply Quote 0
            • george1421
              george1421 Moderator @Sunks last edited by george1421

              @sunks Is your fog server running as a VM on virtual box?

              second option: https://support.cpanel.net/hc/en-us/articles/1500000853661-MySQL-MariaDB-will-not-start-Can-t-init-tc-log-

              I would have liked to see the dh command before you tried to fix it to see if it was originally out of disk space that was the root cause. But now all we can do is just work forward.

              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!

              1 Reply Last reply Reply Quote 0
              • S
                Sunks @george1421 last edited by

                @george1421

                the tail error.log :
                8efdec6a-99f9-4067-854b-dc8918c89137-image.png

                1 Reply Last reply Reply Quote 0
                • george1421
                  george1421 Moderator @Sunks last edited by

                  @sunks Ok well its not the easy fix. In /var/log/mariadb there should be log files for the mariadb. tail them to see if it gives a clue to why the db is not starting since its not the typical answer.

                  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!

                  S 2 Replies Last reply Reply Quote 0
                  • S
                    Sunks last edited by Sunks

                    The result of df -h command :
                    71820c40-0037-4e40-9748-cbe11869b78d-image.png

                    By the way, i suspected to be out of disk space too before the post and deleted 1 image from the /images folder but nothing changed. I still can’t start the database

                    george1421 2 Replies Last reply Reply Quote 0
                    • george1421
                      george1421 Moderator @Sunks last edited by

                      @sunks Lets run a df -h command to see if you are out of disk space. Having low disk space would stop the database from starting up, and the web ui to fail to load.

                      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!

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

                      177
                      Online

                      10.2k
                      Users

                      16.3k
                      Topics

                      149.9k
                      Posts

                      Copyright © 2012-2020 FOG Project