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