Refer to load-balance block in SQL query

[Krzysztof Grobelak]

Thanks Alan!

All working.

Regards,
Krzysztof


> On 27 Oct 2016, at 13:10, Alan DeKok <aland at deployingradius.com> wrote:
> 
> On Oct 27, 2016, at 7:36 AM, Krzysztof Grobelak <krzysztof.grobelak at enet.ie> wrote:
>> Can something like the below be done in freeRadius:
>> 
>> redundant-load-balance rlb {
>> 	sql1
>> 	sql2
>> }
>> 
>> %{rlb:SELECT …'}
> 
>  Yes.  See raddb/radiusd.conf.  Look for the "instantiate" section.
> 
>> and also how to tell sqlippool module to use the load balanced sql definition.
>> 	
>> sqlippool {
>> 
>>       sql_module_instance = “rlb”
>> }
> 
>  That's impossible, for a host of reasons.
> 
>> If not then how to execute a SQL query agains an sql instance that may be offline?
> 
>  You don't.  You configure two SQL modules and two sqlippool modules.  Then, do fail-over for both:
> 
> 	redundant-load-balance {
> 		sqlippool1
> 		sqlippool2
> 	}
> 
>  Alan DeKok.
> 
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html