> Russ,
>       Try changing these lines in vpopmail.mysql.
> localhost|0|vpopmail_read|<password>|vpopmail
> localhost|0|vpopmail_edit|<password>|vpopmail
> TO
> localhost|mysql|vpopmailuser|vpoppasswd|vpopmail
> localhost|mysql|vpopmailuser|vpoppasswd|vpopmail
> -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.



(sending this to the list because I think it previously went to the default

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
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

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

VPOPMAILUID=`id -u vpopmail`
VPOPMAILGID=`id -g vpopmail`
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>

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?

Reply via email to