Re: SQL insert in rlm_expr

On Jun 16, 2017, at 4:33 AM, Marius Booysen <tuppe99@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.