On Jul 13, 2016, at 7:29 AM, Krzysztof Grobelak <krzysztof.grobelak@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.
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.
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. Alan DeKok.