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
flush privileges;

(for each of the 10 domains)
(for each of the 10 domains)
ALTER TABLE <domain>_<dom> ADD COLUMN pw_clear_passwd char(16);

in ~vpopmail/etc/vpopmail.mysql


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 \

cp -R ~vpopmail/bin ~vpopmail/old.bin
make install-strip

cd ~vpopmail/bin
./vconvert -c -m

Here's my /service/qmail-pop3d/run file:

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?



Reply via email to