String expansion of attributes value from database
Krzysztof Grobelak
krzysztof.grobelak at enet.ie
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 enet.ie> 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 0.0.0.0 even though debug log show the correct expansion and execution of the SQL query.
>
> Because the string `1.2.3.4` 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!
Regards,
Kris
More information about the Freeradius-Users
mailing list