>>>>> "SC" == Scott Cottrell <scottrell@stripped> writes:
SC> Problem: With AuthMySQLCryptedPasswords On, the logins fail (error log:
SC> user jim: password mismatch: /test/) for any user in the database. With
SC> AuthMySQLCryptedPasswords Off, the logins fail only for those whose
SC> passwords were stored with the password() function.
CryptedPasswords are those encrypted using your system's crypt()
function from the C library. It does not support the mysql PASSWORD()
SC> The mod_auth_mysql.c code used to build the module says it follows the
SC> "new-style crypt() usage", whatever that means, and there does appear a
SC> crypt() function in the code.
Traditional crypt() uses 2-character "salt", new-style uses 4
(including the iteration count.)
SC> How do I store an encrypted password using this module? Should I switch
SC> to a different module build?
Encrypt the values in your application using the crypt() function.
Perl supports it as well, if you're not using C/C++.
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@stripped Rockville, MD +1-301-545-6996
PGP & MIME spoken here http://www.kciLink.com/home/khera/