FOG Project

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

    Solved impossible to create a new host

    FOG Problems
    2
    4
    73
    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.
    • R
      ricounet last edited by

      Hello,
      when I create a new host
      I have the following error:
      A host already exists with this name !

      I am sure that host doesn’t exist.
      it isn’t found in the export csv file
      but, I think that name has already been used and it has been deleted.
      Maybe a problem in the database…
      how to know ?
      Thanks for your help
      Eric

      1 Reply Last reply Reply Quote 0
      • S
        Sebastian Roth Moderator last edited by

        @ricounet Ok, so you can delete that one entry from the DB:

        shell> mysql -u root -p
        Password:
        ...
        mysql> use fog;
        ...
        mysql> DELETE FROM hosts WHERE hostID = 410;
        ...
        

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

          @Sebastian-Roth said in impossible to create a new host:

          Put in the host’s name where I have used yourhostname in the obove commands.

          via the web interface, I delete or add pc5101oo but can’t do it with pc5101o.
          thank you for your help

          MariaDB [fog]> SELECT * FROM hosts WHERE hostName LIKE ‘%pc5101o%’;
          ±-------±---------±---------±-------±----------±-------------±--------------------±--------------------±-------------±----------±-------------±---------------------------------------------±-----------±--------------------------±-----------------±---------------±-----------------±---------------±-----------±-----------±---------±------------±-----------±-------------±--------------------±-------------±-------------±------------±------------+
          | hostID | hostName | hostDesc | hostIP | hostImage | hostBuilding | hostCreateDate | hostLastDeploy | hostCreateBy | hostUseAD | hostADDomain | hostADOU | hostADUser | hostADPass | hostADPassLegacy | hostProductKey | hostPrinterLevel | hostKernelArgs | hostKernel | hostDevice | hostInit | hostPending | hostPubKey | hostSecToken | hostSecTime | hostPingCode | hostExitBios | hostExitEfi | hostEnforce |
          ±-------±---------±---------±-------±----------±-------------±--------------------±--------------------±-------------±----------±-------------±---------------------------------------------±-----------±--------------------------±-----------------±---------------±-----------------±---------------±-----------±-----------±---------±------------±-----------±-------------±--------------------±-------------±-------------±------------±------------+
          | 449 | pc5101oo | | | 3 | 0 | 2019-09-02 09:22:10 | 2019-10-24 07:09:44 | labos | 1 | lan.esiee.fr | ou=isys,ou=ordinateurs,dc=lan,dc=esiee,dc=fr | fog | gn | | | | | | | | | | | 0000-00-00 00:00:00 | 6 | | | |
          | 410 | pc5101o | | | 3 | 0 | 2019-08-29 14:13:19 | 0000-00-00 00:00:00 | labos | | lan.esiee.fr | ou=isys,ou=ordinateurs,dc=lan,dc=esiee,dc=fr | fog | g
          En | | | | | | | | | | | 0000-00-00 00:00:00 | 110 | | | |
          ±-------±---------±---------±-------±----------±-------------±--------------------±--------------------±-------------±----------±-------------±---------------------------------------------±-----------±--------------------------±-----------------±---------------±-----------------±---------------±-----------±-----------±---------±------------±-----------±-------------±--------------------±-------------±-------------±------------±------------+
          2 rows in set (0.001 sec)

          1 Reply Last reply Reply Quote 0
          • S
            Sebastian Roth Moderator last edited by Sebastian Roth

            @ricounet Try conecting to the database on the command line and find the host entry there:

            shell> mysql -u root -p
            Password:
            ...
            mysql> use fog;
            ...
            mysql> SELECT * FROM hosts WHERE hostName LIKE '%yourhostname%';
            ...
            

            Put in the host’s name where I have used yourhostname in the obove commands. Be aware that this query is case sensitive. Post the output here.

            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

            231
            Online

            10.2k
            Users

            16.3k
            Topics

            149.9k
            Posts

            Copyright © 2012-2020 FOG Project