Can't delete host with empty host name 1.5.0 RC 7

[x23piracy]

Server

• FOG Version: 1.5.0 RC7
• OS: Ubuntu 14

Hi,

for some kind of reason i have one host (don’t know since when) that does not have a host name (it’s empty) therefore no link to enter the host details even when i catch the id from deploy link and manually try to enter (http://fog/fog/management/index.php?node=host&sub=edit&id=xxxxx) it doesn’t work.

When i mark that host and try to delete it the delete overview do not present anything and i think therefore pressing the delete button will do nothing.

Howto remove that biatch host or give it a hostname to try if it can be entered by link then (SQL)?
Host ID is 31418

Regards X23

[Sebastian Roth]

@x23piracy try:

mysql -u root -p
...
mysql> use fog;
mysql> SELECT * FROM hostMAC WHERE hmMAC LIKE '%4e:a7:a0:14:00:98%';

This should show the MAC address which is still in the DB but not referenced by a host object. To delete it run:

mysql> DELETE FROM hostMAC WHERE hmMAC LIKE '%4e:a7:a0:14:00:98%';

[x23piracy]

@sebastian-roth solved, thank you.

Regards X23