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

    Host name already exists

    FOG Problems
    2
    6
    1881
    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.
    • Joseph Hales
      Joseph Hales Testers last edited by

      I am trying to register a host when it boots it says unregistered but when I attempt to register it I get a host name already exists on the boot menu and the web admin. When I search my hosts by name and by mac address I am unable to locate the record. I believe I have a corrupt record in my database but I am not comfortable with editing it directly. Anyone able to suggest some step by step commands to remove the offending record the host name should be lap7p96302 and the mac address [FONT=Tahoma][COLOR=black]D0:67:E5:2E:1E:AD.[/COLOR][/FONT]

      RTFM

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

        Can you hit me up on Google

        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
        • Joseph Hales
          Joseph Hales Testers last edited by

          2952 that you loaded its been stable for me so far.

          RTFM

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

            What revision are you running

            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
            • Joseph Hales
              Joseph Hales Testers last edited by

              When I locate that record it showed two records and wouldnt allow me to insert the mac address so I deleted both and tried to recreate it in the fog ui but when i added host it went to a blank screen and the record is still not visible in the fog ui. I went back into mysql and tried your commands again and got this result.
              mysql> select hostID from hosts WHERE hostName like ‘%lap7p96302%’ \G
              *************************** 1. row ***************************
              hostID: 6223
              1 row in set (0.01 sec)

              mysql> INSERT INTO hostMAC SET hmHostID=‘hostIDreturnedbefore’,hmMAC=‘d0:67:e5:2e:1e:ad’,hmPrimary=‘1’;
              ERROR 1062 (23000): Duplicate entry ‘d0:67:e5:2e:1e:ad’ for key ‘hmHostID’
              mysql>

              RTFM

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

                Well you could get the hostID of the host named lap7p96302 in the hosts table of the database:

                [code]select hostID from hosts WHERE hostName like ‘%lap7p96302%’ \G[/code]

                Then insert the mac address from the returned hostid into the hostMAC table:

                [code]INSERT INTO hostMAC SET hmHostID=‘hostIDreturnedbefore’,hmMAC=‘d0:67:e5:2e:1e:ad’,hmPrimary=‘1’;[/code]

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

                230
                Online

                10.4k
                Users

                16.4k
                Topics

                150.6k
                Posts

                Copyright © 2012-2023 FOG Project