> Russ, > Try changing these lines in vpopmail.mysql. > FROM > localhost|0|vpopmail_read|<password>|vpopmail > localhost|0|vpopmail_edit|<password>|vpopmail > > TO > localhost|mysql|vpopmailuser|vpoppasswd|vpopmail > localhost|mysql|vpopmailuser|vpoppasswd|vpopmail > > -Tom
Tom, Thanks, I made those changes - still having the same issue. The fact that the vlog table fills up with errors when I use the mysql vpopmail would seem to indicate that at least one of these usernames would be working correctly. I did test them both with mysql at the command line. Thanks, Russell (sending this to the list because I think it previously went to the default reply-to) To recap... 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|mysql|vpopmail_read|<password>|vpopmail localhost|mysql|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 Here's my /service/qmail-pop3d/run file: #!/bin/sh VPOPMAILUID=`id -u vpopmail` VPOPMAILGID=`id -g vpopmail` exec /usr/local/bin/softlimit -m 3000000 \ /usr/local/bin/tcpserver -H -R -v \ -u"$VPOPMAILUID" -g"$VPOPMAILGID" \ -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> In the "error" column of vlog, it says: 1 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?
