Re: Refer to load-balance block in SQL query

27 Oct 2016

      On Oct 27, 2016, at 7:36 AM, Krzysztof Grobelak <krzysztof.grobelak@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.