SQL insert in rlm_expr

[Alan DeKok]

On Jun 16, 2017, at 4:33 AM, Marius Booysen <tuppe99 at gmail.com> wrote:
> I am using version 3.0.14 and I know you can use the sql module in rlm_expr
> e.g
> %{sql:SELECT.....WHERE...}
> 
> Now I am wondering if this is limited to select statements only or can I
> insert a row into a custom table like this:
> 
> %{sql:INSERT INTO mytab (id) values (100)}

  You should be able to INSERT using xlat. 

> I tried this in a policy and the policy executes fine (debugging shows that
> it is executing the insert) and returns ok, but the mytab table stays empty.

  Post the debug output here.

> Am I doing something wrong or is it just not supported?

  It's supported.

  Alan DeKok.