Pending hosts notification

[Hanz]

I’m running svn 4972 on Fedora 22

I have the pending hosts notification permanently both, after accepting pending host, and if none are even present on “Pending hosts” page.

[Joseph Hales]

I and several others had this issue what happened is during a certain SVN version the MAC addresses were being randomly deleted but this has since been fixed what you need to do is go into MySQL and remove the orphaned records manually. See this thread https://forums.fogproject.org/topic/5811/service-settings-not-enabled-by-default/3

[Hanz]

Ran it, but even after reboot problem persists.

[Joseph Hales]

what was the response in mysql rows selected ect?

[Hanz]

0 rows affected

[Wayne Workman]

Look at this: https://forums.fogproject.org/topic/5834/host-added-but-not-visible

and this: https://forums.fogproject.org/topic/5716/some-clients-disappear-from-web-interface-but-are-still-present-in-databse

[Hanz]

Thanks Wayne, I had some 20 disassociated hosts and ID’s. The pending host issue is resolved after deleting hosts from output of
SELECT hostID from hosts WHERE hostID NOT IN (SELECT hmHostID FROM hostMAC WHERE hmPrimary=1);

by

DELETE FROM hosts WHERE hostID IN (firstID,secondID,thirdID,etc…);

[Wayne Workman]

@Hanz Glad you got it fixed.

For others future reference, This command:
SELECT hostID from hosts WHERE hostID NOT IN (SELECT hmHostID FROM hostMAC WHERE hmPrimary=1);

can be changed into a command to delete all that it returns by simply changing select to delete like this:

DELETE hostID from hosts WHERE hostID NOT IN (SELECT hmHostID FROM hostMAC WHERE hmPrimary=1);