Unable to deploy Snapins - Stuck in Que

[tyler2017]

@Tom-Elliott Getting this also:

---

----------------------------------UserTracker---------------------------------

6/29/2017 3:52 PM Client-Info Client Version: 0.11.12
6/29/2017 3:52 PM Client-Info Client OS: Windows
6/29/2017 3:52 PM Client-Info Server Version: “A valid database connection could not be made”
6/29/2017 3:52 PM Middleware::Response ERROR: Unable to get subsection
6/29/2017 3:52 PM Middleware::Response ERROR: Object reference not set to an instance of an object.
6/29/2017 3:52 PM Service Sleeping for 95 seconds
6/29/2017 3:53 PM Middleware::Communication URL: http://10.30.19.2/fog/management/index.php?sub=requestClientInfo&configure&newService&json
6/29/2017 3:53 PM Middleware::Response Success
6/29/2017 3:53 PM Middleware::Communication URL: http://10.30.19.2/fog/management/index.php?sub=requestClientInfo&mac=98:E7:F4:F4:0A:5E|E4:A7:A0:B6:55:2A|E4:A7:A0:B6:55:26|00:09:0F:FE:00:01||00:00:00:00:00:00:00:E0|00:00:00:00:00:00:00:E0|00:00:00:00:00:00:00:E0|00:00:00:00:00:00:00:E0|00:00:00:00:00:00:00:E0&newService&json
6/29/2017 3:53 PM Middleware::Response ERROR: Could not parse data
6/29/2017 3:53 PM Middleware::Response ERROR: Unexpected character encountered while parsing value: E. Path ‘’, line 0, position 0.
6/29/2017 3:53 PM Middleware::Communication URL: http://10.30.19.2/fog/service/getversion.php?clientver&newService&json
6/29/2017 3:53 PM Middleware::Communication URL: http://10.30.19.2/fog/service/getversion.php?newService&json
6/29/2017 3:53 PM Service ERROR: Unable to get cycle data
6/29/2017 3:53 PM Service ERROR: Object reference not set to an instance of an object.
6/29/2017 3:53 PM Middleware::Response Success

[Tom Elliott]

@tyler2017 So the “Error multiple hosts returned for list of mac addresses” means there’s likely a duplicate MAC Address being passed, but what you’re looking at for “mac addresses” is not the same as the list the client is passing.

I’m not saying you did anything wrong and I hope I just corrected some of the checking code.

Would you mind trying:

wget -O /var/www/fog/lib/fog/hostmanager.class.php https://raw.githubusercontent.com/FOGProject/fogproject/57d36f5ce22b960db99ad290f1d20b7be1c93e37/packages/web/lib/fog/hostmanager.class.php

# Ensure /var/www/html/fog has updated file just in case /var/www/fog is not already linked appropriately.
wget -O /var/www/html/fog/lib/fog/hostmanager.class.php https://raw.githubusercontent.com/FOGProject/fogproject/57d36f5ce22b960db99ad290f1d20b7be1c93e37/packages/web/lib/fog/hostmanager.class.php

[Tom Elliott]

@tyler2017 said in Unable to deploy Snapins - Stuck in Que:

“A valid database connection could not be made”

Of note, for this error above, it seems possible that DB is full, or not running properly? (Maybe a whole ton of data causing a delay getting the information.)

I’m only guessing based on what I see. This is, for the most part, unrelated to the “Multiple errors exist” thought it’s not impossible a Full/Corrupt DB would be sending a ton more information than expected causing the error to throw. (So DB issues could send lots of excess data in the query, but this would only happen if the DB instance was still running.)

[tyler2017]

@Tom-Elliott I tried the commands you suggested. I’ve not noticed any changes in anything. The fog.log on all clients is still showing the same thing. Still unable to push snapins…

[Tom Elliott]

@tyler2017 Do you mean you’re getting the Invalid database error still?

[tyler2017]

This post is deleted!

[tyler2017]

@Tom-Elliott I no longer see the database connection error, but I do still get these…

Authentication:

6/30/2017 10:31 AM Client-Info Version: 0.11.12
6/30/2017 10:31 AM Client-Info OS: Windows
6/30/2017 10:31 AM Middleware::Authentication Waiting for authentication timeout to pass
6/30/2017 10:33 AM Middleware::Communication Download: http://10.30.19.2/fog/management/other/ssl/srvpublic.crt
6/30/2017 10:33 AM Data::RSA FOG Server CA cert found
6/30/2017 10:33 AM Middleware::Authentication Cert OK
6/30/2017 10:33 AM Middleware::Authentication ERROR: Could not get security token
6/30/2017 10:33 AM Middleware::Authentication ERROR: Could not find file ‘C:\Program Files (x86)\FOG\token.dat’.
6/30/2017 10:33 AM Middleware::Communication POST URL: http://10.30.19.2/fog/management/index.php?sub=requestClientInfo&authorize&newService
6/30/2017 10:33 AM Middleware::Response Error multiple hosts returned for list of mac addresses

