accounting_onoff_query and acctsessiontime = 0

[Ivan Kalik]

I am still using the old schema (with AcctStopTime = 0 and usergroup, not
radusergroup) but correct mysql syntax would be IS NULL.

http://dev.mysql.com/doc/refman/5.0/en/working-with-null.html

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