Hi Everyone;
Thought I'd throw together some instructions for upgrading a site using
mysql auth from 4.9.10 to 5.0.0 with clear text password support. I've
used these instructions a couple times now, but they are strictly "Works
For Me-ware" (TM) I hope others find these instructions of use as well.
BEFORE installing vpopmail 5:
Login to mysql
use vpopmail;
ALTER TABLE table_name ADD COLUMN pw_clear_passwd VARCHAR(255);
- table_name is either vpopmail (for small mysql setup) or it's
the name of the domain as shown via the "show table;" command
Compile vpopmail 5.0:
- Ensure you compile with the --enable-learn-passwords=y and
--enable-clear-passwd=y
- do your make
- backup ~vpopmail/bin to ~vpopmail/bin.old (just incase)
After the compile is done, test authentication to make sure you can still
login. If that works then:
Login to mysql again and run:
UPDATE table_name SET pw_passwd="", pw_clear_passwd="";
- table_name is either vpopmail (for small mysql setup) or it's
the name of the domain as shown via the "show table;" command
And now authenticate again and verify that it has now learned your
password. You should see a value in both the pw_passwd and
pw_clear_passwd.
I hope this helps.
Regards,
Tren.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- Tren Blackburn - Owner mailto:[EMAIL PROTECTED] =
= EOT Networks http://www.eotnetworks.com -
- Infinite Solutions for a Finite World (403) 818-7658 =
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
