SOLVED FOG Registration Error. Hostname with that name already exists


  • @Wayne-Workman

    
    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> 
    

  • @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`);
    
  • Senior Developer

    @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.


  • @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
    The issue just started happening again! On RC11.
    0_1475849472256_upload-4ab700e0-28dd-47ac-a57f-e68f4d6b53b4


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

  • Senior Developer

    @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.


  • @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

    0_1474632538378_Results_Wayne.png

    0_1474634721723_upload-c49d878f-d7aa-4e64-b298-fa0c18c4c9c3


  • @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
    

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


  • @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

    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

    0_1474461261412_IMG_1237[1].JPG

  • Senior Developer

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


  • @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
    0_1474458947338_IMG_1234[1].JPG


  • Now, The issue is happening again!!


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


  • @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


  • @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

    0_1474038992543_upload-0d45c9cd-8536-4773-aa6a-ea9638f2f314


  • @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.


387
Online

8.1k
Users

15.0k
Topics

141.3k
Posts