Solved Snapin queued forever

[renanserrou]

Hello Im using debian as a server with version 1.5.7 and client 0.11.16, we were using it for about 6 months and its was working fine, but suddenly the snapins stoped working, it just stay in queue status and never starts. I tryed to reset data encryption and delete Token.dat from a few computers but its still not working…

[renanserrou]

@Sebastian-Roth There were still some duplicated MACs on my network removed then from the database and it worked, this issue was caused by myself, there were some pending macs to aprove and I didn’t paid attention to then and approved then all, but lots of them were from Virtual machines.

[Sebastian Roth]

@renanserrou What exactly did you do? Please let us know as other people will find it helpful too.

[renanserrou]

@Sebastian-Roth Thx a lot, it worked!

[Sebastian Roth]

@renanserrou Looking at the client log again… I See these MAC addresses:

02:00:4C:4F:4F:50|38:EA:A7:19:19:AF|0A:00:27:00:00:12||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

One seems empty (||) and I see a couple of what are probably virtual network adapters.

[renanserrou]

@Sebastian-Roth Hello, thx for replying, I removed some MACs using web interface, but im not sure if i checkd the database the right way.

 mysql -D fog
MariaDB [fog]> SELECT hmHostID FROM hostMAC where hmMAC IN ('b8:70:f4:c3:4d:7f','e0:ca:94:1e:3a:7e','b4:74:9f:96:6a:e7');
Empty set (0.00 sec)

Got this result, but im still getting the same error:

[Thu Dec 12 17:05:59.208393 2019] [proxy_fcgi:error] [pid 802] [client 10.2.32.179:51301] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Exception: Error multiple hosts returned for list of mac addresses in /var/www/fog/lib/fog/hostmanager.class.php:209\nStack trace:\n#0 /var/www/fog/lib/fog/fogbase.class.php(571): HostManager->getHostByMacAddresses(Array)\n#1 /var/www/fog/lib/client/registerclient.class.php(46): FOGBase::getHostItem(true, false, false, true)\n#2 /var/www/fog/lib/fog/fogpage.class.php(3013): RegisterClient->json()\n#3 /var/www/fog/lib/fog/fogpage.class.php(249): FOGPage->requestClientInfo()\n#4 /var/www/fog/lib/pages/dashboardpage.class.php(76): FOGPage->__construct('Dashboard')\n#5 /var/www/fog/lib/fog/loadglobals.class.php(67): DashboardPage->__construct()\n#6 /var/www/fog/lib/fog/loadglobals.class.php(81): LoadGlobals::_init()\n#7 /var/www/fog/commons/base.inc.php(49): LoadGlobals->__construct()\n#8 /var/www/fog/management/index.php(22): require('/var/www/fog/co...')\n#9 {main}\n  thrown in /var/www/fog/lib/fog/hostmanager.class.php on line 209\n'

Theres something else I should do?

[Sebastian Roth]

@renanserrou In the error log posted we see:

Error multiple hosts returned for list of mac addresses

You seem to have different hosts using the same MAC address (usually one as primary MAC and others as additional MACs). See here on how to find those in the database: https://forums.fogproject.org/topic/8448/response-error-multiple-hosts-returned-for-list-of-mac-addresses

[renanserrou]

@Daniel-Miller Its not showing in logviewer, but got then directly from the server, the apache section say its “Unable to open file for reading”, not sure if its related to the main problem. Thx for the help.

php7.0-fpm.log
error.log

[Daniel Miller]

@renanserrou Seem to be a number of http error 500 reported in the log. Can you post the apache error and php-fpm logs from the fog server as well?

[renanserrou]

This is from a single machine, but none of then are working.
fog.log

[Sebastian Roth]

@renanserrou Please upload the full client log (C:\fog.log or C:\Program Files (x86)\FOG\fog.log) here.