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" <[EMAIL PROTECTED]> 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 > >
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html