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

[Alan DeKok]

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.