String expansion of attributes value from database

[Alan DeKok]

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.

> 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.