RE: [vchkpw] CDB --> MySQL Migration Questions
At 16:25 16/06/03, David Choo wrote: >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. I had thought of this too, but doesn't the learn-password option mean that everybody's POP acounts are completely unprotected until each user has logged in? -- Lou Hevly Manresa, Catalonia http://visca.com
RE: [vchkpw] CDB --> MySQL Migration Questions
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 2000 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
Re: [vchkpw] CDB --> MySQL Migration Questions
At 16:21 15/06/03, David Choo wrote: 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. 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? I asked a question similar to this recently and was told that, no, vconvert can't read the password encryption method for vpopmail 4.9.10. If you know your users' passwords you could write a script to first do `vpasswd user passwd`, then run vconvert. AFAIK there is no way to get vpopmail 4.9.10 passwords into clear text for conversion. I would love to be proved wrong, however. -- Lou Hevly Manresa, Catalonia http://visca.com
[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 2000 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
