Hi,
I know how to authenticate against encrypted passwords, and i can get this mod working fine. I just don't know how to get the encrypted passwords into my DB to start with.
a pointer to where to start would be appreciated.
Drew
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You're question is somewhat broad, so I'll try to answer it briefly and point you in the right direction. I hope it answers your question; if not, could you please be a little more specific where your problem is?
It depends on which encryption method you wish to use. MySQL has functions for all the encryption mechanisms; see the MySQL reference manual Chapter 12.8.2 in the latest doc for descriptions of these function.
Alternatively, you can encrypt it in C, PHP or similar language; depending on which language you use not all methods will be available.
You then either INSERT a new row or UPDATE an existing row with the encrypted password. Again, see the MySQL manual for information on these statements.
Jerry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I know how to authenticate against encrypted passwords, and i can get this mod working fine. I just don't know how to get the encrypted passwords into my DB to start with.
a pointer to where to start would be appreciated.
Drew
Hi,
if you are using php you could convert the plaintext passwords with the md5 funktion into a md5 hash-string ...
"http://de.php.net/md5"
i have a simple varchar(32) field in my table where the hash-string ist stored.
in the httpd.conf i use
AuthMySQLPwEncryption md5
works fine.
greetings
Hi, Drew,
You're question is somewhat broad, so I'll try to answer it briefly and point you in the right direction. I hope it answers your question; if not, could you please be a little more specific where your problem is?
It depends on which encryption method you wish to use. MySQL has functions for all the encryption mechanisms; see the MySQL reference manual Chapter 12.8.2 in the latest doc for descriptions of these function.
Alternatively, you can encrypt it in C, PHP or similar language; depending on which language you use not all methods will be available.
You then either INSERT a new row or UPDATE an existing row with the encrypted password. Again, see the MySQL manual for information on these statements.
Jerry