-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Dave Sinclair wrote:
> Hi,
>
> Their isnt' a backup.....
>
> So I'm having problems with:
>
> 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','');"
>
>
> I want BOTH SQL statements to insert data. At present the first
> INSERT runs, but the second one doesn't. I cant seem to sort out
> how to do in unlang.
>
> help ?? thanks
It's possible in the current GIT stable branch, i.e. you can use
rlm_sql xlat to do insert queries and it'll expand to the number of
rows inserted, or a null string ('') on error. You could also
theoretically wrap the two statements together as a transaction
(depending on what DB you were using).
Arran
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAknFHTsACgkQcaklux5oVKJvvQCcDmVMvdQsFX1uPg95ZsjEjiKH
IasAn1wEDiAPHTi79MNkMTuzGS7hN2pA
=usyd
-----END PGP SIGNATURE-----
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
