new table and query

Alan DeKok aland at deployingradius.com
Thu Aug 31 14:09:04 CEST 2017


On Aug 31, 2017, at 8:07 AM, Johansson, Daniel (GIS) <Daniel.Johansson2 at sony.com> wrote:
> I do this now and it works fine.
> 
> post-auth {
>        sql
>        %{sql:INSERT INTO authorizedmacs (macaddress) VALUES ('%{Calling-Station-Id}')}
> }

  That's good.

> Maybe there could be a sql.runMyFunction ?

  That's what the %{sql:...} syntax does.

  The normal use-case is that the parameters to the insert are dynamically expanded.  So any new syntax has to allow for that.

  It's easier to use existing syntax.

  Alan DeKok.




More information about the Freeradius-Users mailing list