Run time variable in sql

Alan DeKok aland at deployingradius.com
Mon Mar 26 13:30:54 CEST 2018


On Mar 26, 2018, at 4:32 AM, rob-ml at mailbox.org wrote:
> after problems in an older version I changed to the newest one (3.0.16).
> Now the attributes are processed but not delivered correctly.
> 
> I want to process %{Actual-Data-Rate-Downstream} and set it as attribute Huawei-Output-Average-Rate.

  OK...

> 
> +-----------+----------------------------+----+------------------------------------------+
> | groupname | attribute | op | value |
> +-----------+----------------------------+----+------------------------------------------+
> | 50m | Huawei-Input-Average-Rate | = | `%{request:Actual-Data-Rate-Upstream}00` |
> | 50m | Huawei-Output-Average-Rate | = | `%{request:Actual-Data-Rate-Downstream}00` |
> +-----------+----------------------------+----+------------------------------------------+

  Which sets Huawei-Input-Average-Rate, but only if it isn't already set.  If you want to force it to that value, use ":=".

  See the rlm_sql documentation for more details on the difference between "=" and ":=".

  Alan DeKok.




More information about the Freeradius-Users mailing list