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