• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • 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
515
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.
  • R
    Ray Zuchowski
    last edited by Sep 4, 2019, 3:00 PM

    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 Sep 4, 2019, 9:24 AM Sep 4, 2019, 3:23 PM

      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.

      R 1 Reply Last reply Sep 4, 2019, 3:51 PM Reply Quote 1
      • R
        Ray Zuchowski @Quazz
        last edited by Sep 4, 2019, 3:51 PM

        @Quazz How do i do this ?

        RZ

        Q 1 Reply Last reply Sep 4, 2019, 3:59 PM Reply Quote 0
        • Q
          Quazz Moderator @Ray Zuchowski
          last edited by Sep 4, 2019, 3:59 PM

          @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
          • R
            Ray Zuchowski
            last edited by Sep 4, 2019, 4:13 PM

            The folder is there.

            RZ

            1 Reply Last reply Reply Quote 0
            • S
              Sebastian Roth Moderator
              last edited by Sep 5, 2019, 5:48 AM

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

              253

              Online

              12.0k

              Users

              17.3k

              Topics

              155.2k

              Posts
              Copyright © 2012-2024 FOG Project