Can't delete host with empty host name 1.5.0 RC 7
- FOG Version: 1.5.0 RC7
- OS: Ubuntu 14
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
@sebastian-roth solved, thank you.
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%';