accounting_onoff_query and acctsessiontime = 0

Ivan Kalik tnt at kalik.net
Sun May 18 17:25:59 CEST 2008


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




More information about the Freeradius-Users mailing list