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: <http://www.wanbound.com/> 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 <mailto:duanec@illicom.net> 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
