accounting_onoff_query and acctsessiontime = 0

Tuc at T-B-O-H.NET ml at t-b-o-h.net
Sun May 18 17:04:02 CEST 2008


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



More information about the Freeradius-Users mailing list