FOG Registration Error. Hostname with that name already exists



  • I recently upgraded to the newest version of fog 1.3.0 RC-8. When I go to register ANY Computer, i receive an error saying “hostname with that name already exists.” Also when i try to view the Apache Error log via FOG’s Web GUI I recieve an error regarding permissions.

    Is there a way to reset the “hostname / registration” database and reimport my hosts?
    And reset the permissions to the Apache Log?

    0_1471348128387_Registration.png


  • Moderator

    @cojohnson said in FOG Registration Error. Hostname with that name already exists:

    It renamed and started working properly after i reset encryption data. However, I have had to do that every time

    This time isn’t the same if you followed what I asked, because you said you previously had to press the reset button twice, I asked you to press it once.


  • Senior Developer

    @cojohnson It sounds like the image that is being applied has a predefined security token.

    Normally this is fine as the imaging process resets the encryption data for you, but if the FOG Client is started in the boot phase of the image, a security token might be defined and forgotten about later on in the process. Because of this, the security tokens get out of sync which causes the issue.

    Is the client set to be disabled until the system is finished with it’s first start processes?



  • @Wayne-Workman @Tom-Elliott It renamed and started working properly after i reset encryption data. However, I have had to do that every time i tried to rename a HP Stream after a image or a fresh install of windows. Other models work fine and rename right away.


  • Moderator

    Ok so click the reset encryption button for that host - just once, restart the fog service on the problematic computer, wait 15 seconds and then look in the log. What do you find?


  • Senior Developer

    @Wayne-Workman IST always means “Invalid Security Token”.


  • Moderator

    pinging @Tom-Elliott



  • @Wayne-Workman OK, So I have created a new image and installed the FOG Client from a batch file after imaging. I am still getting…
    Response #!ist

    This is an HP Stream 11. It is registered in FOG with its WiFi MAC Address.

    Any Ideas on how to resolve this problem?


  • Moderator

    @cojohnson said in FOG Registration Error. Hostname with that name already exists:

    10/18/2016 10:49 AM Middleware::Response #!ist

    You shouldn’t have to press the reset encryption data button twice for it to work. If I remember right, it’s cleared anyways when you image. I lean towards there being an issue with your image, perhaps it needs to be deployed (but not bound to domain), and get the FOG Client working, reboot a few times, ensure it’s still working, and then re-capture to a new image and try that out.

    @Tom-Elliott what does #!ist mean? It’s in his log. Also, any ideas on this encryption resetting working after being done twice?



  • @Wayne-Workman OK, I reset the data encryption for all "HPStream"s by putting them into a group. However, the FOG Client still does not want to rename the computer until i reset the data encryption one more time after imaging. Is there a script i can from my Windows hosts to force “Reset Data Encryption” to occur?


  • Moderator

    @cojohnson said in FOG Registration Error. Hostname with that name already exists:

    10/18/2016 11:00 AM Middleware::Response Invalid time

    Make sure the time is correct on your hosts, and on your server. Also, immediate power management commands aren’t exactly imediate, they are performed the next time the FOG Client checks in with the server. However scheduled power actions happen exactly on time. This grace period for checkins can be adjusted to fit your needs and environment. Shorter checkin times does result in higher server load though.

    You can reset the encryption for all hosts via groups. Just put all hosts into a group, and use the group to reset the encryption data for them all.



  • @Wayne-Workman OK. I have played around with the “Reset Encryption Data” option. I reset the encryption data of the same computer “HPStream447” from the FOG Web GUI. Then i performed the following steps

    1:) i reimaged the computer and the fog client will tell me

    10/18/2016 10:49 AM Controller Initialize
     10/18/2016 10:49 AM Zazzles Creating main thread
     10/18/2016 10:49 AM Zazzles Service construction complete
     10/18/2016 10:49 AM Controller Start
    
     10/18/2016 10:49 AM Service Starting service
     10/18/2016 10:49 AM Bus Became bus server
     10/18/2016 10:49 AM Bus {
      "self": true,
      "channel": "Status",
      "data": "{\r\n  \"action\": \"load\"\r\n}"
    }
     10/18/2016 10:49 AM Bus Emmiting message on channel: Status
     10/18/2016 10:49 AM Service Invoking early JIT compilation on needed binaries
    
    ------------------------------------------------------------------------------
    --------------------------------Authentication--------------------------------
    ------------------------------------------------------------------------------
     10/18/2016 10:49 AM Client-Info Version: 0.11.5
     10/18/2016 10:49 AM Client-Info OS:      Windows
     10/18/2016 10:49 AM Middleware::Authentication Waiting for authentication timeout to pass
     10/18/2016 10:49 AM Middleware::Communication Download: http://10.21.0.105/fog/management/other/ssl/srvpublic.crt
     10/18/2016 10:49 AM Data::RSA FOG Server CA cert found
     10/18/2016 10:49 AM Middleware::Authentication Cert OK
     10/18/2016 10:49 AM Middleware::Authentication ERROR: Could not get security token
     10/18/2016 10:49 AM Middleware::Authentication ERROR: Could not find file 'C:\Program Files (x86)\FOG\token.dat'.
     10/18/2016 10:49 AM Middleware::Communication POST URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&authorize&newService
     10/18/2016 10:49 AM Middleware::Response #!ist
    
    ------------------------------------------------------------------------------
    --------------------------------Authentication--------------------------------
    ------------------------------------------------------------------------------
     10/18/2016 10:49 AM Client-Info Version: 0.11.5
     10/18/2016 10:49 AM Client-Info OS:      Windows
     10/18/2016 10:49 AM Middleware::Authentication Waiting for authentication timeout to pass
     10/18/2016 10:50 AM Main Overriding exception handling
     10/18/2016 10:50 AM Main Bootstrapping Zazzles
     10/18/2016 10:50 AM Controller Initialize
     10/18/2016 10:50 AM Zazzles Creating main thread
     10/18/2016 10:50 AM Zazzles Service construction complete
     10/18/2016 10:50 AM Controller Start
    
     10/18/2016 10:50 AM Service Starting service
     10/18/2016 10:50 AM Bus Became bus server
     10/18/2016 10:50 AM Bus {
      "self": true,
      "channel": "Status",
      "data": "{\r\n  \"action\": \"load\"\r\n}"
    }
     10/18/2016 10:50 AM Bus Emmiting message on channel: Status
     10/18/2016 10:50 AM Service Invoking early JIT compilation on needed binaries
    
    ------------------------------------------------------------------------------
    --------------------------------Authentication--------------------------------
    ------------------------------------------------------------------------------
     10/18/2016 10:50 AM Client-Info Version: 0.11.5
     10/18/2016 10:50 AM Client-Info OS:      Windows
     10/18/2016 10:50 AM Middleware::Authentication Waiting for authentication timeout to pass
     10/18/2016 10:50 AM Middleware::Communication Download: http://10.21.0.105/fog/management/other/ssl/srvpublic.crt
     10/18/2016 10:50 AM Data::RSA FOG Server CA cert found
     10/18/2016 10:50 AM Middleware::Authentication Cert OK
     10/18/2016 10:50 AM Middleware::Authentication ERROR: Could not get security token
     10/18/2016 10:50 AM Middleware::Authentication ERROR: Could not find file 'C:\Program Files (x86)\FOG\token.dat'.
     10/18/2016 10:50 AM Middleware::Communication POST URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&authorize&newService
     10/18/2016 10:50 AM Middleware::Response #!ist
    
    ------------------------------------------------------------------------------
    

    What is Middleware::Response #!ist?

    Next, I reseted the data encryption again and the fog client worked Mostly with the exception of a forced reboot to change the hostname.

    10/18/2016 11:00 AM Controller Initialize
     10/18/2016 11:00 AM Zazzles Creating main thread
     10/18/2016 11:00 AM Zazzles Service construction complete
     10/18/2016 11:00 AM Controller Start
    
     10/18/2016 11:00 AM Service Starting service
     10/18/2016 11:00 AM Bus Became bus server
     10/18/2016 11:00 AM Bus {
      "self": true,
      "channel": "Status",
      "data": "{\r\n  \"action\": \"load\"\r\n}"
    }
     10/18/2016 11:00 AM Bus Emmiting message on channel: Status
     10/18/2016 11:00 AM Service Invoking early JIT compilation on needed binaries
    
    ------------------------------------------------------------------------------
    --------------------------------Authentication--------------------------------
    ------------------------------------------------------------------------------
     10/18/2016 11:00 AM Client-Info Version: 0.11.5
     10/18/2016 11:00 AM Client-Info OS:      Windows
     10/18/2016 11:00 AM Middleware::Authentication Waiting for authentication timeout to pass
     10/18/2016 11:00 AM Middleware::Communication Download: http://10.21.0.105/fog/management/other/ssl/srvpublic.crt
     10/18/2016 11:00 AM Data::RSA FOG Server CA cert found
     10/18/2016 11:00 AM Middleware::Authentication Cert OK
     10/18/2016 11:00 AM Middleware::Authentication ERROR: Could not get security token
     10/18/2016 11:00 AM Middleware::Authentication ERROR: Could not find file 'C:\Program Files (x86)\FOG\token.dat'.
     10/18/2016 11:00 AM Middleware::Communication POST URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&authorize&newService
     10/18/2016 11:00 AM Middleware::Response Success
     10/18/2016 11:00 AM Middleware::Authentication Authenticated
    
    
     10/18/2016 11:00 AM Bus Registering ParseBus in channel Power
     10/18/2016 11:00 AM Middleware::Communication URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&mac=18:5E:0F:F0:8D:64|18:5E:0F:F0:8D:63|18:5E:0F:F0:8D:67||00:00:00:00:00:00:00:E0&newService&json
     10/18/2016 11:00 AM Middleware::Response Success
     10/18/2016 11:00 AM Middleware::Communication URL: http://10.21.0.105/fog/service/getversion.php?clientver&newService&json
     10/18/2016 11:00 AM Middleware::Communication URL: http://10.21.0.105/fog/service/getversion.php?newService&json
    
     10/18/2016 11:00 AM Service Creating user agent cache
     10/18/2016 11:00 AM Middleware::Response Invalid time
     10/18/2016 11:00 AM Middleware::Response No Printers
     10/18/2016 11:00 AM Middleware::Response Module is disabled globally on the FOG server
     10/18/2016 11:00 AM Service Initializing modules
    
    ------------------------------------------------------------------------------
    ---------------------------------ClientUpdater--------------------------------
    ------------------------------------------------------------------------------
     10/18/2016 11:00 AM Client-Info Client Version: 0.11.5
     10/18/2016 11:00 AM Client-Info Client OS:      Windows
     10/18/2016 11:00 AM Client-Info Server Version: 1.3.0-RC-14
     10/18/2016 11:00 AM Middleware::Response Success
    ------------------------------------------------------------------------------
    
    
    ------------------------------------------------------------------------------
    ----------------------------------TaskReboot----------------------------------
    ------------------------------------------------------------------------------
     10/18/2016 11:00 AM Client-Info Client Version: 0.11.5
     10/18/2016 11:00 AM Client-Info Client OS:      Windows
     10/18/2016 11:00 AM Client-Info Server Version: 1.3.0-RC-14
     10/18/2016 11:00 AM Middleware::Response Success
    ------------------------------------------------------------------------------
    
    
    ------------------------------------------------------------------------------
    --------------------------------HostnameChanger-------------------------------
    ------------------------------------------------------------------------------
     10/18/2016 11:00 AM Client-Info Client Version: 0.11.5
     10/18/2016 11:00 AM Client-Info Client OS:      Windows
     10/18/2016 11:00 AM Client-Info Server Version: 1.3.0-RC-14
     10/18/2016 11:00 AM Middleware::Response Success
     10/18/2016 11:00 AM HostnameChanger Users still logged in and enforce is disabled, delaying any further actions
    ------------------------------------------------------------------------------
    
    
    ------------------------------------------------------------------------------
    ---------------------------------SnapinClient---------------------------------
    ------------------------------------------------------------------------------
     10/18/2016 11:00 AM Client-Info Client Version: 0.11.5
     10/18/2016 11:00 AM Client-Info Client OS:      Windows
     10/18/2016 11:00 AM Client-Info Server Version: 1.3.0-RC-14
     10/18/2016 11:00 AM Middleware::Response No snapins
    ------------------------------------------------------------------------------
    
    
    ------------------------------------------------------------------------------
    --------------------------------PrinterManager--------------------------------
    ------------------------------------------------------------------------------
     10/18/2016 11:00 AM Client-Info Client Version: 0.11.5
     10/18/2016 11:00 AM Client-Info Client OS:      Windows
     10/18/2016 11:00 AM Client-Info Server Version: 1.3.0-RC-14
     10/18/2016 11:00 AM Middleware::Response No Printers
     10/18/2016 11:00 AM PrinterManager Getting installed printers
    ------------------------------------------------------------------------------
    
    
    ------------------------------------------------------------------------------
    --------------------------------PowerManagement-------------------------------
    ------------------------------------------------------------------------------
     10/18/2016 11:00 AM Client-Info Client Version: 0.11.5
     10/18/2016 11:00 AM Client-Info Client OS:      Windows
     10/18/2016 11:00 AM Client-Info Server Version: 1.3.0-RC-14
     10/18/2016 11:00 AM Middleware::Response Success
     10/18/2016 11:00 AM PowerManagement Calculating tasks to unschedule
     10/18/2016 11:00 AM PowerManagement Calculating tasks to schedule
    ------------------------------------------------------------------------------
    
    
    ------------------------------------------------------------------------------
    ----------------------------------UserTracker---------------------------------
    ------------------------------------------------------------------------------
     10/18/2016 11:00 AM Client-Info Client Version: 0.11.5
     10/18/2016 11:00 AM Client-Info Client OS:      Windows
     10/18/2016 11:00 AM Client-Info Server Version: 1.3.0-RC-14
     10/18/2016 11:00 AM Middleware::Response Success
     10/18/2016 11:00 AM Middleware::Communication URL: http://10.21.0.105/fog/service/usertracking.report.php?action=login&user=GENERIC-PC\WCSCC&mac=18:5E:0F:F0:8D:64|18:5E:0F:F0:8D:63|18:5E:0F:F0:8D:67||00:00:00:00:00:00:00:E0&newService&json
    ------------------------------------------------------------------------------
    
     10/18/2016 11:00 AM Middleware::Communication URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&configure&newService&json
     10/18/2016 11:00 AM Middleware::Response Success
     10/18/2016 11:00 AM Service Sleeping for 98 seconds
     10/18/2016 11:02 AM Middleware::Communication URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&mac=18:5E:0F:F0:8D:64|18:5E:0F:F0:8D:63|18:5E:0F:F0:8D:67||00:00:00:00:00:00:00:E0&newService&json
     10/18/2016 11:02 AM Middleware::Response Success
     10/18/2016 11:02 AM Middleware::Communication URL: http://10.21.0.105/fog/service/getversion.php?clientver&newService&json
     10/18/2016 11:02 AM Middleware::Communication URL: http://10.21.0.105/fog/service/getversion.php?newService&json
    
     10/18/2016 11:02 AM Service Creating user agent cache
     10/18/2016 11:02 AM Middleware::Response Invalid time
     10/18/2016 11:02 AM Middleware::Response No Printers
     10/18/2016 11:02 AM Middleware::Response Module is disabled globally on the FOG server
    
    ------------------------------------------------------------------------------
    ---------------------------------ClientUpdater--------------------------------
    ------------------------------------------------------------------------------
     10/18/2016 11:02 AM Client-Info Client Version: 0.11.5
     10/18/2016 11:02 AM Client-Info Client OS:      Windows
     10/18/2016 11:02 AM Client-Info Server Version: 1.3.0-RC-14
     10/18/2016 11:02 AM Middleware::Response Success
    ------------------------------------------------------------------------------
    
    
    ------------------------------------------------------------------------------
    ----------------------------------TaskReboot----------------------------------
    ------------------------------------------------------------------------------
     10/18/2016 11:02 AM Client-Info Client Version: 0.11.5
     10/18/2016 11:02 AM Client-Info Client OS:      Windows
     10/18/2016 11:02 AM Client-Info Server Version: 1.3.0-RC-14
     10/18/2016 11:02 AM Middleware::Response Module is disabled globally on the FOG server
    ------------------------------------------------------------------------------
    
    
    ------------------------------------------------------------------------------
    --------------------------------HostnameChanger-------------------------------
    ------------------------------------------------------------------------------
     10/18/2016 11:02 AM Client-Info Client Version: 0.11.5
     10/18/2016 11:02 AM Client-Info Client OS:      Windows
     10/18/2016 11:02 AM Client-Info Server Version: 1.3.0-RC-14
     10/18/2016 11:02 AM Middleware::Response Success
     10/18/2016 11:02 AM HostnameChanger Users still logged in and enforce is disabled, delaying any further actions
    ------------------------------------------------------------------------------
    
    
    ------------------------------------------------------------------------------
    ---------------------------------SnapinClient---------------------------------
    ------------------------------------------------------------------------------
     10/18/2016 11:02 AM Client-Info Client Version: 0.11.5
     10/18/2016 11:02 AM Client-Info Client OS:      Windows
     10/18/2016 11:02 AM Client-Info Server Version: 1.3.0-RC-14
     10/18/2016 11:02 AM Middleware::Response No snapins
    ------------------------------------------------------------------------------
    
    
    ------------------------------------------------------------------------------
    --------------------------------PrinterManager--------------------------------
    ------------------------------------------------------------------------------
     10/18/2016 11:02 AM Client-Info Client Version: 0.11.5
     10/18/2016 11:02 AM Client-Info Client OS:      Windows
     10/18/2016 11:02 AM Client-Info Server Version: 1.3.0-RC-14
     10/18/2016 11:02 AM Middleware::Response No Printers
     10/18/2016 11:02 AM PrinterManager Getting installed printers
    ------------------------------------------------------------------------------
    
    
    ------------------------------------------------------------------------------
    --------------------------------PowerManagement-------------------------------
    ------------------------------------------------------------------------------
     10/18/2016 11:02 AM Client-Info Client Version: 0.11.5
     10/18/2016 11:02 AM Client-Info Client OS:      Windows
     10/18/2016 11:02 AM Client-Info Server Version: 1.3.0-RC-14
     10/18/2016 11:02 AM Middleware::Response Success
     10/18/2016 11:02 AM PowerManagement Calculating tasks to unschedule
     10/18/2016 11:02 AM PowerManagement Calculating tasks to schedule
    ------------------------------------------------------------------------------
    
    
    ------------------------------------------------------------------------------
    ----------------------------------UserTracker---------------------------------
    ------------------------------------------------------------------------------
     10/18/2016 11:02 AM Client-Info Client Version: 0.11.5
     10/18/2016 11:02 AM Client-Info Client OS:      Windows
     10/18/2016 11:02 AM Client-Info Server Version: 1.3.0-RC-14
     10/18/2016 11:02 AM Middleware::Response Success
    ------------------------------------------------------------------------------
    

    0_1476805503524_Force_Reboot.PNG

    Is there a way to “Reset Data Encryption” from my windows hosts for automation?



  • @Wayne-Workman

    I do not know where the “18:5E:0F:F0:8D:64” came from in the line

    Just wanted to answer that one statement. If you look at the results of the SQL statements you ran, just below, you’ll see that one of the results has that MAC with a host ID of 0, this would of course mess up a ton of stuff in fog.

    Yeah, that is interesting. I ran a “getmac -v” (included in yesterday’s post) to see a list of the mac addresses and 18-5E-0F-F0-8D-64 was not in the output. I was curious as to where that MAC addreess was coming from.


  • Moderator

    @cojohnson said in FOG Registration Error. Hostname with that name already exists:

    I do not know where the “18:5E:0F:F0:8D:64” came from in the line

    Just wanted to answer that one statement. If you look at the results of the SQL statements you ran, just below, you’ll see that one of the results has that MAC with a host ID of 0, this would of course mess up a ton of stuff in fog.



  • @Wayne-Workman said in FOG Registration Error. Hostname with that name already exists:

    Also, again you can run the below delete commands to clean those entries up.

    Thank You!!

    I cleaned up those entries and updated to the latest version RC-14.

    I am currently testing the “Reset Data Encyption” now and will post my results


  • Moderator

    @cojohnson said in FOG Registration Error. Hostname with that name already exists:

    10/17/2016 8:02 AM Middleware::Response Invalid security token

    This is why the FOG Client isn’t working, did you rebuild the FOG Server? Try clicking the “Reset Encryption Data” button for this host in the web gui.


  • Moderator

    @cojohnson Pinging @Tom-Elliott so he’s aware. For the time being, please update to RC-14 and see if it’s resolved or not. Tom considers RC-14 to be the most stable version of FOG since FOG 0.32.

    Also, again you can run the below delete commands to clean those entries up.



  • @Wayne-Workman

    Here is the fog.txt file

    NOTE At 8:10, I changed the “Ignore MAC on Client” option just to see what would happen.

    0_1476715181516_Ignore FOG Client.PNG

     10/17/2016 8:02 AM Main Overriding exception handling
     10/17/2016 8:02 AM Main Bootstrapping Zazzles
     10/17/2016 8:02 AM Controller Initialize
     10/17/2016 8:02 AM Zazzles Creating main thread
     10/17/2016 8:02 AM Zazzles Service construction complete
     10/17/2016 8:02 AM Controller Start
    
     10/17/2016 8:02 AM Service Starting service
     10/17/2016 8:02 AM Bus Became bus server
     10/17/2016 8:02 AM Bus {
      "self": true,
      "channel": "Status",
      "data": "{\r\n  \"action\": \"load\"\r\n}"
    }
     10/17/2016 8:02 AM Bus Emmiting message on channel: Status
     10/17/2016 8:02 AM Service Invoking early JIT compilation on needed binaries
    
    ------------------------------------------------------------------------------
    --------------------------------Authentication--------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:02 AM Client-Info Version: 0.11.5
     10/17/2016 8:02 AM Client-Info OS:      Windows
     10/17/2016 8:02 AM Middleware::Authentication Waiting for authentication timeout to pass
     10/17/2016 8:02 AM Middleware::Communication Download: http://10.21.0.105/fog/management/other/ssl/srvpublic.crt
     10/17/2016 8:02 AM Data::RSA FOG Server CA cert found
     10/17/2016 8:02 AM Middleware::Authentication Cert OK
     10/17/2016 8:02 AM Middleware::Authentication ERROR: Could not get security token
     10/17/2016 8:02 AM Middleware::Authentication ERROR: Could not find file 'C:\Program Files (x86)\FOG\token.dat'.
     10/17/2016 8:02 AM Middleware::Communication POST URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&authorize&newService
     10/17/2016 8:02 AM Middleware::Response Invalid security token
    
    ------------------------------------------------------------------------------
    --------------------------------Authentication--------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:02 AM Client-Info Version: 0.11.5
     10/17/2016 8:02 AM Client-Info OS:      Windows
     10/17/2016 8:02 AM Middleware::Authentication Waiting for authentication timeout to pass
     10/17/2016 8:04 AM Middleware::Communication Download: http://10.21.0.105/fog/management/other/ssl/srvpublic.crt
     10/17/2016 8:04 AM Data::RSA FOG Server CA cert found
     10/17/2016 8:04 AM Middleware::Authentication Cert OK
     10/17/2016 8:04 AM Middleware::Authentication ERROR: Could not get security token
     10/17/2016 8:04 AM Middleware::Authentication ERROR: Could not find file 'C:\Program Files (x86)\FOG\token.dat'.
     10/17/2016 8:04 AM Middleware::Communication POST URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&authorize&newService
     10/17/2016 8:04 AM Middleware::Response Invalid security token
    
    ------------------------------------------------------------------------------
    --------------------------------Authentication--------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:04 AM Client-Info Version: 0.11.5
     10/17/2016 8:04 AM Client-Info OS:      Windows
     10/17/2016 8:04 AM Middleware::Authentication Waiting for authentication timeout to pass
     10/17/2016 8:06 AM Middleware::Communication Download: http://10.21.0.105/fog/management/other/ssl/srvpublic.crt
     10/17/2016 8:06 AM Data::RSA FOG Server CA cert found
     10/17/2016 8:06 AM Middleware::Authentication Cert OK
     10/17/2016 8:06 AM Middleware::Authentication ERROR: Could not get security token
     10/17/2016 8:06 AM Middleware::Authentication ERROR: Could not find file 'C:\Program Files (x86)\FOG\token.dat'.
     10/17/2016 8:06 AM Middleware::Communication POST URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&authorize&newService
     10/17/2016 8:06 AM Middleware::Response Invalid security token
    
    ------------------------------------------------------------------------------
    --------------------------------Authentication--------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:06 AM Client-Info Version: 0.11.5
     10/17/2016 8:06 AM Client-Info OS:      Windows
     10/17/2016 8:06 AM Middleware::Authentication Waiting for authentication timeout to pass
     10/17/2016 8:08 AM Middleware::Communication Download: http://10.21.0.105/fog/management/other/ssl/srvpublic.crt
     10/17/2016 8:08 AM Data::RSA FOG Server CA cert found
     10/17/2016 8:08 AM Middleware::Authentication Cert OK
     10/17/2016 8:08 AM Middleware::Authentication ERROR: Could not get security token
     10/17/2016 8:08 AM Middleware::Authentication ERROR: Could not find file 'C:\Program Files (x86)\FOG\token.dat'.
     10/17/2016 8:08 AM Middleware::Communication POST URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&authorize&newService
     10/17/2016 8:08 AM Middleware::Response Invalid security token
    
    ------------------------------------------------------------------------------
    --------------------------------Authentication--------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:08 AM Client-Info Version: 0.11.5
     10/17/2016 8:08 AM Client-Info OS:      Windows
     10/17/2016 8:08 AM Middleware::Authentication Waiting for authentication timeout to pass
     10/17/2016 8:10 AM Middleware::Communication Download: http://10.21.0.105/fog/management/other/ssl/srvpublic.crt
     10/17/2016 8:10 AM Data::RSA FOG Server CA cert found
     10/17/2016 8:10 AM Middleware::Authentication Cert OK
     10/17/2016 8:10 AM Middleware::Authentication ERROR: Could not get security token
     10/17/2016 8:10 AM Middleware::Authentication ERROR: Could not find file 'C:\Program Files (x86)\FOG\token.dat'.
     10/17/2016 8:10 AM Middleware::Communication POST URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&authorize&newService
     10/17/2016 8:10 AM Middleware::Response Invalid security token
    
    
     10/17/2016 8:10 AM Bus Registering ParseBus in channel Power
     10/17/2016 8:10 AM Middleware::Communication URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&mac=18:5E:0F:F0:8D:64|18:5E:0F:F0:8D:63|18:5E:0F:F0:8D:67||00:00:00:00:00:00:00:E0&newService&json
     10/17/2016 8:10 AM Middleware::Authentication Waiting for authentication timeout to pass
     10/17/2016 8:12 AM Middleware::Communication Download: http://10.21.0.105/fog/management/other/ssl/srvpublic.crt
     10/17/2016 8:12 AM Data::RSA FOG Server CA cert found
     10/17/2016 8:12 AM Middleware::Authentication Cert OK
     10/17/2016 8:12 AM Middleware::Authentication ERROR: Could not get security token
     10/17/2016 8:12 AM Middleware::Authentication ERROR: Could not find file 'C:\Program Files (x86)\FOG\token.dat'.
     10/17/2016 8:12 AM Middleware::Communication POST URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&authorize&newService
     10/17/2016 8:12 AM Middleware::Response Invalid security token
     10/17/2016 8:12 AM Middleware::Response Success
     10/17/2016 8:12 AM Middleware::Communication URL: http://10.21.0.105/fog/service/getversion.php?clientver&newService&json
     10/17/2016 8:12 AM Middleware::Communication URL: http://10.21.0.105/fog/service/getversion.php?newService&json
    
     10/17/2016 8:12 AM Service Creating user agent cache
     10/17/2016 8:12 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:12 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
     10/17/2016 8:12 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:12 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
     10/17/2016 8:12 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:12 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
     10/17/2016 8:12 AM Service Initializing modules
    
    ------------------------------------------------------------------------------
    ---------------------------------ClientUpdater--------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:12 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:12 AM Client-Info Client OS:      Windows
     10/17/2016 8:12 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:12 AM Middleware::Response Success
    ------------------------------------------------------------------------------
    
    
    ------------------------------------------------------------------------------
    ----------------------------------TaskReboot----------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:12 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:12 AM Client-Info Client OS:      Windows
     10/17/2016 8:12 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:12 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:12 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
    
    ------------------------------------------------------------------------------
    --------------------------------HostnameChanger-------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:12 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:12 AM Client-Info Client OS:      Windows
     10/17/2016 8:12 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:12 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:12 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
    
    ------------------------------------------------------------------------------
    ---------------------------------SnapinClient---------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:12 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:12 AM Client-Info Client OS:      Windows
     10/17/2016 8:12 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:12 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:12 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
    
    ------------------------------------------------------------------------------
    --------------------------------PrinterManager--------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:12 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:12 AM Client-Info Client OS:      Windows
     10/17/2016 8:12 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:12 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:12 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
    
    ------------------------------------------------------------------------------
    --------------------------------PowerManagement-------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:12 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:12 AM Client-Info Client OS:      Windows
     10/17/2016 8:12 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:12 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:12 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
    
    ------------------------------------------------------------------------------
    ----------------------------------UserTracker---------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:12 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:12 AM Client-Info Client OS:      Windows
     10/17/2016 8:12 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:12 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:12 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
     10/17/2016 8:12 AM Middleware::Communication URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&configure&newService&json
     10/17/2016 8:12 AM Middleware::Response Success
     10/17/2016 8:12 AM Service Sleeping for 145 seconds
     10/17/2016 8:15 AM Middleware::Communication URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&mac=18:5E:0F:F0:8D:64|18:5E:0F:F0:8D:63|18:5E:0F:F0:8D:67||00:00:00:00:00:00:00:E0&newService&json
     10/17/2016 8:15 AM Middleware::Authentication Waiting for authentication timeout to pass
     10/17/2016 8:15 AM Middleware::Communication Download: http://10.21.0.105/fog/management/other/ssl/srvpublic.crt
     10/17/2016 8:15 AM Data::RSA FOG Server CA cert found
     10/17/2016 8:15 AM Middleware::Authentication Cert OK
     10/17/2016 8:15 AM Middleware::Authentication ERROR: Could not get security token
     10/17/2016 8:15 AM Middleware::Authentication ERROR: Could not find file 'C:\Program Files (x86)\FOG\token.dat'.
     10/17/2016 8:15 AM Middleware::Communication POST URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&authorize&newService
     10/17/2016 8:15 AM Middleware::Response Invalid security token
     10/17/2016 8:15 AM Middleware::Response Success
     10/17/2016 8:15 AM Middleware::Communication URL: http://10.21.0.105/fog/service/getversion.php?clientver&newService&json
     10/17/2016 8:15 AM Middleware::Communication URL: http://10.21.0.105/fog/service/getversion.php?newService&json
    
     10/17/2016 8:15 AM Service Creating user agent cache
     10/17/2016 8:15 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:15 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
     10/17/2016 8:15 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:15 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
     10/17/2016 8:15 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:15 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
    
    ------------------------------------------------------------------------------
    ---------------------------------ClientUpdater--------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:15 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:15 AM Client-Info Client OS:      Windows
     10/17/2016 8:15 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:15 AM Middleware::Response Success
    ------------------------------------------------------------------------------
    
    
    ------------------------------------------------------------------------------
    ----------------------------------TaskReboot----------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:15 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:15 AM Client-Info Client OS:      Windows
     10/17/2016 8:15 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:15 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:15 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
    
    ------------------------------------------------------------------------------
    --------------------------------HostnameChanger-------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:15 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:15 AM Client-Info Client OS:      Windows
     10/17/2016 8:15 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:15 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:15 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
    
    ------------------------------------------------------------------------------
    ---------------------------------SnapinClient---------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:15 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:15 AM Client-Info Client OS:      Windows
     10/17/2016 8:15 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:15 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:15 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
    
    ------------------------------------------------------------------------------
    --------------------------------PrinterManager--------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:15 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:15 AM Client-Info Client OS:      Windows
     10/17/2016 8:15 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:15 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:15 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
    
    ------------------------------------------------------------------------------
    --------------------------------PowerManagement-------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:15 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:15 AM Client-Info Client OS:      Windows
     10/17/2016 8:15 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:15 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:15 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
    
    ------------------------------------------------------------------------------
    ----------------------------------UserTracker---------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:15 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:15 AM Client-Info Client OS:      Windows
     10/17/2016 8:15 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:15 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:15 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
     10/17/2016 8:15 AM Middleware::Communication URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&configure&newService&json
     10/17/2016 8:15 AM Middleware::Response Success
     10/17/2016 8:15 AM Service Sleeping for 118 seconds
     10/17/2016 8:17 AM Middleware::Communication URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&mac=18:5E:0F:F0:8D:64|18:5E:0F:F0:8D:63|18:5E:0F:F0:8D:67||00:00:00:00:00:00:00:E0&newService&json
     10/17/2016 8:17 AM Middleware::Authentication Waiting for authentication timeout to pass
     10/17/2016 8:17 AM Middleware::Communication Download: http://10.21.0.105/fog/management/other/ssl/srvpublic.crt
     10/17/2016 8:17 AM Data::RSA FOG Server CA cert found
     10/17/2016 8:17 AM Middleware::Authentication Cert OK
     10/17/2016 8:17 AM Middleware::Authentication ERROR: Could not get security token
     10/17/2016 8:17 AM Middleware::Authentication ERROR: Could not find file 'C:\Program Files (x86)\FOG\token.dat'.
     10/17/2016 8:17 AM Middleware::Communication POST URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&authorize&newService
     10/17/2016 8:17 AM Middleware::Response Invalid security token
     10/17/2016 8:17 AM Middleware::Response Success
     10/17/2016 8:17 AM Middleware::Communication URL: http://10.21.0.105/fog/service/getversion.php?clientver&newService&json
     10/17/2016 8:17 AM Middleware::Communication URL: http://10.21.0.105/fog/service/getversion.php?newService&json
    
     10/17/2016 8:17 AM Service Creating user agent cache
     10/17/2016 8:17 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:17 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
     10/17/2016 8:17 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:17 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
     10/17/2016 8:17 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:17 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
    
    ------------------------------------------------------------------------------
    ---------------------------------ClientUpdater--------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:17 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:17 AM Client-Info Client OS:      Windows
     10/17/2016 8:17 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:17 AM Middleware::Response Success
    ------------------------------------------------------------------------------
    
    
    ------------------------------------------------------------------------------
    ----------------------------------TaskReboot----------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:17 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:17 AM Client-Info Client OS:      Windows
     10/17/2016 8:17 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:17 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:17 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
    
    ------------------------------------------------------------------------------
    --------------------------------HostnameChanger-------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:17 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:17 AM Client-Info Client OS:      Windows
     10/17/2016 8:17 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:17 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:17 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
    
    ------------------------------------------------------------------------------
    ---------------------------------SnapinClient---------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:17 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:17 AM Client-Info Client OS:      Windows
     10/17/2016 8:17 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:17 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:17 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
    
    ------------------------------------------------------------------------------
    --------------------------------PrinterManager--------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:17 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:17 AM Client-Info Client OS:      Windows
     10/17/2016 8:17 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:17 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:17 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
    
    ------------------------------------------------------------------------------
    --------------------------------PowerManagement-------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:17 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:17 AM Client-Info Client OS:      Windows
     10/17/2016 8:17 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:17 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:17 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
    
    ------------------------------------------------------------------------------
    ----------------------------------UserTracker---------------------------------
    ------------------------------------------------------------------------------
     10/17/2016 8:17 AM Client-Info Client Version: 0.11.5
     10/17/2016 8:17 AM Client-Info Client OS:      Windows
     10/17/2016 8:17 AM Client-Info Server Version: 1.3.0-RC-10
     10/17/2016 8:17 AM Middleware::Response ERROR: Unable to get subsection
     10/17/2016 8:17 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
     10/17/2016 8:17 AM Middleware::Communication URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&configure&newService&json
     10/17/2016 8:17 AM Middleware::Response Success
     10/17/2016 8:17 AM Service Sleeping for 98 seconds
     10/17/2016 8:18 AM Middleware::Communication URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&mac=18:5E:0F:F0:8D:64|18:5E:0F:F0:8D:63|18:5E:0F:F0:8D:67||00:00:00:00:00:00:00:E0&newService&json
     10/17/2016 8:18 AM Middleware::Authentication Waiting for authentication timeout to pass
    

    I do not know where the “18:5E:0F:F0:8D:64” came from in the line

     10/17/2016 8:10 AM Middleware::Communication URL: http://10.21.0.105/fog/management/index.php?sub=requestClientInfo&mac=18:5E:0F:F0:8D:64|18:5E:0F:F0:8D:63|18:5E:0F:F0:8D:67||00:00:00:00:00:00:00:E0&newService&json
    
    C:\Users\WCSCC>getmac -v /fo list
    
    Connection Name:  Wi-Fi
    Network Adapter:  Intel(R) Dual Band Wireless-AC 7265
    Physical Address: 18-5E-0F-F0-8D-63
    Transport Name:   \Device\Tcpip_{65B67789-0AFC-4AB3-BEDA-EBC5D4D3725D}
    
    Connection Name:  Bluetooth Network Connection
    Network Adapter:  Bluetooth Device (Personal Area Network)
    Physical Address: 18-5E-0F-F0-8D-67
    Transport Name:   Media disconnected
    
    C:\Users\WCSCC>```


  • @Wayne-Workman

    I ran those commands again today after troubleshooting why all computers of one model “HP Stream 11” are not getting their hostnames changed by the FOG Client.

    Note I still get the “Hostname with that name already exists” error when there are entries for the command:
    SELECT * FROM hostMAC WHERE hmID = ‘0’ OR hmHostID = ‘0’;

    Here are the results of the commands

    mysql> 
    mysql> SELECT `hostID`, `hostName` FROM `hosts` WHERE `hostID` = '0';
    +--------+----------+
    | hostID | hostName |
    +--------+----------+
    |      0 |          |
    +--------+----------+
    1 row in set (0.00 sec)
    
    mysql> SELECT * FROM `hostMAC` WHERE hmID = '0' OR `hmHostID` = '0';
    +------+----------+-------------------+--------+-----------+-----------+----------------+-----------------+
    | hmID | hmHostID | hmMAC             | hmDesc | hmPrimary | hmPending | hmIgnoreClient | hmIgnoreImaging |
    +------+----------+-------------------+--------+-----------+-----------+----------------+-----------------+
    | 2903 |        0 | 18:5e:0f:f0:8d:64 |        | 1         |           |                |                 |
    | 2904 |        0 | 18:5e:0f:f0:8d:67 |        | 0         | 0         | 0              | 0               |
    +------+----------+-------------------+--------+-----------+-----------+----------------+-----------------+
    2 rows in set (0.00 sec)
    
    mysql> SELECT * FROM `groupMembers` WHERE `gmID` = '0' OR `gmHostID` = '0' OR `gmGroupID` = '0';
    +------+----------+-----------+
    | gmID | gmHostID | gmGroupID |
    +------+----------+-----------+
    |  424 |     1936 |         0 |
    +------+----------+-----------+
    1 row in set (0.00 sec)
    
    mysql> SELECT * FROM `snapinGroupAssoc` WHERE `sgaID` = '0' OR `sgaSnapinID` = '0' OR `sgaStorageGroupID` = '0';
    Empty set (0.00 sec)
    mysql> SELECT * from `snapinAssoc` WHERE `saID` = '0' OR `saHostID` = '0' OR `saSnapinID` = '0'; 
    +------+----------+------------+
    | saID | saHostID | saSnapinID |
    +------+----------+------------+
    |   71 |     1936 |          0 |
    +------+----------+------------+
    1 row in set (0.00 sec)
    
    mysql> 
    
    

  • Moderator

    @cojohnson All of those are dirty entries that are either hosts with no MAC, or MACs with no host, or associations with no host. They can all be deleted with the below commands. Do me a favor please, and in about a week from now, re-run the earlier commands I asked you to run ( the select ones) and see if there is any output again or not. Also pinging @Tom-Elliott so he’s aware of this.

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

Log in to reply
 

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.