how to have freeradius/unlang do two or more SQL statements at one time

Dave Sinclair jmb287 at gmail.com
Mon Mar 16 01:09:04 CET 2009


Hi,

When Post-Auth-Type REJECT is executed I need to insert two or more
rows into a SQL data base.

here is what I have at present


sites-enabled/default

        Post-Auth-Type REJECT {
                sql
        }

sql.conf -> sql/mysql/dialup.conf


        postauth_query = "INSERT INTO ${authcheck_table} VALUES
(NULL,'%{User-Name}','Password', '==',
'%{User-Password:-Chap-Password}');"
        postauth_query = "INSERT INTO ${usergroup_table} values
('%{User-Name}','Dynamic','');"


The FIRST insert runs, but the second one doesn't.

mucho thanks in advance



More information about the Freeradius-Users mailing list