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

Dave Sinclair wrote:

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.

The module runs only one query: the first one. If you need to run more queries, for now, use the Perl module. Arran has a patch pending that will allow inserts directly via unlang. Very nice, and it would make your requirement nearly trivial to meet. Alan DeKok.