Run time variable in sql

[rob-ml at mailbox.org]

Hey,
hmm... the one quotations-info i found in manual/wiki (run_time_variables site) with:
.. you must put the string into an back-quoted string ..

If i put the radgroupreply table value in a double quoted string like:
"%{request:Actual-Data-Rate-Upstream}00"

i receive only a red error line:

(2) sql: ERROR: Error parsing value: Unknown or invalid value "%{request:Actual-Data-Rate-Upstream}00" for attribute Huawei-Input-Average-Rate
(2) sql: ERROR: Error parsing user data from database result
(2) sql: ERROR: Error retrieving reply pairs for group 50m

A back-tick quoted value looks right for me, because it is processed.
But the result string is back-tick quoted too, could it be the problem?



Best wishes,
Rob


> Alan DeKok <aland at deployingradius.com> hat am 26. März 2018 um 14:58 geschrieben:
> 
> 
> On Mar 26, 2018, at 8:05 AM, rob-ml at mailbox.org wrote:
> > now tested, no matter which operator, always with the same result.
> > 
> > Receive:
> > (3)   Actual-Data-Rate-Upstream = 41999
> > (3)   Actual-Data-Rate-Downstream = 109066
> > 
> > Processing in radiusd -X debug:
> > (3) sql: EXPAND `%{request:Actual-Data-Rate-Upstream}00`
> > (3) sql:    --> `4199900`
> > (3) sql: EXPAND `%{request:Actual-Data-Rate-Downstream}00`
> > (3) sql:    --> `10906600`
> 
>   Ah... a careful reading of the debug output helps here.
> 
>   A back-tick quoted string calls a *program*.  e.g. `/bin/echo foo`
> 
>   You probably want to use normal double quotes.
> 
>   Alan DeKok.
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html