RE: [vchkpw] CDB -- MySQL Migration Questions

2003-06-17 Thread David Choo
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

2003-06-17 Thread Lou Hevly
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

2003-06-15 Thread Lou Hevly
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