How to set multiple reply values via a single SQL query?

Alan DeKok aland at
Tue Mar 3 21:22:46 CET 2015

On Mar 3, 2015, at 3:14 PM, James Wood <james.wood at> wrote:
> Is there any way to set multiple reply items via a single SQL query?

  No.  Arran and I have discussed that.  We have some ideas, but nothing final.

> At the moment, I have a table called “settings” and within that I have a
> number of columns like Session-Timeout. I am having to do multiple SQL
> queries to pull these out, even though they are in the same table, which is
> both introducing time and load on the server

  The the short term you can select 3 fields, and use SQL to concatenate them as strings.  Then, use FreeRADIUS to split the string.

  Ugly, but less load for your SQL server.

  Alan DeKok.

More information about the Freeradius-Users mailing list