Multiple post-auth queries

Arran Cudbard-Bell a.cudbardb at freeradius.org
Thu Feb 15 10:43:31 CET 2018



> On Feb 14, 2018, at 5:14 PM, Alan DeKok <aland at deployingradius.com> wrote:
> 
> On Feb 14, 2018, at 12:00 PM, Gianluca Laudano <laudanog at vdagroup.com> wrote:
>> 
>> Hello, I'm running freeradius 3.0.12 on Debian Stretch amd64 + mysql 5.6
>> 
>> I'm trying to execute multiple queries at post-auth with a configuration like this:
>> 
>> query= "statement 1; statement 2; statement 3"
> 
>  That doesn't really work.  If you want multiple things updated, write a stored procedure.

Yeah... weird.  We don't do anything to prevent that, we just pass the query string through to MySQL.

You might need to wrap the whole lot in a transaction? Or as Alan says use a stored procedure.

-Arran
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 874 bytes
Desc: Message signed with OpenPGP
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20180215/58801bfa/attachment.sig>


More information about the Freeradius-Users mailing list