accounting_onoff_query and acctsessiontime = 0

Tuc at T-B-O-H.NET ml at t-b-o-h.net
Sun May 18 16:48:47 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



More information about the Freeradius-Users mailing list