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@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