• 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 cojohnson

      @Wayne-Workman I am running Ubuntu 14.04. Sorry for the extreme delay. We have just made it past the first week of school. I am able to sign in to the MySQL Server. I am unsure how to run the ALTER USER statement. Any tips? This is my first time interacting with MySQL.

      Since I was able to log in to MySQL, is there a need to execute ALTER USER?

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

        @cojohnson
        Don’t log in with the fogstorage user, use the root user.
        mysql -u root -p then press enter, and supply the correct root password. You should be able to find the root password inside of /opt/fog/.fogsettings it is labeled as snmysqlpass=

        The alter user stuff is only necessary if you want to change your root pass for MySQL (or freshly installing on Ubuntu 16). Once in MySQL, It would be like this:
        ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourPasswordGoesHere';

        If you don’t want a password set, just remove the pass, leave it as just a set of empty quotes like ''
        If you change the password, you must correct this inside /opt/fog/.fogsettings as well. the setting is labeled as snmysqlpass= and then re-run the installer. Again, only if changing the password.

        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 Reply Quote 0
        • C
          cojohnson @Wayne Workman
          last edited by cojohnson

          @Wayne-Workman
          I have decided not to change my “root” password for “mysql” since i am able to log in.
          Could there be a misconfigured setting in MYSQL? Or maybe something to do with PXE?

          I am able to add host via FOG’s Apache interface, but am still unable to add host via PXE boot.

          Any Ideas?

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

            @cojohnson I think it’s a bug in the version you’re on. This bug report sounds similar: https://forums.fogproject.org/topic/8524/host-registration-broken
            It’s possible that rc-8 was also affected. As soon as rc-10 is out, update to it and try.

            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 1
            • Tom ElliottT
              Tom Elliott
              last edited by

              Issue is now fixed in 10. It wasn’t registering any new hosts with the name expected from your typing.

              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 2 Replies Last reply Reply Quote 0
              • C
                cojohnson @Tom Elliott
                last edited by cojohnson

                @Tom-Elliott
                I just upgraded all of the nodes and the server to 10. The issue persists.

                I did a search on the server for the hostname and MAC. No results were found.

                0_1473429208377_Registration.png

                1 Reply Last reply Reply Quote 0
                • C
                  cojohnson @Tom Elliott
                  last edited by cojohnson

                  @Tom-Elliott

                  This is what it looks like on
                  Image 1) PXE Boot
                  Image 2) FOG Registration
                  Image 3) CMD MAC
                  Image 4) Server host search for duplicate clients MAC
                  Image 5) Server host search for duplicate name???
                  Image 6) Pending hosts on server

                  Image 1 PXE Boot
                  0_1473431408478_IMG_1206[1].JPG

                  Image 2 FOG Registration
                  0_1473431434905_IMG_1208[1].JPG

                  Image 3 CMD MAC
                  0_1473431495250_IMG_1212[1].JPG

                  Image 4 Search host search for duplicate clients MAC
                  0_1473431612998_IMG_1210[1].JPG

                  Image 5 Server host search for duplicate name???
                  0_1473431727190_IMG_1209[1].JPG

                  Image 6 Pending hosts on server
                  0_1473431752022_IMG_1211[1].JPG

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

                    @cojohnson the issue is the name is in use by another system from the messages I’m seeing. RC 10 fixes the issue that was causing this, but it will not fix the database for you. I am limited to cell phone so I can’t provide decent help maybe one of our other moderators or devs can be more forthcoming?

                    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 @cojohnson
                      last edited by

                      @cojohnson This command will select the host ID, hostname, and MAC from the db where the mac is that one I typed.

                      sudo -i
                      mysql -D fog
                      select hostMAC.hmHostID,hostMAC.hmMAC,hosts.hostName from hostMAC INNER JOIN hosts ON hosts.hostID = hostMAC.hmHostID where hmMAC='18:5e:0f:f0:a9:55';
                      quit
                      

                      You can then either do some searching on the returned information, or delete it via MySQL.

                      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 Reply Quote 0
                      • C
                        cojohnson @Wayne Workman
                        last edited by

                        @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

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

                          @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 Reply Quote 0
                          • C
                            cojohnson @Tom Elliott
                            last edited by

                            @Tom-Elliott Yes,

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

                              @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 Reply Quote 0
                              • C
                                cojohnson @Wayne Workman
                                last edited by

                                @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

                                  @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 Reply Quote 0
                                  • C
                                    cojohnson @cojohnson
                                    last edited by

                                    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

                                      Now, The issue is happening again!!

                                      1 Reply Last reply Reply Quote 0
                                      • C
                                        cojohnson @Tom Elliott
                                        last edited by

                                        @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

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

                                          @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

                                            @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

                                            Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 3
                                            • 4
                                            • 2 / 4
                                            • First post
                                              Last post

                                            165

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project