sql expansion with query string stored in attribute?

Fajar A. Nugraha list at fajar.net
Wed Oct 19 08:50:20 CEST 2011

On Wed, Oct 19, 2011 at 1:45 PM, Alan DeKok <aland at deployingradius.com> wrote:
> Fajar A. Nugraha wrote:
>> Is it possible to use sql expansion with query stored in a radius
>> attribute (e.g. Tmp-String-0)?
>  Not currently.

I was afraid of that :)

>> For example, I have something like this to store my local
>> configuration variables:
>> local-config {
>> sql-now="select concat('Current time = ',now())"
>> }
>  You can use that as a *load-time* expansion, via ${...}.   But it
> means you can't change it at run-time.

Yes, which is what Test2 does, and it works correctly.

>  That's mainly used to abstract configuration on different machines.
>> Is there a way to change which characters remain unencoded? Thanks.
>  That's what "safe_characters" is for.

In dialup.conf? Yes, but it doesn't seem to work when the query is
stored in an attribute. Looks like sql_xlat is responsible for this?



More information about the Freeradius-Users mailing list