Radius missed user logout

[Ivan Kalik]

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 at 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 at 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
>
>