6/30/2017 10:33 AM Middleware::Communication URL: http://10.30.19.2/fog/management/index.php?sub=requestClientInfo&configure&newService&json
6/30/2017 10:33 AM Middleware::Response Success
6/30/2017 10:33 AM Middleware::Communication URL: http://10.30.19.2/fog/management/index.php?sub=requestClientInfo&mac=1A:E3:47:B3:65:43|28:E3:47:B3:7C:B3|28:E3:47:B3:65:43|00:09:0F:FE:00:01|A0:1D:48:B0:29:CC||00:00:00:00:00:00:00:E0|00:00:00:00:00:00:00:E0|00:00:00:00:00:00:00:E0&newService&json
6/30/2017 10:33 AM Middleware::Response ERROR: Could not parse data
6/30/2017 10:33 AM Middleware::Response ERROR: Unexpected character encountered while parsing value: E. Path ‘’, line 0, position 0.
6/30/2017 10:33 AM Middleware::Communication URL: http://10.30.19.2/fog/service/getversion.php?clientver&newService&json
6/30/2017 10:33 AM Middleware::Communication URL: http://10.30.19.2/fog/service/getversion.php?newService&json
6/30/2017 10:33 AM Service ERROR: Unable to get cycle data
6/30/2017 10:33 AM Service ERROR: Object reference not set to an instance of an object.
6/30/2017 10:33 AM Middleware::Response Success
6/30/2017 10:33 AM Service Initializing modules

UserTracker:

6/30/2017 10:33 AM Client-Info Client Version: 0.11.12
6/30/2017 10:33 AM Client-Info Client OS: Windows
6/30/2017 10:33 AM Client-Info Server Version:
6/30/2017 10:33 AM Middleware::Response ERROR: Unable to get subsection
6/30/2017 10:33 AM Middleware::Response ERROR: Object reference not set to an instance of an object.
6/30/2017 10:33 AM Service Sleeping for 143 seconds
6/30/2017 10:35 AM Middleware::Communication URL: http://10.30.19.2/fog/management/index.php?sub=requestClientInfo&configure&newService&json
6/30/2017 10:35 AM Middleware::Response Success
6/30/2017 10:35 AM Middleware::Communication URL: http://10.30.19.2/fog/management/index.php?sub=requestClientInfo&mac=1A:E3:47:B3:65:43|28:E3:47:B3:7C:B3|28:E3:47:B3:65:43|00:09:0F:FE:00:01|A0:1D:48:B0:29:CC||00:00:00:00:00:00:00:E0|00:00:00:00:00:00:00:E0|00:00:00:00:00:00:00:E0&newService&json
6/30/2017 10:35 AM Middleware::Response ERROR: Could not parse data
6/30/2017 10:35 AM Middleware::Response ERROR: Unexpected character encountered while parsing value: E. Path ‘’, line 0, position 0.
6/30/2017 10:35 AM Middleware::Communication URL: http://10.30.19.2/fog/service/getversion.php?clientver&newService&json
6/30/2017 10:35 AM Middleware::Communication URL: http://10.30.19.2/fog/service/getversion.php?newService&json
6/30/2017 10:35 AM Service ERROR: Unable to get cycle data
6/30/2017 10:35 AM Service ERROR: Object reference not set to an instance of an object.
6/30/2017 10:35 AM Middleware::Response Success

[Tom Elliott]

@tyler2017 said in Unable to deploy Snapins - Stuck in Que:

http://10.30.19.2/fog/management/index.php?sub=requestClientInfo&mac=1A:E3:47:B3:65:43|28:E3:47:B3:7C:B3|28:E3:47:B3:65:43|00:09:0F:FE:00:01|A0:1D:48:B0:29:CC||00:00:00:00:00:00:00:E0|00:00:00:00:00:00:00:E0|00:00:00:00:00:00:00:E0&newService&json

Mind running an SQL query on the db with:

USE fog;
SELECT hmHostID,hmMAC FROM hostMAC WHERE hmMAC IN ('1A:E3:47:B3:65:43','28:E3:47:B3:7C:B3','28:E3:47:B3:65:43','00:09:0F:FE:00:01','A0:1D:48:B0:29:CC');

[tyler2017]

@Tom-Elliott Pardon my ignorance, but how would I go about doing that?

[tyler2017]

@Tom-Elliott

Nevermind, I figured it out… I think.

[Tom Elliott]

@tyler2017 So you might add a filter for a0:1d:48:b0:29:cc.

[tyler2017]

@Tom-Elliott How would I go about that? I’m not familiar at all with MySQL.

[tyler2017]

@Tom-Elliott I have been unable to find a way to add a filter or troubleshoot any further. Is there something else I can try? I was really hoping to get snapins to work, it will help me out a ton. Oddly enough, a printer will deploy, but only after the host restarts. Is there any kind of repair I can run on the database?

Thanks for all your help so far Tom. You guys are awesome!

[Tom Elliott]

@tyler2017 FOG Configuration Page->FOG Settings->FOG Client - Host Register->FOG_QUICKREG_PENDING_MAC_FILTER

Add the MAC address there. Save. Try again.

[tyler2017]

@Tom-Elliott I tried adding the mac you suggested, but it had no effect. Tried the other one, and everything lit up. Everything looks good now. Successfully deployed a snapin.

Thanks for the help Tom!

[Tom Elliott]

@tyler2017 Thanks for responding as I don’t know what mac is what, I just took a guess and it was wrong. Thanks for trying the other and glad it helped.