@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 | gEn | | | | | | | | | | | 0000-00-00 00:00:00 | 110 | | | |
±-------±---------±---------±-------±----------±-------------±--------------------±--------------------±-------------±----------±-------------±---------------------------------------------±-----------±--------------------------±-----------------±---------------±-----------------±---------------±-----------±-----------±---------±------------±-----------±-------------±--------------------±-------------±-------------±------------±------------+
2 rows in set (0.001 sec)

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