hi !
I'm using freeradius 0.8.1 with mysql-3.23.49-3.
It' s working ok, with authentication and accounting.
but i'd like to add a SQL request in the sql.conf file ( accounting_stop_query )
the original query is :
accounting_stop_query = "UPDATE ${acct_table2} 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"

and i'd like to add :
UPDATE ${authreply_table} SET Value='%{Session-Timeout}' WHERE Username='%{SQL-User-Name}' AND Attribute='Session-Timeout'

in the same accounting_stop_query.. .is it possible ?

I tried to put a simple ";" between the 2 requests, but it doesn't work.
does anyone got a clue ?

regards.

-------------------------------------------------------------------
CYBERDECK
Solutions de bornes interactives - Kiosk solutions
-------------------------------------------------------------------
Richard Genoud
Ingenieur R&D
-------------------------------------------------------------------
300 route nationale 6 - 69760 Limonest - France
Tel. : 0820 820 107 - International +33 4 78 66 74 00
Fax : +33 4 78 66 74 69
[EMAIL PROTECTED] - www.cyberdeck.com
-------------------------------------------------------------------


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

Reply via email to