Disconnects for some users do not work, strange errors in the log HSNM administration backend general discussion

[johanjpk]

Hi,

I have some users that can't disconnect from the login-app. At the same time I have strange errors, in the system log:
2019-04-06 18:49:15 host Error! Query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 1' at line 5 (1064) Query: SELECT HsData.HardwareType, HsDomainsData.AuthenticationMode
FROM radacct
INNER JOIN HsData ON HsData.HsDataID = radacct.HsDataID
INNER JOIN HsDomainsData ON HsDomainsData.HsDomainsDataID = HsData.HsDomainsDataID
WHERE radacct.radacctid = LIMIT 0, 1 (/functions/DisconnectUser.php)
DisconnectUser.php is mentioned so I guess this is related.

[HSNMSupport]

Hi Johan
Which HSNM version are you using. I've just tried on our lab but i was not able to reproduce the issue.
So please upgrade your HSNM with the latest version and retry.

If the problem persist please let us know

Thanks

Best regards

[johanjpk]

I've updated to 6.1.59. When a user tries to Log off a device the device is not disconnected.
I've checked the Dyndns address
I've checked that the HSNM can reach the Mikrotik.
I've checked that Mikrotik is reachable by the Dyndns on port 8728.

Don't know what to do now

Best regards.

Johan

[HSNMSupport]

Hi Johan,

now you are talking about disconnection of a device.

Can you provide me more details about steps you have taken?

I think you have registered and connected with a device. Then you have tried to connect with same credentials from a second device and, from the porfile app, you have tried to disconnect the first device. Right?

Please let me know.

Best Regards.

[HSNMSupport]

Hi Johan,
I think we have found the issue...thanks to report it.
Fix will be available on next HSNM ver. 6.1.61.

Thanks again

Best regards

[johanjpk]

Thanks guys!

[johanjpk]

Solved!

[HSNMSupport]

Good!

Best Regards.