HSNM Forum

dears,

we have strange problem when gateway reboot or disconnect for any cause , users in HSNM still and stay connected

and this cause maximum session for the user ,

we update the interim update to 300 , also decrease it in mikrotik , update pppoe network interface , check all setting but still have problem

note : we use external database

see error below

rror! Query error: MySQL server has gone away (2006) Query: SELECT CASE WHEN UpdateExpiration = 1 OR ToDate IS NULL THEN 0 WHEN (ToDate > NOW()) THEN 0 ELSE 1 END AS Expired FROM HsUsersTransactions WHERE HsUsersID = 36126 ORDER BY HsUserTransactionsID DESC LIMIT 0, 1 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT 1, callingstationid FROM radacct WHERE radacct.HsUsersID = 36126 AND radacct.acctterminatecause = '' LIMIT 0, 1 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT HsManagers.HsRetailersID, HsManagers.HsManagersID, HsUsers.LastName, HsUsers.FirstName, HsUsers.UserName, HsUsers.Locked, HsUsers.HsProductID, HsProducts.HsProductsPolicyID, HsUsers.ExternalAuthType, HsUsers.HsUserTransactionsID, HsUsers.CreationDate FROM HsUsers LEFT JOIN HsProducts ON HsProducts.HsProductID = HsUsers.HsProductID INNER JOIN HsDomainsData ON HsDomainsData.HsDomainsDataID = HsUsers.HsDomainsDataID INNER JOIN HsManagers ON HsManagers.HsManagersID = HsDomainsData.HsManagersID WHERE HsUsers.HsUsersID = 36126 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT CASE WHEN UpdateExpiration = 1 OR ToDate IS NULL THEN 0 WHEN (ToDate > NOW()) THEN 0 ELSE 1 END AS Expired FROM HsUsersTransactions WHERE HsUsersID = 36127 ORDER BY HsUserTransactionsID DESC LIMIT 0, 1 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT 1, callingstationid FROM radacct WHERE radacct.HsUsersID = 36127 AND radacct.acctterminatecause = '' LIMIT 0, 1 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT HsManagers.HsRetailersID, HsManagers.HsManagersID, HsUsers.LastName, HsUsers.FirstName, HsUsers.UserName, HsUsers.Locked, HsUsers.HsProductID, HsProducts.HsProductsPolicyID, HsUsers.ExternalAuthType, HsUsers.HsUserTransactionsID, HsUsers.CreationDate FROM HsUsers LEFT JOIN HsProducts ON HsProducts.HsProductID = HsUsers.HsProductID INNER JOIN HsDomainsData ON HsDomainsData.HsDomainsDataID = HsUsers.HsDomainsDataID INNER JOIN HsManagers ON HsManagers.HsManagersID = HsDomainsData.HsManagersID WHERE HsUsers.HsUsersID = 36127 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT CASE WHEN UpdateExpiration = 1 OR ToDate IS NULL THEN 0 WHEN (ToDate > NOW()) THEN 0 ELSE 1 END AS Expired FROM HsUsersTransactions WHERE HsUsersID = 36128 ORDER BY HsUserTransactionsID DESC LIMIT 0, 1 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT 1, callingstationid FROM radacct WHERE radacct.HsUsersID = 36128 AND radacct.acctterminatecause = '' LIMIT 0, 1 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT HsManagers.HsRetailersID, HsManagers.HsManagersID, HsUsers.LastName, HsUsers.FirstName, HsUsers.UserName, HsUsers.Locked, HsUsers.HsProductID, HsProducts.HsProductsPolicyID, HsUsers.ExternalAuthType, HsUsers.HsUserTransactionsID, HsUsers.CreationDate FROM HsUsers LEFT JOIN HsProducts ON HsProducts.HsProductID = HsUsers.HsProductID INNER JOIN HsDomainsData ON HsDomainsData.HsDomainsDataID = HsUsers.HsDomainsDataID INNER JOIN HsManagers ON HsManagers.HsManagersID = HsDomainsData.HsManagersID WHERE HsUsers.HsUsersID = 36128 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT CASE WHEN UpdateExpiration = 1 OR ToDate IS NULL THEN 0 WHEN (ToDate > NOW()) THEN 0 ELSE 1 END AS Expired FROM HsUsersTransactions WHERE HsUsersID = 36129 ORDER BY HsUserTransactionsID DESC LIMIT 0, 1 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT 1, callingstationid FROM radacct WHERE radacct.HsUsersID = 36129 AND radacct.acctterminatecause = '' LIMIT 0, 1 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT HsManagers.HsRetailersID, HsManagers.HsManagersID, HsUsers.LastName, HsUsers.FirstName, HsUsers.UserName, HsUsers.Locked, HsUsers.HsProductID, HsProducts.HsProductsPolicyID, HsUsers.ExternalAuthType, HsUsers.HsUserTransactionsID, HsUsers.CreationDate FROM HsUsers LEFT JOIN HsProducts ON HsProducts.HsProductID = HsUsers.HsProductID INNER JOIN HsDomainsData ON HsDomainsData.HsDomainsDataID = HsUsers.HsDomainsDataID INNER JOIN HsManagers ON HsManagers.HsManagersID = HsDomainsData.HsManagersID WHERE HsUsers.HsUsersID = 36129 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT CASE WHEN UpdateExpiration = 1 OR ToDate IS NULL THEN 0 WHEN (ToDate > NOW()) THEN 0 ELSE 1 END AS Expired FROM HsUsersTransactions WHERE HsUsersID = 36130 ORDER BY HsUserTransactionsID DESC LIMIT 0, 1 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT 1, callingstationid FROM radacct WHERE radacct.HsUsersID = 36130 AND radacct.acctterminatecause = '' LIMIT 0, 1 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT HsManagers.HsRetailersID, HsManagers.HsManagersID, HsUsers.LastName, HsUsers.FirstName, HsUsers.UserName, HsUsers.Locked, HsUsers.HsProductID, HsProducts.HsProductsPolicyID, HsUsers.ExternalAuthType, HsUsers.HsUserTransactionsID, HsUsers.CreationDate FROM HsUsers LEFT JOIN HsProducts ON HsProducts.HsProductID = HsUsers.HsProductID INNER JOIN HsDomainsData ON HsDomainsData.HsDomainsDataID = HsUsers.HsDomainsDataID INNER JOIN HsManagers ON HsManagers.HsManagersID = HsDomainsData.HsManagersID WHERE HsUsers.HsUsersID = 36130 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT CASE WHEN UpdateExpiration = 1 OR ToDate IS NULL THEN 0 WHEN (ToDate > NOW()) THEN 0 ELSE 1 END AS Expired FROM HsUsersTransactions WHERE HsUsersID = 36131 ORDER BY HsUserTransactionsID DESC LIMIT 0, 1 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT 1, callingstationid FROM radacct WHERE radacct.HsUsersID = 36131 AND radacct.acctterminatecause = '' LIMIT 0, 1 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT HsManagers.HsRetailersID, HsManagers.HsManagersID, HsUsers.LastName, HsUsers.FirstName, HsUsers.UserName, HsUsers.Locked, HsUsers.HsProductID, HsProducts.HsProductsPolicyID, HsUsers.ExternalAuthType, HsUsers.HsUserTransactionsID, HsUsers.CreationDate FROM HsUsers LEFT JOIN HsProducts ON HsProducts.HsProductID = HsUsers.HsProductID INNER JOIN HsDomainsData ON HsDomainsData.HsDomainsDataID = HsUsers.HsDomainsDataID INNER JOIN HsManagers ON HsManagers.HsManagersID = HsDomainsData.HsManagersID WHERE HsUsers.HsUsersID = 36131 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT CASE WHEN UpdateExpiration = 1 OR ToDate IS NULL THEN 0 WHEN (ToDate > NOW()) THEN 0 ELSE 1 END AS Expired FROM HsUsersTransactions WHERE HsUsersID = 36132 ORDER BY HsUserTransactionsID DESC LIMIT 0, 1 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT 1, callingstationid FROM radacct WHERE radacct.HsUsersID = 36132 AND radacct.acctterminatecause = '' LIMIT 0, 1 (::functions::users ::db->query)
2021-02-24 14:09:24 admin Error! Query error: MySQL server has gone away (2006) Query: SELECT HsManagers.HsRetailersID, HsManagers.HsManagersID, HsUsers.LastName, HsUsers.FirstName, HsUsers.UserName, HsUsers.Locked, HsUsers.HsProductID, HsProducts.HsProductsPolicyID, HsUsers.ExternalAuthType, HsUsers.HsUserTransactionsID, HsUsers.CreationDate FROM HsUsers LEFT JOIN HsProducts ON HsProducts.HsProductID = HsUsers.HsProductID INNER JOIN HsDomainsData ON HsDomainsData.HsDomainsDataID = HsUsers.HsDomainsDataID INNER JOIN HsManagers ON HsManagers.HsManagersID = HsDomainsData.HsManagersID WHERE HsUsers.HsUsersID = 36132 (::functions::users ::db->query)

