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