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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html