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

    Missing Data After Fog 1.5.7 Upgrade

    Scheduled Pinned Locked Moved Solved
    Linux Problems
    3
    6
    511
    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.
    • Ray ZuchowskiR
      Ray Zuchowski
      last edited by

      Was running fog 1.5.6 and i was unable to access the gui, kept getting an error the database couldn’t connect. If i had to guess Ubuntu did an update and broke the connection. I downloaded latest version of fog and ran the installer , however it kept failing on installing the mariadb server and client. So i installed Mariadb 10.3 manually, re ran the setup of maria db server and setup a password. Re ran the fog 1.5.7 installer and still getting the error the db is not accessible. I then went into var/www/fog /lib/configclass.php and entered the new password. Now the issue is fixed on seeing the gui, however now all my data is missing , users, hosts, images. What do i do to fix this ? Thanks for the help.

      Ray

      RZ

      1 Reply Last reply Reply Quote 0
      • Q
        Quazz Moderator
        last edited by Quazz

        This is a known problem on Ubuntu (the database moving when changing to mariadb)

        You will likely find your fog database in /var/lib/mysql-5.7

        Currently, FOG does not try to move to mariadb on Ubuntu for this reason.

        If possible, going back to mysql would be the best option I reckon.

        Ray ZuchowskiR 1 Reply Last reply Reply Quote 1
        • Ray ZuchowskiR
          Ray Zuchowski @Quazz
          last edited by

          @Quazz How do i do this ?

          RZ

          Q 1 Reply Last reply Reply Quote 0
          • Q
            Quazz Moderator @Ray Zuchowski
            last edited by

            @Ray-Zuchowski I think uninstall mariadb and install mysql should work fine, I’m not 100% sure, but that’s where I’d start.

            But check the mentioned folder and see if you can find the fog database first.

            1 Reply Last reply Reply Quote 0
            • Ray ZuchowskiR
              Ray Zuchowski
              last edited by

              The folder is there.

              RZ

              1 Reply Last reply Reply Quote 0
              • S
                Sebastian Roth Moderator
                last edited by

                @Ray-Zuchowski Give this a try:

                sudo -i
                mv /var/lib/mysql /var/lib/mysql-mariadb
                apt-get remove mariadb-client mariadb-server
                cp -a /var/lib/mysql-5.7 /var/lib/mysql
                apt-get install mysql-client mysql-server
                systemctl start mysql
                

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

                189

                Online

                12.0k

                Users

                17.3k

                Topics

                155.2k

                Posts
                Copyright © 2012-2024 FOG Project