[Proxy accounting based on SQL]

[Thomas Fagart]

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