Phantom host

[IIIPgCIII]

I have a host that does not show up, but when I try to make a host with the same name, or same mac address, it says it exists. it does not. Could it have somehow not deleted all the way? how do i delete it?

[Joseph Hales]

I had the same issue and Tom helped me manualy remove it from the sql database.

[Tom Elliott]

[code]delete from hosts where hostname=‘WHATEVERTHEPHANTOMHOSTNAMEIS’;
delete FROM hostMAC where hmID=‘0’ OR hmHostID=‘0’;
delete FROM hosts where hostID=‘0’;[/code]

[Joseph Hales]

I think this and the truncate tasks script should both make it to the wiki.

[IIIPgCIII]

Thanks! that worked. But our hosts keep disapearing from the GUI. I see them, when I browse through the SQL database. It is really strange.

[Joseph Hales]

I’ve only seen this behavior when upgrading and i forget to kill outstanding tasks or the server reboots during a host edit/add.