accounting_onoff_query and acctsessiontime = 0

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

Hi Ivan,

	Ok, thanks. I like the one that does for all packets, so I've
made that change.

	The other thing I'm finding is that the statement isn't getting
all the records anyway. I went into phpMyAdmin and tried to cut/paste
from sqltrace.sql, and no records were updated. I went into phpMyAdmin
and entered the (now) 3 search fields, and no records. It wasn't until
I change "acctstoptime      =  NULL" to "acctstoptime      IS  NULL"
did it find the records. (I'm running the 5.0.45-community-log from
RPM). I've changed my accounting_onoff_query to be the "IS". Should 
FR as distributed be changed, or "IS" ( ;) ) there a problem with 
my server?

		Thanks, Tuc

> 
> Yes. This query doesn't update sessions that have recieved accounting
> update packets but are left open when NAS rebooted. Query in 2.0.4 does
> it for those packets as well.
> 
> Ivan Kalik
> Kalik Informatika ISP
> 
> 
> Dana 18/5/2008, "Tuc at T-B-O-H.NET" <ml at t-b-o-h.net> pi¹e:
> 
> >>
> >> 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
> >
> >
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> 
>