accounting_onoff_query and acctsessiontime = 0

[Ivan Kalik]

Yes. This query doesn't update sessions that have recieved accounting
update packets but are left open when NAS rebooted. Query in 2.0.4 does
it for those packets as well.

Ivan Kalik
Kalik Informatika ISP


Dana 18/5/2008, "Tuc at T-B-O-H.NET" <ml at t-b-o-h.net> piše:

>>
>> Hi,
>>
>> 	For the following :
>>
>>         accounting_onoff_query = "\
>>           UPDATE ${acct_table1} \
>>           SET \
>>              acctstoptime       =  '%S', \
>>              acctsessiontime    =  unix_timestamp('%S') - \
>>                                    unix_timestamp(acctstarttime), \
>>              acctterminatecause =  '%{Acct-Terminate-Cause}', \
>>              acctstopdelay      =  %{%{Acct-Delay-Time}:-0} \
>>           WHERE acctsessiontime =  0 \
>>           AND acctstoptime      =  NULL \
>>           AND nasipaddress      =  '%{NAS-IP-Address}' \
>>           AND acctstarttime     <= '%S'"
>>
>>
>> 	Why is "acctsessiontime =  0" ? If the unit has been rebooted,
>> the sessions left hanging, why do you search only for zero'd
>> acctsessiontime?
>>
>> 		Thanks, Tuc
>Hi,
>
>	This changed between 2.0.3 and 2.0.4, didn't it?
>
>		Thanks, Tuc
>-
>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>