Hello,
i have a little problem with storing the accounting informations into the mysql
database. My device send informations to the radius, which are stored in the raddacct
table, fine. Now i would like to update a value in another table. I wrote an SQL query
to do this, work fine, too. But i need both entrys. Does anyone knows how i can create
2 querys??
Here are the 2 rows from the 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}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName =
'%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}'"
accounting_stop_query = "UPDATE radreply SET Value = Value - `%{Acct-Session-Time}'
WHERE UserName = '%{SQL-User-Name}' "
Both accounting_stop_querys are working fine, but i need both at the same time!
Thank you in advance
Mit freundlichen Gr��en
Best regards
Markus Roettgen
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
