Dear All,

I have a table like this, please do attentiion on password field

+----------+------------------+------------------------+------------------------+
| username | password | prefix | domain_name |
+----------+------------------+------------------------+------------------------+
| cyrus | 747fc82325405198 | | |
+----------+------------------+------------------------+------------------------+

As you see, password field is using OLD_PASSWORD format.

This table is consist of millions of email users that commonly authenticated using Cyrus-SASL (saslauthd) with pam_mysql
support

WHen i upgrade to MySQL 5.0.18, i found a problem.... all user can't log in

I try to see the code inside pam_mysql (Pam_Mysql Version 0.4.5)

I found this problem on pam_mysql.c

   573                 /* PASSWORD */
574 case 2: make_scrambled_password(encryptedPass, passwd);
   575                         break;
   576

As you know make_scrambled_password() is C API which working like PASSWORD() function in MySQL..... However i saved all user password with OLD_PASSWORD() or actually PASSWORD() function on older MySQL version

Hmm.... anybody know? What function C-API that work as OLD_PASSWORD()? or any tricks?

Thx





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

Reply via email to