Many thanks, we took Option 1 which is the most "embedded one" :-). It works great, I didn't know we could change sql module use in another part of the AAA process. Thomas On 20.04.2012 13:21, Phil Mayers wrote:
On 20/04/12 11:39, Thomas Fagart wrote:
When we use SQL module, in accounting part, it does insert accounting information into the SQL, but does not request information from the database. I know that I could change this SQL request in sql.conf (eg SELECT instead of INSERT), but will it work ?
No. rlm_sql will not perform the radcheck/radreply processing by default for accounting.
Two options:
1. Force use of the "authorize" processing path in your accounting section:
accounting { ... sql.authorize ... }
2. Use SQL xlat to perform your query:
accounting { ... update control { Tmp-String-0 := "%{sql: query goes here}" } if (control:Tmp-String-0) { ... some conditional processing? } ... } - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html