PPP users stay connected while it disconnect from Gateway
Topics about the wireless hardware

Rate this topic
   Post Reply
36 posts
miami1983
Posts: 81
Joined: 17 Apr 2019, 09:08

PPP users stay connected while it disconnect from Gateway

by miami1983 » 25 Feb 2021, 08:25

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)

HSNMSupport
Posts: 1529
Joined: 26 Jul 2016, 09:16

Re: PPP users stay connected while it disconnect from Gateway

by HSNMSupport » 25 Feb 2021, 09:09

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

miami1983
Posts: 81
Joined: 17 Apr 2019, 09:08

Re: PPP users stay connected while it disconnect from Gateway

by miami1983 » 25 Feb 2021, 09:41

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

HSNMSupport
Posts: 1529
Joined: 26 Jul 2016, 09:16

Re: PPP users stay connected while it disconnect from Gateway

by HSNMSupport » 25 Feb 2021, 11:07

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.

miami1983
Posts: 81
Joined: 17 Apr 2019, 09:08

Re: PPP users stay connected while it disconnect from Gateway

by miami1983 » 25 Feb 2021, 14:56

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

HSNMSupport
Posts: 1529
Joined: 26 Jul 2016, 09:16

Re: PPP users stay connected while it disconnect from Gateway

by HSNMSupport » 25 Feb 2021, 17:30

So please now check if the problem is still there.

miami1983
Posts: 81
Joined: 17 Apr 2019, 09:08

Re: PPP users stay connected while it disconnect from Gateway

by miami1983 » 28 Feb 2021, 10:47

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

miami1983
Posts: 81
Joined: 17 Apr 2019, 09:08

Re: PPP users stay connected while it disconnect from Gateway

by miami1983 » 01 Mar 2021, 07:59

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

HSNMSupport
Posts: 1529
Joined: 26 Jul 2016, 09:16

Re: PPP users stay connected while it disconnect from Gateway

by HSNMSupport » 01 Mar 2021, 10:42

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?

miami1983
Posts: 81
Joined: 17 Apr 2019, 09:08

Re: PPP users stay connected while it disconnect from Gateway

by miami1983 » 01 Mar 2021, 11:29

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

Rate this topic

Who is online

Users browsing this forum: No registered users and 9 guests