accounting_onoff_query with empty acctterminatecause

Lorenzo Milesi maxxer at ufficyo.com
Wed Apr 30 15:55:16 CEST 2014


Hi.
I was investigating my DB for some session being marked as terminated while still active and I believe I found the culprit in the accounting_onoff_query query. While this issue is probably related to NAS (Coova) configuration being incompatible with the query itself (NAS-IP-Address is almost always the same), the sessions terminated by this query all have a blank terminate cause.
Is this expected?

Thanks

P.S. The query is the default one:
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 acctstoptime IS NULL \
          AND nasipaddress      =  '%{NAS-IP-Address}' \
          AND acctstarttime     <= '%S'" 
-- 
Lorenzo Milesi - lorenzo.milesi at yetopen.it

YetOpen S.r.l. - http://www.yetopen.it/



More information about the Freeradius-Users mailing list