Hi,
i'm using freeradius with rlm_sql module, and all work correctly except when Our NAS send multiple accountig stop packets to radius reguarding the same session. This couse problem because AcctStopTime was updated every time a stop packet arrives, and i must save only AcctStopTime sended the first Time. I have tryed to change acct_stop_query adding to WHERE condition this:
accounting_stop_query = "UPDATE ${acct_table} 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}' \
WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}'\
AND NASIPAddress = '%{NAS-IP-Address}' and AcctStopTime = 0"
Adding control for acctstoptime=0, but with this condition all acct-stop packet recived after the first ,execute the accounting_stop_query_alt query, and create on radacct duplicate session (no good).
Any Ideas?
Thanks to all Amy
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
