trying to use Post-Auth-Type REJECT to insert users

Arran Cudbard-Bell a.cudbard-bell at sussex.ac.uk
Sat Mar 21 18:00:43 CET 2009


-----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-----




More information about the Freeradius-Users mailing list