4.1 password problem

[Lowell Allen]

I have a PHP application that stores member-access passwords in a char 
column. When the passwords were stored, they were written to the 
database using the PASSWORD() function. Each hashed password is 16 
characters long. When a member logs in, the plain text password 
submitted is run through the PASSWORD() function and compared to the 
stored hash. After MySQL was upgraded to 4.1.11, the PASSWORD() function 
now creates a 41 character hash, which of course doesn't match the 16 
character hash. I understand it's possible to restart the MySQL server 
with the --old-passwords option so that PASSWORD() will create the old 
style short hash, but I'm looking for a way to convert the short hash 
values into comparable long hash values. (I don't want to ask 1200+ 
registered users to reset their passwords.) Apparently the upgrade 
procedure can successfully convert short-to-long hash values for MySQL 
user passwords ("user" in the sense of a MySQL user accessing the 
database itself), so surely there's a way to convert short hashed values 
to long hashed values for use within a PHP application. Any practical 
advice greatly appreciated.

--
Lowell Allen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]