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

    Relationship between DB and GUI for hosts

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    3
    12
    2.8k
    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.
    • Wayne WorkmanW
      Wayne Workman
      last edited by

      We can get you straightened out, but we need to start off with just gathering some info.

      What OS are you running FOG on? Version?

      What version of FOG did you upgrade from?

      Why did you upgrade? Was there some sort of problem with the latest stable?

      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!
      Daily Clean Installation Results:
      https://fogtesting.fogproject.us/
      FOG Reporting:
      https://fog-external-reporting-results.fogproject.us/

      1 Reply Last reply Reply Quote 0
      • V
        Viper79
        last edited by Viper79

        Wayne,
        Thanks for the reply - Sorry I should have added all the info you requested in my first post:
        Ubuntu 14.04 LTS
        Upgraded from 1.2.0
        Reason for upgrade was simply browsing this forum and noticing a few other issues that I was encountering was fixed fixed in other trunks…so I just figuring updating to the latest trunk would be the best idea. I have searched through the forums in regards to possible host issues and I could see this query being referenced :

        SELECT * FROM hosts WHERE hostID NOT IN (SELECT hmhostID FROM hostMAC);

        this only brings back 1 host…so it seems that the hostsID and hostMAC’s match bar 1…

        Thanks again

        Tom ElliottT Wayne WorkmanW 2 Replies Last reply Reply Quote 1
        • Tom ElliottT
          Tom Elliott @Viper79
          last edited by

          @Viper79 From the sounds of it, for what ever reason, it created the MAC Addresses, but didn’t transfer them properly over to the table association.

          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
          • Wayne WorkmanW
            Wayne Workman @Viper79
            last edited by

            @Viper79 do you have a DB backup?

            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!
            Daily Clean Installation Results:
            https://fogtesting.fogproject.us/
            FOG Reporting:
            https://fog-external-reporting-results.fogproject.us/

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

              @Wayne-Workman I hope so, if he went from one to latest trunk, it should automatically create a backup.

              Of course confirmation would be great.

              Folder of db backups (default) is /home/fogDBbackups.

              Please check and let us know!

              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

              Wayne WorkmanW V 2 Replies Last reply Reply Quote 1
              • Wayne WorkmanW
                Wayne Workman @Tom Elliott
                last edited by

                @Tom-Elliott I keep forgetting about that.

                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!
                Daily Clean Installation Results:
                https://fogtesting.fogproject.us/
                FOG Reporting:
                https://fog-external-reporting-results.fogproject.us/

                1 Reply Last reply Reply Quote 0
                • V
                  Viper79 @Tom Elliott
                  last edited by Viper79

                  @Tom-Elliott I managed to fix this…I noticed the only difference between the 1 host working from the old config was no spaces in the name! after updating the db name from test 1 to test_1 it now appears in the gui!! So spaces make a difference in the name!

                  Thanks again for rapid help and expect more from me to help this project in any way.
                  Regards

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

                    @Viper79 didn’t know your hostnames had spaces and yes this, too, would cause a problem. Fog know tries to ensure hostnames are appropriate to what Windows requires. This means 15 characters and alpha-numeric characters (A-Za-z0-9 - and _)

                    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

                    V 1 Reply Last reply Reply Quote 0
                    • V
                      Viper79 @Tom Elliott
                      last edited by

                      @Tom-Elliott Yeah sorry I didn’t provide enough information - being a software engineer myself I know that the key is in the detail! Still this will be a nice quick fix if anyone else see this or if its added to any FAQ.

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

                        @Viper79 It’s no problem. We often miss the most pertinent of details (when considering that detail is usually not indicative to most as the problem.)

                        Glad you found the issue and reported what the problem was for your scenario.

                        I am fairly sure FOG no longer allows you to even create a host with a space in the name, though I’m not sure if the script from the init’s makes these same checks.

                        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

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

                          @Tom-Elliott The upgrading process should replace spaces in computer names with hyphens.

                          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!
                          Daily Clean Installation Results:
                          https://fogtesting.fogproject.us/
                          FOG Reporting:
                          https://fog-external-reporting-results.fogproject.us/

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

                          132

                          Online

                          12.1k

                          Users

                          17.3k

                          Topics

                          155.3k

                          Posts
                          Copyright © 2012-2024 FOG Project