Refer to load-balance block in SQL query

[Alan DeKok]

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.