Hello, I am new to this list but not new to qmail/vpopmail, etc. I am trying to upgrade my working 5.3.27 CDB installation to a 5.3.27 MYSQL installation. I have 10 domains currently running on this system through CDB databases.
RedHat 2.2.16-3 kernel mysqld -v outputs this: mysqld Ver 3.23.40 for pc-linux-gnu on i686 This is what I've done: create database vpopmail; grant update, create, delete, insert on vpopmail.* to [EMAIL PROTECTED] identified by "<password>"; grant select on vpopmail.* to [EMAIL PROTECTED] identified by "<password>"; flush privileges; (for each of the 10 domains) ./vconvert-cdb-sql-big.pl (for each of the 10 domains) ALTER TABLE <domain>_<dom> ADD COLUMN pw_clear_passwd char(16); in ~vpopmail/etc/vpopmail.mysql localhost|0|vpopmail_read|<password>|vpopmail localhost|0|vpopmail_edit|<password>|vpopmail chmod 600 /home/vpopmail/etc/vpopmail.mysql tar -xzpf vpopmail-5.3.27.tar.gz cd vpopmail-5.3.27 ./configure \ --enable-roaming-users=y \ --enable-tcpserver-file=/home/vpopmail/etc/tcp.smtp \ --enable-tcprules-prog=/usr/local/bin/tcprules \ --enable-relay-clear-minutes=180 \ --enable-auth-logging=y \ --enable-logging=p \ --enable-learn-passwords=y \ --enable-clear-passwd=y \ --enable-mysql=y \ --enable-incdir=/usr/include/mysql \ --enable-libdir=/usr/lib/mysql \ --enable-mysql-logging=y \ --enable-valias=y \ --enable-mysql-limits=n \ --enable-many-domains=n \ --enable-qmail-ext=y \ --enable-defaultquota=5000 make cp -R ~vpopmail/bin ~vpopmail/old.bin make install-strip cd ~vpopmail/bin ./vconvert -c -m Here's my /service/qmail-pop3d/run file: #!/bin/sh exec /usr/local/bin/softlimit -m 3000000 \ /usr/local/bin/tcpserver -H -R -v -c100 0 pop3 \ /var/qmail/bin/qmail-popup judah.khouse.org \ /home/vpopmail/bin/vchkpw /var/qmail/bin/qmail-pop3d Maildir 2>&1 My qmail install includes the patch < qmail-maildir++.patch. -------------------------------------- Everything installs and appears to be ready to go. mysql logging works and this is what I get in all my logs: vchkpw-pop3: vpopmail user not found <user>@<domain>:<ip address> If I do the exact same thing, changing --enable-mysql=y to --enable-mysql=n and (obviously) not running the vconvert, everything is peachy, although not using mysql. Any suggestions? Is there something I'm not seeing? Any particular logs that I should be checking? Thanks, Russell
