Hi Duane

If you use a DB backend that supports stored procedures (like mysql 5) you can make a procedure in your mysql server containing several queries.

You can even use IF THEN ELSE structures, and call that procedure from post-auth as a single query.

like : postauth_query = "call postauth1('%{SQL-User-Name}');"

this calls the stored procedure postauth1 and gives the sql user name as parameter for the procedure to work with.

Maybe that solves your problem :)

Good luck!

Jurgen van Vliet

WANBound Technologies | Veldzigt 28 | 3454 PW De Meern | The Netherlands

Tel: +31 30 66 61 940 | Fax: +31 30 66 64 339 | Email: jvanvliet@wanbound.com | Website: www.wanbound.com

Van: freeradius-users-bounces+jurgen=wanbound.com@lists.freeradius.org [mailto:freeradius-users-bounces+jurgen=wanbound.com@lists.freeradius.org] Namens Duane Cox
Verzonden: donderdag 13 juli 2006 16:32
Aan: FreeRadius users mailing list
Onderwerp: Re: multiple post-auth sql queries, possible?

Is it possible to run a module twice in one section...

meaning can I run the sql module twice in the post-auth section ?

I am thinking I could, but I would have to call it by a new name and then copy the lib files to also this new name.

Thanks

Duane Cox

----- Original Message -----

From: Duane Cox

To: freeradius-users@lists.freeradius.org

Sent: Wednesday, July 12, 2006 4:24 PM

Subject: multiple post-auth sql queries, possible?

Hello List

Is there a way to have freeradius 1.1.1 send two or more sql postauth queries?

I tried to put together an update statement and an insert statement with a "go" command, but mssql didn't like it because the insert, go, update was all on the same "line"

executing the above statement; but broken out on three lines with "go" by itself, works, but I'm not sure if I can do this in freeradius.

So is it possible to have freeradius process sql1 and then sql2 in the post-auth section, if so what would be the best way to set this up.

here is my current config ...

post-auth {
         sql

        Post-Auth-Type REJECT {
                sql
        }
}

and then mssql.conf contains one postauth_query

Thanks

Duane Cox

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html