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