Rlm_sql: dynamic queries

Dan-Cristian Bogos danb.lists at googlemail.com
Tue Mar 2 18:36:00 CET 2010


Many thanks for the reply, I was expecting something like this but
wanted to make sure that I do not reinvent the wheel.

Have a good one!

> Date: Tue, 02 Mar 2010 16:24:57 +0100
> From: Alan DeKok <aland at deployingradius.com>
> Subject: Re: Rlm_sql: dynamic queries
> To: FreeRadius users mailing list
>        <freeradius-users at lists.freeradius.org>
> Message-ID: <4B8D2DC9.6020609 at deployingradius.com>
> Content-Type: text/plain; charset=ISO-8859-1
> Dan-Cristian Bogos wrote:
>> I receive accounting records with more attributes with the same name
>> (resulting into freeradius in attribute lists).
>> I would like to run mysql multiple inserts in one query (possible with
>> mysql by enumerating values between brackets, eg: insert into table
>> (a, b) values (user-name[0], destination), (username[1], destination),
>> (username[2], destination). ).
>  Perl.
>  i.e. The server doesn't include a generic programming language.  There
> are already too many of them.
>> Can anyone recommend me any better way of doing it (so I do not need
>> to define a query for a number of attributes, but have the query
>> generated in some automatic way, so I will only need one sql
>> instance)?
>  rlm_perl, and run a script.
>  Alan DeKok.

More information about the Freeradius-Users mailing list