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

      I recently upgraded to the newest version of fog 1.3.0 RC-8. When I go to register ANY Computer, i receive an error saying “hostname with that name already exists.” Also when i try to view the Apache Error log via FOG’s Web GUI I recieve an error regarding permissions.

      Is there a way to reset the “hostname / registration” database and reimport my hosts?
      And reset the permissions to the Apache Log?

      0_1471348128387_Registration.png

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

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

          Just going to guess, these hosts had the FOG Client installed?

          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 1 Reply Last reply Reply Quote 0
          • Tom ElliottT
            Tom Elliott
            last edited by

            For the log issue, it’s the log rotate. You can temporarily clear up the issue by re-running the installer as it reset’s the permissions so the GUI can see 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

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

              @Tom-Elliott said in FOG Registration Error. Hostname with that name already exists:

              For the log issue, it’s the log rotate.

              To clarify what that means, linux automatically rotates logs out when they get to a certain size. And the new log doesn’t have the permissions for the web UI to read 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!
              Daily Clean Installation Results:
              https://fogtesting.fogproject.us/
              FOG Reporting:
              https://fog-external-reporting-results.fogproject.us/

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

                @Tom-Elliott OK. I will rerun the installer to fix the permissions to the log.
                The hostname issue happens regardless of the FOG Client being installed.

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

                  @cojohnson Have you tried querying mysql for the hostname in question?

                  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 No. I have very little experience with mysql. How do I do that?

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

                      @cojohnson Something like this for MAC searching:

                      mysql
                      use fog;
                      select * from hostMAC where hmMAC = '68:1c:a2:06:38:b9';
                      

                      Example:
                      0_1471367608669_upload-709e0755-75af-410b-8ba7-ba03b8d25480

                      Something like this for hostname searching:

                      mysql
                      use fog;
                      select hostName,hostID from hosts where hostName = 'r0219510530wdmb';
                      

                      0_1471367793544_upload-ed3e9cfa-dbf1-4c64-8599-3472624c50d7

                      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 Sorry for the delay. It is crunch time for us here at school getting all the 1 - 1 devices ready and staff stopping by.

                        I am having troubles connecting to MySQL to perform a query.

                        Below is a screenshot of my error.

                        0_1471622284751_MySQL fail.png

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

                          @cojohnson Looks like you have a password set for the MySQL root user. Connect to MySQL using this line:
                          mysql -u root -p

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

                            @Wayne-Workman I suspect Ubuntu 16.04, so possibly needs to run with:

                            sudo mysql -u root

                            Then run the ALTER USER statement.

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

                                              220

                                              Online

                                              12.0k

                                              Users

                                              17.3k

                                              Topics

                                              155.2k

                                              Posts
                                              Copyright © 2012-2024 FOG Project