String expansion of attributes value from database

Krzysztof Grobelak krzysztof.grobelak at
Wed Jul 13 17:13:54 CEST 2016

Hello Alan,

Thanks for response.
> On Jul 13, 2016, at 7:29 AM, Krzysztof Grobelak <krzysztof.grobelak at> wrote:
>> I have been testing the below feature and it looks like the server is successfully performing the expansion of the attributes values when the value is enclosed with the “`” as can be seen below:
>  That's not supposed to work.  If it does work, it works by accident, not by design.
Ohhh man… It would be a very cool functionality if it was intended.
But lets say you now know its kind of there will you be looking to remove it or embrace it? ;)

>> The  %{Alc-Client-Hardware-Addr} gets correctly expanded to 84:8f:69:f1:16:0a however the “ `”  are still encapsulating the mac.
>> The Framed-IP-Address somehow gets assigned even though	debug log show the correct expansion and execution of the SQL query.
>  Because the string `` isn't a valid IP address.
I kind of suspected that this may be the case.

>> Can you please advise how to remove the “`” and how to correctly assign the SQL returned value to Framed-IP-Addess attribute?
>  Don't use `` in the SQL database.
>  Use the documented features, even if it means a slightly more complex configuration.  it will work.

Very well, will look for some other approach.

Thanks for great software!


More information about the Freeradius-Users mailing list