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