FOG Registration Error. Hostname with that name already exists

[Tom Elliott]

@cojohnson are you on RC 10?

[cojohnson]

@Tom-Elliott Yes,

[Wayne Workman]

@cojohnson so just use SQL to delete that host from both the hosts table and the hostMAC table, and potentially from the groups association table as well.

[cojohnson]

@Wayne-Workman
That might help. How do i delete just this host from mysql?

Why does FOG seem to be “defaulting” to this host during the Full Host Registration Process?
I did a query on the table and FOG appears to be overwritting the host in the “hosts” table again from looking at the “hostCreateDate” field

[cojohnson]

@Wayne-Workman
I deleted that host from both the hosts table and the hostMAC table in mysql. I am still getting the same error when attempting to Register a Host

[cojohnson]

I was able to resolve this issue by deleting all (10) hosts with a hmID = 0

[cojohnson]

Now, The issue is happening again!!

[cojohnson]

@Tom-Elliott This is what i have done. I started by deleting each host individually. It looks like 4 hosts found there way into having a hmHostID of 0 between yesterday morning and now? I ended up deleting the remaining two hosts with the hmHostID of 0 to resolve the problem for now.

Any Ideas on how this is happening?

[Tom Elliott]

@cojohnson you willing to try the working RC 11 to see if it’s working better?

[cojohnson]

@Wayne-Workman

I had 3 more hosts in mysql with a hmHostID of 0 within the last 45 minutes.

I was trying to register a host and first got an "Truncated " error followed by my normal error. I immediately tried a reboot and got my hostname error. I dont know if this will assist in the troubleshooting process. I figured it was worth a mention!

[Wayne Workman]

@cojohnson and @Tom-Elliott, that hostname that was inputted is only 12 characters long, not 15.

Also, I’ve got this thing I wrote a while back that monitors hosts in FOG, we can modify it to keep an eye on the hosts with 0 as an ID and figure out exactly when it’s happening. I’d just need some time with you via Join.me. Also, do try RC-11 as Tom suggested. If you message me via the forums chat, I can give you steps on how to do that.

[Wayne Workman]

Cross-linking threads with the same problem and moved to bugs.
https://forums.fogproject.org/topic/8628/registering-clients-same-mac-shows-up

[Wayne Workman]

@cojohnson Can you run these SQL queries in MySQL please, and give us the results?

mysql -D fog
SELECT `hostID`, `hostName` FROM `hosts` WHERE `hostID` = '0';
SELECT * FROM `hostMAC` WHERE hmID = '0' OR `hmHostID` = '0';
SELECT * FROM `groupMembers` WHERE `gmID` = '0' OR `gmHostID` = '0' OR `gmGroupID` = '0';
SELECT * FROM `snapinGroupAssoc` WHERE `sgaID` = '0' OR `sgaSnapinID` = '0' OR `sgaStorageGroupID` = '0';
SELECT * from `snapinAssoc` WHERE `saID` = '0' OR `saHostID` = '0' OR `saSnapinID` = '0'; 
quit

[cojohnson]

@Wayne-Workman Thanks, I am available today whenever you get a chance to have a conversation. Here are the results of the queries you wanted me run. I deleted these entries and will update the thread if the issue arises again

[Tom Elliott]

@cojohnson can you please try working RC 11 after cleaning up the db? I’m pretty sure that it will address the random 0 entries too.

[cojohnson]

@Tom-Elliott I will do the upgrade! Thanks for all of your hard work!

[cojohnson]

@Tom-Elliott
The issue just started happening again! On RC11.

[cojohnson]

@Tom-Elliott
I deleted the Hosts from the table and delete a unused Storage Group. So i am functional right now and will update the thread if i have any more problems.

Do you have any ideas?

[Tom Elliott]

@cojohnson Nope. Working RC 12 has some improvements though. If you want to try that.

I’ve not been able to replicate the issue myself. Then again, I wasn’t able to replicate it in RC-10, though I did find what was causing it.

[Wayne Workman]

@cojohnson Can you try these commands? This is just out of pure curiosity on my part, but could potentially reveal an issue.

SELECT * FROM `hosts` WHERE `hostID` NOT IN (SELECT `hmhostID` FROM `hostMAC`);
SELECT * FROM `hostMAC` WHERE `hmhostID` NOT IN (SELECT `hostID` FROM `hosts`);
SELECT * FROM `snapinAssoc` WHERE `saHostID` NOT IN (SELECT `hostID` FROM `hosts`);
SELECT * FROM `groupMembers` WHERE `gmHostID` NOT IN (SELECT `hostID` FROM `hosts`);