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

Unable to rename/join - Error multiple hosts returned for list of mac addresses

Scheduled Pinned Locked Moved
FOG Problems
2
16
1.7k
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.
  • D
    darkxeno @Sebastian Roth
    last edited by Oct 14, 2020, 2:28 PM

    @Sebastian-Roth heres the log file after updating to 0.12fog.log

    1 Reply Last reply Reply Quote 0
    • S
      Sebastian Roth Moderator
      last edited by Oct 14, 2020, 8:28 PM

      @darkxeno Some of the MAC addresses we see in the logs are clearly virtual VPN adapter MACs - e.g. 00:09:0F:AA:00:01

      Please run the following SQL query to find out which hosts might be using these and post results here:

      mysql> SELECT hmHostID FROM hostMAC where hmMAC IN ('00:09:0F:AA:00:01', '4E:4D:D9:8C:1F:5B', '54:B2:03:E4:6A:D5', 'F8:AC:65:BE:26:0C', 'F8:AC:65:BE:26:0D', 'FA:AC:65:BE:26:0C', 'F8:AC:65:BE:26:10', '90:93:8B:56:52:54');

      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

      D 1 Reply Last reply Oct 14, 2020, 8:37 PM Reply Quote 0
      • D
        darkxeno @Sebastian Roth
        last edited by Sebastian Roth Oct 14, 2020, 2:44 PM Oct 14, 2020, 8:37 PM

        @Sebastian-Roth said in Unable to rename/join - Error multiple hosts returned for list of mac addresses:

        mysql> SELECT hmHostID FROM hostMAC where hmMAC IN (‘00:09:0F:AA:00:01’, ‘4E:4D:D9:8C:1F:5B’, ‘54:B2:03:E4:6A:D5’, ‘F8:AC:65:BE:26:0C’, ‘F8:AC:65:BE:26:0D’, ‘FA:AC:65:BE:26:0C’, ‘F8:AC:65:BE:26:10’, ‘90:93:8B:56:52:54’);

        MariaDB [(none)]> SELECT hmHostID FROM hostMAC where hmMAC IN ('00:09:0F:AA:00:01', '4E:4D:D9:8C:1F:5B', '54:B2:03:E4:6A:D5', 'F8:AC:65:BE:26:0C', 'F8:AC:65:BE:26:0D', 'FA:AC:65:BE:26:0C', 'F8:AC:65:BE:26:10', '90:93:8B:56:52:54');
        ERROR 1046 (3D000): No database selected
        MariaDB [(none)]>
        
        1 Reply Last reply Reply Quote 0
        • S
          Sebastian Roth Moderator
          last edited by Oct 14, 2020, 8:39 PM

          @darkxeno Always need to select the database first just as last time:

          shell> mysql -u fogmaster -p
          Password:
          ...
          mysql> use fog;
          ...
          mysql> SELECT hmHostID FROM hostMAC where hmMAC IN ('00:09:0F:AA:00:01', '4E:4D:D9:8C:1F:5B', '54:B2:03:E4:6A:D5', 'F8:AC:65:BE:26:0C', 'F8:AC:65:BE:26:0D', 'FA:AC:65:BE:26:0C', 'F8:AC:65:BE:26:10', '90:93:8B:56:52:54');
          ...
          mysql> quit
          

          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

          D 1 Reply Last reply Oct 14, 2020, 8:40 PM Reply Quote 0
          • D
            darkxeno @Sebastian Roth
            last edited by Sebastian Roth Oct 14, 2020, 2:43 PM Oct 14, 2020, 8:40 PM

            @Sebastian-Roth said in Unable to rename/join - Error multiple hosts returned for list of mac addresses:

            use fog;

            Database changed
            MariaDB [fog]>  SELECT hmHostID FROM hostMAC where hmMAC IN ('00:09:0F:AA:00:01', '4E:4D:D9:8C:1F:5B', '54:B2:03:E4:6A:D5', 'F8:AC:65:BE:26:0C', 'F8:AC:65:BE:26:0D', 'FA:AC:65:BE:26:0C', 'F8:AC:65:BE:26:10', '90:93:8B:56:52:54');
            +----------+
            | hmHostID |
            +----------+
            |      357 |
            |      419 |
            +----------+
            2 rows in set (0.00 sec)
            
            1 Reply Last reply Reply Quote 0
            • S
              Sebastian Roth Moderator
              last edited by Oct 14, 2020, 8:43 PM

              @darkxeno Now get the names of these hosts:

              ...
              mysql> SELECT hostName FROM hosts where hostID IN ( 357, 419 );
              ...
              

              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

              D 1 Reply Last reply Oct 14, 2020, 8:46 PM Reply Quote 0
              • D
                darkxeno @Sebastian Roth
                last edited by Oct 14, 2020, 8:46 PM

                @Sebastian-Roth said in Unable to rename/join - Error multiple hosts returned for list of mac addresses:

                SELECT hostName FROM hosts where hostID IN ( 357, 419 );

                Got them what do I need to do with them?

                1 Reply Last reply Reply Quote 0
                • S
                  Sebastian Roth Moderator
                  last edited by Oct 14, 2020, 8:52 PM

                  @darkxeno said in Unable to rename/join - Error multiple hosts returned for list of mac addresses:

                  Got them what do I need to do with them?

                  Well, check those in the FOG web UI. Why do they have the same MAC addresses? Remove the MAC address from one or both of the hosts and their fog-client should be working fine again.

                  Often this is caused by virtual VPN adapters. For example the 00:09:0F:AA:00:01 looks like one. You can prevent the fog-client from registering those kind of MACs using this setting: FOG Configuration -> FOG Settings -> FOG Client - Host Register -> FOG_QUICKREG_PENDING_MAC_FILTER…

                  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

                  D 1 Reply Last reply Oct 14, 2020, 8:53 PM Reply Quote 0
                  • D
                    darkxeno @Sebastian Roth
                    last edited by Oct 14, 2020, 8:53 PM

                    @Sebastian-Roth That worked thanks man I owe you a beer!!!

                    1 Reply Last reply Reply Quote 1
                    • S
                      Sebastian Roth Moderator
                      last edited by Oct 14, 2020, 8:58 PM

                      @darkxeno You are welcome. I know it’s a bit of a hack to work through this and find that duplicate. Though it would need a lot of changes on the messages we send between FOG server and fog-client if we wanted to print out the names of those machines using the same MAC right in the fog.log…

                      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

                      D 1 Reply Last reply Oct 14, 2020, 9:02 PM Reply Quote 0
                      • D
                        darkxeno @Sebastian Roth
                        last edited by Oct 14, 2020, 9:02 PM

                        @Sebastian-Roth I understand than I was racing my brain on this lol

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

                        146

                        Online

                        12.0k

                        Users

                        17.3k

                        Topics

                        155.2k

                        Posts
                        Copyright © 2012-2024 FOG Project