Radius missed user logout
Hi, I'm running mysql + radius. Now it happened, that a user is no longer connected, but radius still things he is connected. My NAS vpn server died; probably thats why. What do i have to do make this straight?
I'm not a 100% sure but I remember that DialupAdmin was serving some scripts against that ... you might look into the DialupAdmin folder and look for lib or a folder called like that where some scripts lieing arround. Good luck, Leander S. Sascha Kiefer schrieb:
Hi,
I'm running mysql + radius. Now it happened, that a user is no longer connected, but radius still things he is connected. My NAS vpn server died; probably thats why. What do i have to do make this straight?
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Find and delete the open session(s) in mysql. If you have time on your hands and you know when did the server fail you can create a query that will close them by updating AcctStopTime and AcctSessionTime fields for open sessions. Ivan Kalik Kalik Informatika ISP Dana 17/6/2008, "Sascha Kiefer" <sk@intertivity.com> piše:
Hi,
I'm running mysql + radius. Now it happened, that a user is no longer connected, but radius still things he is connected. My NAS vpn server died; probably thats why. What do i have to do make this straight?
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
How would such an query look like? I'm also very interested in a solution. Leander Ivan Kalik schrieb:
Find and delete the open session(s) in mysql. If you have time on your hands and you know when did the server fail you can create a query that will close them by updating AcctStopTime and AcctSessionTime fields for open sessions.
Ivan Kalik Kalik Informatika ISP
Dana 17/6/2008, "Sascha Kiefer" <sk@intertivity.com> piše:
Hi,
I'm running mysql + radius. Now it happened, that a user is no longer connected, but radius still things he is connected. My NAS vpn server died; probably thats why. What do i have to do make this straight?
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
UPDATE radacct SET AcctStopTime = 'time of breakdown', AcctSessionTime = UNIX_TIMESTAMP('time of breakdown') - UNIX_TIMESTAMP(AcctStartTime) WHERE AcctStopTime = 0 AND AcctStartTime < 'time of breakdown' Just rework accounting_onoff_query form sql.conf. Ivan Kalik Kalik Informatika ISP Dana 17/6/2008, "Leander S." <leander.schaefer@gmx.net> piše:
How would such an query look like? I'm also very interested in a solution.
Leander
Ivan Kalik schrieb:
Find and delete the open session(s) in mysql. If you have time on your hands and you know when did the server fail you can create a query that will close them by updating AcctStopTime and AcctSessionTime fields for open sessions.
Ivan Kalik Kalik Informatika ISP
Dana 17/6/2008, "Sascha Kiefer" <sk@intertivity.com> piše:
Hi,
I'm running mysql + radius. Now it happened, that a user is no longer connected, but radius still things he is connected. My NAS vpn server died; probably thats why. What do i have to do make this straight?
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/usershtml
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (3)
-
Ivan Kalik -
Leander S. -
Sascha Kiefer