accounting_onoff_query and acctsessiontime = 0
Tuc at T-B-O-H.NET
ml at t-b-o-h.net
Sun May 18 17:53:28 CEST 2008
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
>
>
More information about the Freeradius-Users
mailing list