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

    Fog 1.2 to Fog 1.58 mysql export, after fog.sql import everithing ok, but no hosts in Web Ui

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    2
    7
    551
    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
      robo
      last edited by

      Hallo. Please i need some assistence!
      After successful exporting mysql db from host running fog 1.2 and after successful import to host running fog 1.58, mysql query see my host and mac table, the count is ok but on the new fog 1.58 web ui nothing lists in hosts.
      Thanks

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

        @robo Which commands did you use to ex- and import the database? We can’t help you without knowing what exactly you did.

        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

        R 1 Reply Last reply Reply Quote 0
        • R
          robo
          last edited by

          On FOG 1.2 side, export script with $var (crontab):
          "/usr/bin/mysqldump -u $USER --password=$PASSWORD --allow-keywords -f $DATABASE > $SAVEDIR/$DATABASE-$(date ‘+%Y%m%d’).sql

          On FOG 1.5.8, import via terminal:
          “mysql -D fog -u fogmaster -p*************** < /images/dev/fog-20200402.sql”

          When you check in mysql query, everything is by number count ok, the hosts by nummbers are present also mac addresses. Web UI works, groups, images and so on are present, users, login ok, but list all host empty. Thru groups i see members and hostnames, when i cklick on choosen host i get empty “all host” page.

          Thanks, Danke Sebastian

          1 Reply Last reply Reply Quote 0
          • R
            robo @Sebastian Roth
            last edited by

            @Sebastian-Roth

            On FOG 1.2 side, export script with $var (crontab):
            "/usr/bin/mysqldump -u $USER --password=$PASSWORD --allow-keywords -f $DATABASE > $SAVEDIR/$DATABASE-$(date ‘+%Y%m%d’).sql

            On FOG 1.5.8, import via terminal:
            “mysql -D fog -u fogmaster -p*************** < /images/dev/fog-20200402.sql”

            When you check in mysql query, everything is by number count ok, the hosts by nummbers are present also mac addresses. Web UI works, groups, images and so on are present, users, login ok, but list all host empty. Thru groups i see members and hostnames, when i cklick on choosen host i get empty “all host” page.

            Thanks, Danke Sebastian

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

              @robo Could you possibly provide the SQL dump so I can test? Please upload to a file share and send me a private message with the link.

              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

              R 1 Reply Last reply Reply Quote 0
              • R
                robo @Sebastian Roth
                last edited by

                @Sebastian-Roth
                Thank you for your effort. Last night i v tested a new configuration.
                The problematic one where
                ;ubuntu 19.10 amd64 srv from scratch + git branch fog 1.5.8 + mysql import
                The configuration from last night;
                ubuntu 18.04 LTS amd64 srv, from scratch + manual install fog 1.3+ mysql import + upgrade thru git on the latest master branch fog 1.5.8.
                With the second configuration, no problems for now, i must deeply check, but it seems there is no issues.
                If there is another issue i v ask for help.
                Thank you Sebastian
                MfG Boris

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

                  @robo Good to know you have fixed this another way. Though I am still wondering if this is a reproducible issue and we might want to fix that in the code. On the other hand 1.2.0 is really old and I am not sure how many people still use it.

                  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

                  204

                  Online

                  12.1k

                  Users

                  17.3k

                  Topics

                  155.3k

                  Posts
                  Copyright © 2012-2024 FOG Project