[RADIATOR] crypt password to check against encrypted password stored in MySql

[Jeffrey Lee]

Hi, how do you perform a crypt (one-way hash) on a password to check
against an encrypted password stored in MySql?

I have a <AuthBy SQL>

AuthSelect call sp_GetUserPassword('%{User-Name}')
AuthColumnDef 0, User-Password, check

The stored procedure (MySql routine) will return the encrypted password,
but since the password sent to Radiator is in clear-text, the
authentication request will be rejected.

I'll need the clear-text password sent to radiator to be first encrypted
(similar to PHP's crypt with salt) before comparing against database.

Does anyone have a solution to this?


Thanks,
Jeff
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.open.com.au/pipermail/radiator/attachments/20130830/61f183ff/attachment.html