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

FOG Registration Error. Hostname with that name already exists

Scheduled Pinned Locked Moved Solved
Bug Reports
3
61
23.4k
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.
  • C
    cojohnson @Wayne Workman
    last edited by Sep 16, 2016, 12:07 PM

    @Wayne-Workman
    I dont think my issue is caused by that hostname being used by another system. I am trying to perform a Full Host Registration and Inventory on a Dell Laptop. The Dell’s MAC Address is 64:31:50:12:d2:5d. I searched the database for that MAC and got no results.

    However, during the registration process, I get an error saying
    A hostname with that name already exists.
    The MAC Address associated with this is: 18:5e:0f:9c:11:24

    When i searched for that MAC, the query returns that the "hmHostID"s Value is 0.
    This happens when trying to register any device.

    0_1474025890085_upload-4bb30bb1-7c84-4c52-948d-84701bd3adc8

    T 1 Reply Last reply Sep 16, 2016, 12:08 PM Reply Quote 0
    • T
      Tom Elliott @cojohnson
      last edited by Sep 16, 2016, 12:08 PM

      @cojohnson are you on RC 10?

      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

      C 3 Replies Last reply Sep 16, 2016, 12:16 PM Reply Quote 0
      • C
        cojohnson @Tom Elliott
        last edited by Sep 16, 2016, 12:16 PM

        @Tom-Elliott Yes,

        W 1 Reply Last reply Sep 16, 2016, 1:52 PM Reply Quote 0
        • W
          Wayne Workman @cojohnson
          last edited by Sep 16, 2016, 1:52 PM

          @cojohnson so just use SQL to delete that host from both the hosts table and the hostMAC table, and potentially from the groups association table as well.

          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/

          C 3 Replies Last reply Sep 16, 2016, 3:17 PM Reply Quote 0
          • C
            cojohnson @Wayne Workman
            last edited by Sep 16, 2016, 3:17 PM

            @Wayne-Workman
            That might help. How do i delete just this host from mysql?

            Why does FOG seem to be “defaulting” to this host during the Full Host Registration Process?
            I did a query on the table and FOG appears to be overwritting the host in the “hosts” table again from looking at the “hostCreateDate” field

            0_1474038992543_upload-0d45c9cd-8536-4773-aa6a-ea9638f2f314

            1 Reply Last reply Reply Quote 0
            • C
              cojohnson @Wayne Workman
              last edited by Sep 16, 2016, 5:10 PM

              @Wayne-Workman
              I deleted that host from both the hosts table and the hostMAC table in mysql. I am still getting the same error when attempting to Register a Host

              C 1 Reply Last reply Sep 19, 2016, 4:10 PM Reply Quote 0
              • C
                cojohnson @cojohnson
                last edited by Sep 19, 2016, 4:10 PM

                I was able to resolve this issue by deleting all (10) hosts with a hmID = 0

                1 Reply Last reply Reply Quote 1
                • C
                  cojohnson @Tom Elliott
                  last edited by Sep 21, 2016, 11:36 AM

                  Now, The issue is happening again!!

                  1 Reply Last reply Reply Quote 0
                  • C
                    cojohnson @Tom Elliott
                    last edited by Sep 21, 2016, 11:56 AM

                    @Tom-Elliott This is what i have done. I started by deleting each host individually. It looks like 4 hosts found there way into having a hmHostID of 0 between yesterday morning and now? I ended up deleting the remaining two hosts with the hmHostID of 0 to resolve the problem for now.

                    Any Ideas on how this is happening?

                    0_1474458930629_IMG_1235[1].JPG
                    0_1474458947338_IMG_1234[1].JPG

                    T 1 Reply Last reply Sep 21, 2016, 12:03 PM Reply Quote 0
                    • T
                      Tom Elliott @cojohnson
                      last edited by Sep 21, 2016, 12:03 PM

                      @cojohnson you willing to try the working RC 11 to see if it’s working better?

                      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
                      • C
                        cojohnson @Wayne Workman
                        last edited by cojohnson Sep 21, 2016, 6:38 AM Sep 21, 2016, 12:34 PM

                        @Wayne-Workman

                        I had 3 more hosts in mysql with a hmHostID of 0 within the last 45 minutes.

                        I was trying to register a host and first got an "Truncated " error followed by my normal error. I immediately tried a reboot and got my hostname error. I dont know if this will assist in the troubleshooting process. I figured it was worth a mention!

                        0_1474461247647_IMG_1236[2].JPG

                        0_1474461261412_IMG_1237[1].JPG

                        W 1 Reply Last reply Sep 21, 2016, 10:27 PM Reply Quote 0
                        • W
                          Wayne Workman @cojohnson
                          last edited by Sep 21, 2016, 10:27 PM

                          @cojohnson and @Tom-Elliott, that hostname that was inputted is only 12 characters long, not 15.

                          Also, I’ve got this thing I wrote a while back that monitors hosts in FOG, we can modify it to keep an eye on the hosts with 0 as an ID and figure out exactly when it’s happening. I’d just need some time with you via Join.me. Also, do try RC-11 as Tom suggested. If you message me via the forums chat, I can give you steps on how to do 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
                          • W
                            Wayne Workman
                            last edited by Wayne Workman Sep 22, 2016, 11:44 AM Sep 22, 2016, 5:41 PM

                            Cross-linking threads with the same problem and moved to bugs.
                            https://forums.fogproject.org/topic/8628/registering-clients-same-mac-shows-up

                            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
                            • W
                              Wayne Workman
                              last edited by Wayne Workman Sep 22, 2016, 12:02 PM Sep 22, 2016, 6:02 PM

                              @cojohnson Can you run these SQL queries in MySQL please, and give us the results?

                              mysql -D fog
                              SELECT `hostID`, `hostName` FROM `hosts` WHERE `hostID` = '0';
                              SELECT * FROM `hostMAC` WHERE hmID = '0' OR `hmHostID` = '0';
                              SELECT * FROM `groupMembers` WHERE `gmID` = '0' OR `gmHostID` = '0' OR `gmGroupID` = '0';
                              SELECT * FROM `snapinGroupAssoc` WHERE `sgaID` = '0' OR `sgaSnapinID` = '0' OR `sgaStorageGroupID` = '0';
                              SELECT * from `snapinAssoc` WHERE `saID` = '0' OR `saHostID` = '0' OR `saSnapinID` = '0'; 
                              quit
                              

                              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/

                              C 1 Reply Last reply Sep 23, 2016, 12:14 PM Reply Quote 0
                              • C
                                cojohnson @Wayne Workman
                                last edited by cojohnson Sep 23, 2016, 6:45 AM Sep 23, 2016, 12:14 PM

                                @Wayne-Workman Thanks, I am available today whenever you get a chance to have a conversation. Here are the results of the queries you wanted me run. I deleted these entries and will update the thread if the issue arises again

                                0_1474632538378_Results_Wayne.png

                                0_1474634721723_upload-c49d878f-d7aa-4e64-b298-fa0c18c4c9c3

                                T 1 Reply Last reply Sep 23, 2016, 12:18 PM Reply Quote 0
                                • T
                                  Tom Elliott @cojohnson
                                  last edited by Sep 23, 2016, 12:18 PM

                                  @cojohnson can you please try working RC 11 after cleaning up the db? I’m pretty sure that it will address the random 0 entries too.

                                  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

                                  C 3 Replies Last reply Sep 23, 2016, 12:50 PM Reply Quote 0
                                  • C
                                    cojohnson @Tom Elliott
                                    last edited by Sep 23, 2016, 12:50 PM

                                    @Tom-Elliott I will do the upgrade! Thanks for all of your hard work!

                                    1 Reply Last reply Reply Quote 0
                                    • C
                                      cojohnson @Tom Elliott
                                      last edited by Oct 7, 2016, 2:12 PM

                                      @Tom-Elliott
                                      The issue just started happening again! On RC11.
                                      0_1475849472256_upload-4ab700e0-28dd-47ac-a57f-e68f4d6b53b4

                                      1 Reply Last reply Reply Quote 0
                                      • C
                                        cojohnson @Tom Elliott
                                        last edited by Oct 7, 2016, 3:56 PM

                                        @Tom-Elliott
                                        I deleted the Hosts from the table and delete a unused Storage Group. So i am functional right now and will update the thread if i have any more problems.

                                        Do you have any ideas?

                                        T W 2 Replies Last reply Oct 7, 2016, 3:57 PM Reply Quote 0
                                        • T
                                          Tom Elliott @cojohnson
                                          last edited by Oct 7, 2016, 3:57 PM

                                          @cojohnson Nope. Working RC 12 has some improvements though. If you want to try that.

                                          I’ve not been able to replicate the issue myself. Then again, I wasn’t able to replicate it in RC-10, though I did find what was causing it.

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

                                          148

                                          Online

                                          12.0k

                                          Users

                                          17.3k

                                          Topics

                                          155.2k

                                          Posts
                                          Copyright © 2012-2024 FOG Project