accounting_onoff_query and acctsessiontime = 0

[Tuc at T-B-O-H.NET]

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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html