FOG Registration Error. Hostname with that name already exists

[cojohnson]

@Tom-Elliott

This is what it looks like on
Image 1) PXE Boot
Image 2) FOG Registration
Image 3) CMD MAC
Image 4) Server host search for duplicate clients MAC
Image 5) Server host search for duplicate name???
Image 6) Pending hosts on server

Image 1 PXE Boot

Image 2 FOG Registration

Image 3 CMD MAC

Image 4 Search host search for duplicate clients MAC

Image 5 Server host search for duplicate name???

Image 6 Pending hosts on server

[Tom Elliott]

@cojohnson the issue is the name is in use by another system from the messages I’m seeing. RC 10 fixes the issue that was causing this, but it will not fix the database for you. I am limited to cell phone so I can’t provide decent help maybe one of our other moderators or devs can be more forthcoming?

[Wayne Workman]

@cojohnson This command will select the host ID, hostname, and MAC from the db where the mac is that one I typed.

sudo -i
mysql -D fog
select hostMAC.hmHostID,hostMAC.hmMAC,hosts.hostName from hostMAC INNER JOIN hosts ON hosts.hostID = hostMAC.hmHostID where hmMAC='18:5e:0f:f0:a9:55';
quit

You can then either do some searching on the returned information, or delete it via MySQL.

[cojohnson]

@Wayne-Workman
I dont think my issue is caused by that hostname being used by another system. I am trying to perform a Full Host Registration and Inventory on a Dell Laptop. The Dell’s MAC Address is 64:31:50:12:d2:5d. I searched the database for that MAC and got no results.

However, during the registration process, I get an error saying
A hostname with that name already exists.
The MAC Address associated with this is: 18:5e:0f:9c:11:24

When i searched for that MAC, the query returns that the "hmHostID"s Value is 0.
This happens when trying to register any device.

[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!