Can you please tell us which domain are you referring to in order to check it?

Can you please tell us which domain are you referring to in order to check it?

we use PPPOE domain

if u mean in my systesm its MasterClick under WISP reseller

but in case all PPP domain under WISP reseller has same problem ,, does it because of upgrading to latest version of HSNM

First of all, your DB error (MySQL server has gone away (2006))must be fixed.
Try to define those variables in your my.cnf:

max_allowed_packet=256M
wait_timeout = 28800
interactive_timeout = 28800

After this, we can analyze the HSNM behavior.
Thank you.

First of all, your DB error (MySQL server has gone away (2006))must be fixed.
Try to define those variables in your my.cnf:

max_allowed_packet=256M
wait_timeout = 28800
interactive_timeout = 28800

After this, we can analyze the HSNM behavior.
Thank you.

ok i modify it and restart mysql

So please now check if the problem is still there.

So please now check if the problem is still there.

yes its still appear and i must manually disconnect per each user

how i can disconnect all users under domain or gateway or manager or all , this is most important

So please now check if the problem is still there.

yes its still appear and i must manually disconnect per each user

how i can disconnect all users under domain or gateway or manager or all , this is most important

ANY UPDATEs

Hi,
please note that we do not work on Saturday and Sunday.
There isn't a function to disconnect all users together.
What do you want to accomplish?

Hi,
please note that we do not work on Saturday and Sunday.
There isn't a function to disconnect all users together.
What do you want to accomplish?

we still have problem when users disconnected from mikrotik gateway for any un-normal reason , so after that users are not active in gateway but still active in HSNM

we need to solve this issue and need to know how to prevent and fix it