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
- Re: rlm_sql module. HELP ! Genoud Richard
- Re: rlm_sql module. HELP ! Chris Parker
- Re: rlm_sql module. HELP ! Genoud Richard
