FOG Registration Error. Hostname with that name already exists
-
@Tom-Elliott Yes,
-
@cojohnson so just use SQL to delete that host from both the
hoststable and thehostMACtable, and potentially from the groups association table as well. -
@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
-
@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 -
I was able to resolve this issue by deleting all (10) hosts with a hmID = 0
-
Now, The issue is happening again!!
-
@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?
![0_1474458930629_IMG_1235[1].JPG](/uploads/files/1474458932196-img_1235-1-resized.jpg)
![0_1474458947338_IMG_1234[1].JPG](/uploads/files/1474458948450-img_1234-1-resized.jpg)
-
@cojohnson you willing to try the working RC 11 to see if it’s working better?
-
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!
![0_1474461247647_IMG_1236[2].JPG](/uploads/files/1474461248736-img_1236-2.jpg)
![0_1474461261412_IMG_1237[1].JPG](/uploads/files/1474461262169-img_1237-1.jpg)
-
@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.
-
Cross-linking threads with the same problem and moved to bugs.
https://forums.fogproject.org/topic/8628/registering-clients-same-mac-shows-up -
@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 -
@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
-
@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.
-
@Tom-Elliott I will do the upgrade! Thanks for all of your hard work!
-
@Tom-Elliott
The issue just started happening again! On RC11.
-
@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?
-
@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.
-
@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`); -
mysql> SELECT * FROM `hosts` WHERE `hostID` NOT IN (SELECT `hmhostID` FROM `hostMAC`); +--------+-----------------+---------------------------------------------+--------+-----------+--------------+---------------------+---------------------+--------------+-----------+---------------------+----------------------------------------------------------------+-------------------+------------+----------------------------------+----------------+------------------+----------------+------------+------------+----------+-------------+------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------+---------------------+--------------+--------------+-------------+-------------+ | hostID | hostName | hostDesc | hostIP | hostImage | hostBuilding | hostCreateDate | hostLastDeploy | hostCreateBy | hostUseAD | hostADDomain | hostADOU | hostADUser | hostADPass | hostADPassLegacy | hostProductKey | hostPrinterLevel | hostKernelArgs | hostKernel | hostDevice | hostInit | hostPending | hostPubKey | hostSecToken | hostSecTime | hostPingCode | hostExitBios | hostExitEfi | hostEnforce | +--------+-----------------+---------------------------------------------+--------+-----------+--------------+---------------------+---------------------+--------------+-----------+---------------------+----------------------------------------------------------------+-------------------+------------+----------------------------------+----------------+------------------+----------------+------------+------------+----------+-------------+------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------+---------------------+--------------+--------------+-------------+-------------+ | 10 | TRC-011 | Created by FOG Reg on May 6, 2016, 5:56 pm | | 10 | 0 | 2016-05-06 17:56:09 | 2016-06-06 15:33:24 | fog | | | | | | | | | | | | NULL | | 1c92669f6ee5518342c2c99ae17ffd71387bef6520fd68f87441bdce73be4f21 | 66636139626233313635306138343462323233366635613330636463633163313565656465303036643537643731323438316231656636386335363565343835 | 2016-06-06 16:05:13 | 6 | | | 0 | | 11 | TRC-010 | Created by FOG Reg on May 9, 2016, 12:01 pm | | 10 | 0 | 2016-05-09 12:01:11 | 2016-06-06 15:33:38 | fog | 1 | wayne-jvs.k12.oh.us | OU=Fogadd,OU=Computers,OU=user,DC=wayne-jvs,DC=k12,DC=oh,DC=us | WCSCC1\\\\xpsetup | | 4a7f1e682d32441e2745bf19541efa66 | | | | | | NULL | | 5c4bb0de933a85e8706cdc79d7276ed89b784469b2f70c60fac1097043c6a256 | 61376537316633306532303161333466346466643837326630636263626534333038613261366664663032623664303061323264616164373834306431376361 | 2016-06-06 16:05:32 | 6 | | | 1 | | 8 | SEASHELL-3225 | Created by FOG Reg on May 5, 2016, 4:10 pm | | 9 | 0 | 2016-05-05 16:10:01 | 2016-05-05 16:15:01 | fog | | | | | | | | | | | | NULL | | | | 0000-00-00 00:00:00 | 6 | | | | | 9 | SEASHELL-PC3202 | Created by FOG Reg on May 6, 2016, 11:25 am | | 9 | 0 | 2016-05-06 11:25:24 | 2016-05-06 12:00:59 | fog | | | | | | | | | | | | NULL | | | | 0000-00-00 00:00:00 | 6 | | | | | 27 | HP4530S-6916 | Created by FOG Reg on May 31, 2016, 4:13 pm | | 6 | 0 | 2016-05-31 16:13:30 | 2016-05-31 16:20:59 | fog | | | | | | | | | | | | NULL | | | | 0000-00-00 00:00:00 | 6 | | | 0 | | 28 | HP4530S-6915 | Created by FOG Reg on May 31, 2016, 5:42 pm | | 6 | 0 | 2016-05-31 17:42:15 | 2016-05-31 17:51:42 | fog | | | | | | | | | | | | NULL | | | | 0000-00-00 00:00:00 | 6 | | | 0 | | 36 | TRCA-028 | Created by FOG Reg on June 6, 2016, 3:11 pm | | 10 | 0 | 2016-06-06 15:11:32 | 2016-06-06 15:15:20 | fog | 1 | wayne-jvs.k12.oh.us | OU=Fogadd,OU=Computers,OU=user,DC=wayne-jvs,DC=k12,DC=oh,DC=us | WCSCC1\\xpsetup | | 4a7f1e682d32441e2745bf19541efa66 | | | | | | NULL | | | 31613533643338353865623230346565376334363734353962326462333830313863383335323061323861363933393139623862613935323034306432323832 | 2016-06-06 15:47:18 | 6 | | | 1 | | 57 | DESKTOP-66NAPUK | Pending Registration created by FOG_CLIENT | | 0 | 0 | 2016-06-08 14:02:50 | 0000-00-00 00:00:00 | fog | | | | | | | | | | | | NULL | 1 | | | 0000-00-00 00:00:00 | 6 | | | 1 | | 0 | | | | 0 | 0 | 2016-10-07 17:00:55 | 0000-00-00 00:00:00 | fog | | | | | | | | | | | | | | f73a03be725c1f08c98edd0eeeca43a625e4e4502bceb4f52b3186383333620c | 34626166356238383862613364316664623333343365616231316638643863376430623431346266346137383533663638303137383030303164393937623337 | 2016-10-07 17:30:55 | | | | | +--------+-----------------+---------------------------------------------+--------+-----------+--------------+---------------------+---------------------+--------------+-----------+---------------------+----------------------------------------------------------------+-------------------+------------+----------------------------------+----------------+------------------+----------------+------------+------------+----------+-------------+------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------+---------------------+--------------+--------------+-------------+-------------+ 9 rows in set (0.00 sec) mysql> SELECT * FROM `hostMAC` WHERE `hmhostID` NOT IN (SELECT `hostID` FROM `hosts`); +------+----------+-------------------+--------+-----------+-----------+----------------+-----------------+ | hmID | hmHostID | hmMAC | hmDesc | hmPrimary | hmPending | hmIgnoreClient | hmIgnoreImaging | +------+----------+-------------------+--------+-----------+-----------+----------------+-----------------+ | 4 | 3 | a4:17:31:a5:05:23 | | 0 | 0 | 0 | 0 | | 7 | 5 | a4:17:31:a5:05:7d | | 0 | 0 | 0 | 0 | | 23 | 18 | a4:17:31:82:b6:5d | | 0 | 0 | 0 | 0 | | 26 | 21 | a4:17:31:5c:71:0f | | 0 | 0 | 0 | 0 | | 27 | 22 | a4:17:31:a5:14:ed | | 0 | 0 | 0 | 0 | | 184 | 59 | e8:9a:8f:60:7a:37 | | 0 | 0 | 0 | 0 | | 928 | 648 | 18:5e:0f:f0:3a:f6 | | 0 | 0 | 0 | 0 | | 144 | 128 | 76:df:bf:f3:76:68 | | 0 | 0 | 0 | 0 | | 178 | 59 | | | 0 | 1 | 0 | 0 | | 335 | 172 | d0:67:e5:31:a5:32 | | 0 | 0 | 0 | 0 | | 337 | 173 | d0:67:e5:52:a8:c0 | | 0 | 0 | 0 | 0 | | 339 | 174 | d0:67:e5:52:a9:ea | | 0 | 0 | 0 | 0 | | 341 | 175 | d0:67:e5:52:aa:3f | | 0 | 0 | 0 | 0 | | 343 | 176 | d0:67:e5:52:b1:5b | | 0 | 0 | 0 | 0 | | 345 | 177 | d0:67:e5:52:a8:c7 | | 0 | 0 | 0 | 0 | | 347 | 178 | d0:67:e5:52:b1:6c | | 0 | 0 | 0 | 0 | | 351 | 181 | d0:67:e5:30:a7:b5 | | 0 | 0 | 0 | 0 | | 353 | 182 | d0:67:e5:30:c7:ff | | 0 | 0 | 0 | 0 | | 355 | 183 | d0:67:e5:31:a4:2b | | 0 | 0 | 0 | 0 | | 357 | 184 | d0:67:e5:3f:74:24 | | 0 | 0 | 0 | 0 | | 2808 | 1899 | 20:10:7a:42:5f:df | | 1 | | | | | 1788 | 1258 | 64:31:50:12:a6:23 | | 1 | | | | | 1789 | 1259 | b4:b5:2f:84:9b:20 | | 1 | | | | | 1790 | 1260 | b4:b5:2f:84:9c:ff | | 1 | | | | | 1792 | 1260 | a4:17:31:a5:18:dd | | 0 | 1 | 0 | 0 | | 1793 | 1259 | a4:17:31:5c:6d:e3 | | 0 | 1 | 0 | 0 | | 1794 | 1262 | e4:11:5b:51:3a:aa | | 1 | | | | | 1795 | 1263 | e4:11:5b:51:a1:42 | | 1 | | | | +------+----------+-------------------+--------+-----------+-----------+----------------+-----------------+ 28 rows in set (0.00 sec) mysql> SELECT * FROM `snapinAssoc` WHERE `saHostID` NOT IN (SELECT `hostID` FROM `hosts`); Empty set (0.00 sec) mysql> SELECT * FROM `groupMembers` WHERE `gmHostID` NOT IN (SELECT `hostID` FROM `hosts`); +------+----------+-----------+ | gmID | gmHostID | gmGroupID | +------+----------+-----------+ | 357 | 1221 | 3 | | 356 | 1220 | 3 | | 355 | 1219 | 3 | | 354 | 1218 | 3 | | 353 | 1217 | 3 | | 352 | 1216 | 3 | | 351 | 1215 | 3 | | 350 | 1214 | 3 | | 323 | 1129 | 3 | | 322 | 1128 | 3 | | 321 | 1127 | 3 | | 320 | 1126 | 3 | | 319 | 1125 | 3 | | 318 | 1124 | 3 | | 317 | 1113 | 3 | | 316 | 1112 | 3 | | 315 | 1111 | 3 | | 314 | 1110 | 3 | | 313 | 1109 | 3 | | 312 | 1108 | 3 | | 311 | 1107 | 3 | | 310 | 1106 | 3 | | 309 | 1105 | 3 | | 308 | 1104 | 3 | | 307 | 1103 | 3 | | 306 | 1102 | 3 | | 305 | 1101 | 3 | | 304 | 1100 | 3 | | 303 | 1099 | 3 | | 302 | 1098 | 3 | | 301 | 1097 | 3 | | 300 | 1096 | 3 | | 299 | 1095 | 3 | | 298 | 1094 | 3 | | 349 | 1213 | 3 | | 348 | 1212 | 3 | | 347 | 1211 | 3 | | 346 | 1210 | 3 | | 345 | 1209 | 3 | | 344 | 1208 | 3 | | 343 | 1207 | 3 | | 342 | 1206 | 3 | | 341 | 1205 | 3 | | 340 | 1204 | 3 | | 339 | 1203 | 3 | | 338 | 1202 | 3 | | 337 | 1201 | 3 | | 336 | 1200 | 3 | | 335 | 1199 | 3 | | 334 | 1198 | 3 | | 333 | 1197 | 3 | | 332 | 1196 | 3 | | 331 | 1195 | 3 | | 330 | 1194 | 3 | | 329 | 1193 | 3 | | 328 | 1192 | 3 | | 327 | 1191 | 3 | | 326 | 1190 | 3 | | 325 | 1189 | 3 | | 324 | 1188 | 3 | | 297 | 1093 | 3 | | 296 | 1092 | 3 | | 295 | 1091 | 3 | | 294 | 1090 | 3 | +------+----------+-----------+ 64 rows in set (0.00 sec) mysql>
