Hello Alan, Thanks for response.
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.
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