Reversibly encrypted passwords in SQL

2006-10-09 Thread Stefan Winter
Hello, is there any way of using reversibly encrypted passwords together with a mySQL backend? Currently, our passwords are stored as User-Password in clear text. I'd like to move on to using something like Crypt-Password := {algo-prefix}blablabla with an algorithm that encrypts reversibly. I

Re: Reversibly encrypted passwords in SQL

2006-10-09 Thread Jan Mulders
I'd also like to do this - although non-reversable encryption (like MD5) would suit us - eg, password is encrypted in the table, and is encrypted and compared when a user's password is checked. How is encryption meant to be done in the MySQL module at all? Jan On 09/10/06, Stefan Winter [EMAIL

Re: Reversibly encrypted passwords in SQL

2006-10-09 Thread Rob Shepherd
Jan Mulders wrote: I'd also like to do this - although non-reversable encryption (like MD5) would suit us - eg, password is encrypted in the table, and is encrypted and compared when a user's password is checked. How is encryption meant to be done in the MySQL module at all? You could use

Re: Reversibly encrypted passwords in SQL

2006-10-09 Thread Alan DeKok
Stefan Winter [EMAIL PROTECTED] wrote: is there any way of using reversibly encrypted passwords together with a mySQL backend? Not really, no. But it shouldn't be too hard to add... with an algorithm that encrypts reversibly. I failed to see a list of supported algorithms in the docs, a

Re: Reversibly encrypted passwords in SQL

2006-10-09 Thread Alan DeKok
Jan Mulders [EMAIL PROTECTED] wrote: I'd also like to do this - although non-reversable encryption (like MD5) would suit us - eg, password is encrypted in the table, and is encrypted and compared when a user's password is checked. This is already supported in 1.1.x, and is a little easier in