Error multiple hosts returned for list of mac addresses

[Tom Elliott]

https://forums.fogproject.org/topic/7678/active-directory-join-fails

Please read this posting.

[GFm]

@Tom-Elliott I actually did and unfortunately, it didn’t fix it. I don’t have virtualbox installed on my image and I’m not sure what else to try out… any ideas? I’m trying a different image right now to make sure the one I’m working with isn’t bad.

Thanks for the quick reply! Let me know your thoughts when you get a chance

[Tom Elliott]

@GFm if it’s not the virtual box thing then it’s possible the same Mac is associated to multiple hosts. In olden days this was possible. Can you get a pull of the database?

[GFm]

@Tom-Elliott What’s the sql command for that? Thanks!

[Tom Elliott]

Try this:

SELECT `hmHostID` FROM `hostMAC` GROUP BY `hmHostID` HAVING COUNT(`hmMAC`) > 1

[GFm]

@Tom-Elliott 0_1466703416882_output.txt Here you go.

[Tom Elliott]

ALright you mind a remote session?

[Tom Elliott]

Maybe even try this:

SELECT * FROM `hostMAC` WHERE `hmMAC` IN (SELECT `hmMAC` FROM `hostMAC` GROUP BY `hmMAC` HAVING COUNT(`hmMAC`) > 1)

[GFm]

@Tom-Elliott no luck

[GFm]

@GFm Tom fixed it for me. found the mac to be attached to another host and deleted it