Re: about accounting_stop_query ...

[Chris Parker]

At 05:04 PM 10/17/2002 +0400, Do-Risika RAFIEFERANTSIARONJY wrote:

Hi everybody,

It is just an optimization question, for those who use rlm_sql.

I has the query below in my sql.conf :

accounting_stop_query = "UPDATE ${acct_table1} SET AcctStopTime = '%S', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}', AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay = '%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}', AcctMultiSessionId = '%{Acct-Multi-Session-Id}', AscendDataRate = '%{X-Ascend-Data-Rate}', AscendXmitRate = '%{X-Ascend-Xmit-Rate}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}'"

With our nas (patton boxes), the SessionId values are reinitialized when the box reboot, so I think there is a risk of having the same SessionId, Username and NASIPAddress after each reboot, which would alter the accounting data.

This is done by most NAS. This is why the 'acct_unique' module exists.

Please read 'radiusd/doc/rlm_acct_unique'.

-Chris
--
\\\|||/// \ StarNet Inc. \ Chris Parker
\ ~ ~ / \ WX *is* Wireless! \ Director, Engineering
| @ @ | \ http://www.starnetwx.net \ (847) 963-0116
oOo---(_)---oOo--\------------------------------------------------------
\ Wholesale Internet Services - http://www.megapop.net



- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html