Dear All, Thanks to the prompting of Wouter Prins, I figured out how to do the conversion. This is just a simple HOWTO on how to upgrade from CDB to MySQL.
Firstly, upgrade to Vpopmail 5.2.1. Compile with the learn-password option and let it run for a week / two. By then, your system should have authenticated all your users, and you can run vconvert -c -m. Bingo, everything works fine. Regards, David Choo -----Original Message----- From: Wouter Prins [mailto:[EMAIL PROTECTED] Sent: Sunday, June 15, 2003 11:53 PM To: 'David Choo'; [EMAIL PROTECTED] Subject: RE: [vchkpw] CDB --> MySQL Migration Questions Compile vpopmail to LEARN the pop3 passwords, the first time your clients authenticate the mysql database will have the passwords.. -----Original Message----- From: David Choo [mailto:[EMAIL PROTECTED] Sent: Sunday, June 15, 2003 4:21 PM To: [EMAIL PROTECTED] Subject: [vchkpw] CDB --> MySQL Migration Questions Dear All, I'm currently running Qmail 1.03 + Vpopmail 4.9.10 + Courier IMAP 1.3.81 + qmailadmin 0.45 + Sqwebmail 2.0 Combo with CDB authentication. The following are my Vpopmail's config.h PS_COMMAND "ps ax" ENABLE_PASSWD 1 HAS_SHADOW 1 TCP_FILE "/etc/tcp.smtp" ADMIN "[EMAIL PROTECTED]" USE_CDB 1 SQWEBMAIL_PASS 1 SITE_SIZE 0 LOG_NAME "vpopmail" HARD_QUOTA 20000000 VPOPUSER "vpopmail" VPOPGROUP "vchkpw" APOP 1 APOP_FILE "/etc/apop-secrets" QMAILDIR "/var/qmail" VPOPMAILDIR "/var/vpopmail" VPOPMAILUID 512 VPOPMAILGID 507 POP_AUTH_OPEN_RELAY 1 OPEN_SMTP_CUR_FILE "/var/vpopmail/etc/open-smtp" OPEN_SMTP_TMP_FILE "/var/vpopmail/etc/open-smtp.tmp" OPEN_SMTP_LOK_FILE "/var/vpopmail/etc/open-smtp.lock" TCPRULES_PROG "/usr/local/bin/tcprules" DEFAULT_DOMAIN "mydomain.com" Recently, I installed Horde + IMP + Sork. Sork allows users to change their Vpopmail passwords inside IMP. However, one of the requisites is that Vpopmail must be compiled to use MySQL instead of CDB files. Since I'm using CDB files, I must convert. I setup a test machine with vpopmail-5.2.1 using CDB authentication in office and tried to upgrade. I did the following steps in an attempt to convert. [EMAIL PROTECTED] vpopmail-5.2.1]$ make clean [EMAIL PROTECTED] vpopmail-5.2.1]$ ./configure (with orig options) + --with-mysql=y [EMAIL PROTECTED] vpopmail-5.2.1]$ make [EMAIL PROTECTED] vpopmail-5.2.1]$ make install-strip [EMAIL PROTECTED] vpopmail-5.2.1]$ vconvert -c -m It tells me done for everything. However, when I tried to login using POP3 access, my password was wrong. Only when I changed the user account's password then did the login work. Somehow, I feel that the vconvert program does not convert encrypted passwords correctly, or totally do not convert at all. As such, I would like to ask if there is anyway to convert encrypted passwords from CDB - MySQL? Otherwise, can anyone suggest any good way for me to integrate any password changing mechanism into Horde + IMP? Regards, David Choo
