[rt-users] Getting an E-Mail Address when using mod_auth_mysql

Mike Peachey mike.peachey at jennic.com
Mon Jan 28 11:57:02 EST 2008

My users are stored in an external MySQL database.

I wanted to do direct authentication against that MySQL database with an 
RT custom authentication module, but it seems that none exist for MySQL 
and there is no way to point RT at a different table to its own for 
authentication that I can see.

So, with a heavy heart, I am settling on using mod_auth_mysql for 
authentication, but the problem is that there is no way I can see for 
mod_auth_mysql to pass e-mail addresses into RT.

What this means is that, short of recoding and re-compiling a custom 
mod_auth_mysql, I have to find a place to insert code just after 
WebExternalAuth has picked up the username and password from apache and 
then perform a manual lookup direct to the u/p database to pick up the 
e-mail address that goes with the user that was just authenticated so 
that when the user is created, it is created with a valid e-mail 
address. But I do not know how.

ALTERNATIVELY -- if _/*ANYONE*/_ can aid in the development of a custom 
MySQL authentication module that can read in u/p/e from a mysql table 
and perform direct auth on it, it would completely solve all my problems.
Kind Regards,


Mike Peachey, IT
Tel: +44 114 281 2655
Fax: +44 114 281 2951
Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK
Comp Reg No: 3191371 - Registered In England

More information about the rt-users mailing list