RE: [vchkpw] vpopmail 5.3.27 + mysql + mac osx mail
On Thursday, October 16, 2003, at 04:14 PM, Russell Mann wrote: On Thursday, October 16, 2003, at 09:55 AM, Russell Mann wrote: When a Mac OS X Mail.app client POP's in for mail, I always get an error log message like this: vchkpw-pop3: password fail (pass: 'd502e3b49fb33d7f7d419d469b51a5a0') EMAIL ADDRESS:IP ADDRESS Have them launch Mail.app, go into Preferences, select Accounts, go to the Advanced tab and check the Authentication popup. I'm able to use MD5 Challenge-Response or Password on my system. See if they have it set to one of the Kerberos options. Or, if it's set to MD5, have them try Password. I checked the Authentication preferences. They were already set to password. I set them to MD5 to see what happens and the MUA wasn't able to POP in. Any other ideas? What version of vpopmail are you using, and which POP3 server? -- Tom Collins - [EMAIL PROTECTED] 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 [EMAIL PROTECTED] bin]# more /service/qmail-pop3d/run #!/bin/sh VPOPMAILUID=`id -u vpopmail` VPOPMAILGID=`id -g vpopmail` exec /usr/local/bin/softlimit -m 400 \ /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 21
RE: [vchkpw] vpopmail 5.3.27 + mysql
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 300 \ /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 21 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?
RE: [vchkpw] vpopmail 5.3.27 + mysql
Russ, This may be because you are setting the pop3 user in your run script. Look at mine and try removing the vpopmail user. #!/bin/sh exec /usr/local/bin/softlimit -m 300 \ /usr/local/bin/tcpserver \ -H -l mailhost.net \ -v -x /etc/tcp.pop3.cdb -c 50 -R 0 pop3 \ /var/qmail/bin/qmail-popup mailhost.net \ /home/vpopmail/bin/vchkpw /var/qmail/bin/qmail-pop3d Maildir 21 Also, you don't need to use the /etc/tcp.pop3.cdb file. I just choose to. -- Regards, Tom Here's my /service/qmail-pop3d/run file: #!/bin/sh VPOPMAILUID=`id -u vpopmail` VPOPMAILGID=`id -g vpopmail` exec /usr/local/bin/softlimit -m 300 \ /usr/local/bin/tcpserver -H -R -v \ -u$VPOPMAILUID -g$VPOPMAILGID \ -c100 pop3 \ /var/qmail/bin/qmail-popup judah.khouse.org \ /home/vpopmail/bin/vchkpw \ /var/qmail/bin/qmail-pop3d Maildir 21 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?
RE: [vchkpw] vpopmail 5.3.27 + mysql
I know this may sound redundant or silly but check your permissions on qmail-pop3d and the vckpwd binary. Maybe your permissions on those files are the problem. Cuz by the looks of what you sent in email so far you have done it right. It's gotta be something stupid. Yes, tcp.pop3 file is for pop3 auth. Just a little extra precaution. I believe the qmail-pop3d runs under root. What version of MySQL are you using? -- Regards, Tom [EMAIL PROTECTED] mysqld -v mysqld Ver 3.23.40 for pc-linux-gnu on i686 /var/qmail/bin/qmail-pop3d -rwxr-xr-x 1 root qmail 26k Sep 25 15:54 qmail-pop3d /home/vpopmail/bin/vchkpw -rwxr-xr-x 1 root root 51k Sep 30 11:04 vchkpw* -- I've tried several options in the pop3d run file, as per official instructions, instructions on this email list etc. #!/bin/sh VPOPMAILUID=`id -u vpopmail` VPOPMAILGID=`id -g vpopmail` exec /usr/local/bin/softlimit -m 300 \ /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 21 #!/bin/sh exec /usr/local/bin/softlimit -m 300 \ /usr/local/bin/tcpserver \ -H -l judah.khouse.org -v \ -c 100 -R 0 pop3 \ /var/qmail/bin/qmail-popup judah.khouse.org \ /home/vpopmail/bin/vchkpw \ /var/qmail/bin/qmail-pop3d Maildir 21 #!/bin/sh VPOPMAILUID=`id -u vpopmail` VPOPMAILGID=`id -g vpopmail` exec /usr/local/bin/tcpserver -l 0 -R -H -v \ -u$VPOPMAILUID -g$VPOPMAILGID 0 110 \ /var/qmail/bin/qmail-popup judah.khouse.org \ /home/vpopmail/bin/vchkpw \ /var/qmail/bin/qmail-pop3d Maildir 21 - None of them seem to change it. What is the tcp.pop3.cdb file for? Is it an IP permissions file for popping email? Also, what user/group should qmail-pop3d run under in order to validate users correctly? Thanks, Russell
RE: [vchkpw] vpopmail 5.3.27 + mysql
On Thursday, September 25, 2003, at 04:38 PM, Russell Mann wrote: Here's my /service/qmail-pop3d/run file: #!/bin/sh exec /usr/local/bin/softlimit -m 300 \ /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 21 Try this instead (includes vpopmail user and group): #!/bin/sh VPOPMAILUID=`id -u vpopmail` VPOPMAILGID=`id -g vpopmail` exec /usr/local/bin/tcpserver -l 0 -R -H -v \ -u$VPOPMAILUID -g$VPOPMAILGID 0 110 \ /var/qmail/bin/qmail-popup judah.khouse.org \ /home/vpopmail/bin/vchkpw \ /var/qmail/bin/qmail-pop3d Maildir 21 -- Tom Collins Thanks Tom, I made that change but am still having the same issue. Any other ideas? I just noticed that the difference between the MYSQL and non-MYSQL bin dirs is fairly huge: new.bin: (WITH MYSQL) total 4.1M -rwxr-xr-x 1 root root 181k Sep 25 16:11 clearopensmtp* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vaddaliasdomain* -rwxr-xr-x 1 root root 184k Sep 25 16:11 vadddomain* -rwxr-xr-x 1 root root 183k Sep 25 16:11 vadduser* -rwxr-xr-x 1 root root 183k Sep 25 16:11 valias* -rwxr-xr-x 1 root root 189k Sep 25 16:11 vchkpw* -rwxr-xr-x 1 root root 185k Sep 25 16:12 vconvert* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vdeldomain* -rwxr-xr-x 1 root root 198k Sep 25 16:11 vdelivermail* -rwxr-xr-x 1 root root 183k Sep 25 16:11 vdeloldusers* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vdeluser* -rwxr-xr-x 1 root root 183k Sep 25 16:12 vdominfo* -rwxr-xr-x 1 root root 182k Sep 25 16:12 vipmap* -rwxr-xr-x 1 root root 182k Sep 25 16:12 vkill* -rwxr-xr-x 1 root root 181k Sep 25 16:12 vmkpasswd* -rwxr-xr-x 1 root root 190k Sep 25 16:12 vmoddomlimits* -rwxr-xr-x 1 root root 185k Sep 25 16:11 vmoduser* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vpasswd* -rwxr-xr-x 1 root root 185k Sep 25 16:11 vpopbull* -rwxr-xr-x 1 root root 188k Sep 25 16:12 vqmaillocal* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vsetuserquota* -rwxr-xr-x 1 root root 192k Sep 25 16:11 vuserinfo* old.bin: (WITHOUT MYSQL) total 1.1M -rwxr-xr-x 1 root root 43k Sep 25 16:15 clearopensmtp* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vaddaliasdomain* -rwxr-xr-x 1 root root 46k Sep 25 16:15 vadddomain* -rwxr-xr-x 1 root root 45k Sep 25 16:15 vadduser* -rwxr-xr-x 1 root root 47k Sep 25 16:15 valias* -rwxr-xr-x 1 root root 51k Sep 25 16:15 vchkpw* -rwxr-xr-x 1 root root 46k Sep 25 16:15 vconvert* -rwxr-xr-x 1 root root 43k Sep 25 16:15 vdeldomain* -rwxr-xr-x 1 root root 59k Sep 25 16:15 vdelivermail* -rwxr-xr-x 1 root root 45k Sep 25 16:15 vdeloldusers* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vdeluser* -rwxr-xr-x 1 root root 45k Sep 25 16:15 vdominfo* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vipmap* -rwxr-xr-x 1 root root 43k Sep 25 16:15 vkill* -rwxr-xr-x 1 root root 43k Sep 25 16:15 vmkpasswd* -rwxr-xr-x 1 root root 52k Sep 25 16:15 vmoddomlimits* -rwxr-xr-x 1 root root 46k Sep 25 16:15 vmoduser* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vpasswd* -rwxr-xr-x 1 root root 47k Sep 25 16:15 vpopbull* -rwxr-xr-x 1 root root 49k Sep 25 16:15 vqmaillocal* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vsetuserquota* -rwxr-xr-x 1 root root 54k Sep 25 16:15 vuserinfo* Does everyone see the same type of file size increase by including MYSQL? -Russell P.S. - List Owner - your list software is set to reply to the original sender rather than the list address - in case you weren't aware of it.
Re: [vchkpw] vpopmail 5.3.27 + mysql
Russell Mann wrote: snip P.S. - List Owner - your list software is set to reply to the original sender rather than the list address - in case you weren't aware of it. I think they did this on purpose, so that there is less mail for the list to handle, but then again its annoying because you got to edit what email adress to send it to :). As with your MySQL it being bigger, i have seen this as well. Might be because it has to include all the MySQL connection and database queries, thus making it bigger, as functions like get_pass() (NOTE: JUST AN EXAMPLE, NOT TAKEN FROM SOURCE CODE) have not to be rewritten so they work with MySQL.
RE: [vchkpw] vpopmail 5.3.27 + mysql
Mine looks the same, almost.. total 4.1M drwxr-xr-x2 vpopmail vchkpw 4.0K Sep 17 07:00 . drwxr-xr-x8 vpopmail vchkpw 4.0K Sep 24 14:07 .. -rwxr-xr-x1 root root 177K Sep 17 07:00 clearopensmtp -rwxr-xr-x1 root root 177K Sep 17 07:00 vaddaliasdomain -rwxr-xr-x1 root root 179K Sep 17 07:00 vadddomain -rwxr-xr-x1 root root 178K Sep 17 07:00 vadduser -rwxr-xr-x1 root root 178K Sep 17 07:00 valias -rwxr-xr-x1 root root 185K Sep 17 07:00 vchkpw -rwxr-xr-x1 root root 181K Sep 17 07:00 vconvert -rwxr-xr-x1 root root 177K Sep 17 07:00 vdeldomain -rwxr-xr-x1 root root 192K Sep 17 07:00 vdelivermail -rwxr-xr-x1 root root 178K Sep 17 07:00 vdeloldusers -rwxr-xr-x1 root root 177K Sep 17 07:00 vdeluser -rwxr-xr-x1 root root 178K Sep 17 07:00 vdominfo -rwxr-xr-x1 root root 177K Sep 17 07:00 vipmap -rwxr-xr-x1 root root 176K Sep 17 07:00 vkill -rwxr-xr-x1 root root 176K Sep 17 07:00 vmkpasswd -rwxr-xr-x1 root root 185K Sep 17 07:00 vmoddomlimits -rwxr-xr-x1 root root 180K Sep 17 07:00 vmoduser -rwxr-xr-x1 root root 177K Sep 17 07:00 vpasswd -rwxr-xr-x1 root root 181K Sep 17 07:00 vpopbull -rwxr-xr-x1 root root 182K Sep 17 07:00 vqmaillocal -rwxr-xr-x1 root root 177K Sep 17 07:00 vsetuserquota -rwxr-xr-x1 root root 188K Sep 17 07:00 vuserinfo -Tom Thanks Tom, I made that change but am still having the same issue. Any other ideas? I just noticed that the difference between the MYSQL and non-MYSQL bin dirs is fairly huge: new.bin: (WITH MYSQL) total 4.1M -rwxr-xr-x 1 root root 181k Sep 25 16:11 clearopensmtp* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vaddaliasdomain* -rwxr-xr-x 1 root root 184k Sep 25 16:11 vadddomain* -rwxr-xr-x 1 root root 183k Sep 25 16:11 vadduser* -rwxr-xr-x 1 root root 183k Sep 25 16:11 valias* -rwxr-xr-x 1 root root 189k Sep 25 16:11 vchkpw* -rwxr-xr-x 1 root root 185k Sep 25 16:12 vconvert* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vdeldomain* -rwxr-xr-x 1 root root 198k Sep 25 16:11 vdelivermail* -rwxr-xr-x 1 root root 183k Sep 25 16:11 vdeloldusers* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vdeluser* -rwxr-xr-x 1 root root 183k Sep 25 16:12 vdominfo* -rwxr-xr-x 1 root root 182k Sep 25 16:12 vipmap* -rwxr-xr-x 1 root root 182k Sep 25 16:12 vkill* -rwxr-xr-x 1 root root 181k Sep 25 16:12 vmkpasswd* -rwxr-xr-x 1 root root 190k Sep 25 16:12 vmoddomlimits* -rwxr-xr-x 1 root root 185k Sep 25 16:11 vmoduser* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vpasswd* -rwxr-xr-x 1 root root 185k Sep 25 16:11 vpopbull* -rwxr-xr-x 1 root root 188k Sep 25 16:12 vqmaillocal* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vsetuserquota* -rwxr-xr-x 1 root root 192k Sep 25 16:11 vuserinfo* old.bin: (WITHOUT MYSQL) total 1.1M -rwxr-xr-x 1 root root 43k Sep 25 16:15 clearopensmtp* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vaddaliasdomain* -rwxr-xr-x 1 root root 46k Sep 25 16:15 vadddomain* -rwxr-xr-x 1 root root 45k Sep 25 16:15 vadduser* -rwxr-xr-x 1 root root 47k Sep 25 16:15 valias* -rwxr-xr-x 1 root root 51k Sep 25 16:15 vchkpw* -rwxr-xr-x 1 root root 46k Sep 25 16:15 vconvert* -rwxr-xr-x 1 root root 43k Sep 25 16:15 vdeldomain* -rwxr-xr-x 1 root root 59k Sep 25 16:15 vdelivermail* -rwxr-xr-x 1 root root 45k Sep 25 16:15 vdeloldusers* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vdeluser* -rwxr-xr-x 1 root root 45k Sep 25 16:15 vdominfo* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vipmap* -rwxr-xr-x 1 root root 43k Sep 25 16:15 vkill* -rwxr-xr-x 1 root root 43k Sep 25 16:15 vmkpasswd* -rwxr-xr-x 1 root root 52k Sep 25 16:15 vmoddomlimits* -rwxr-xr-x 1 root root 46k Sep 25 16:15 vmoduser* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vpasswd* -rwxr-xr-x 1 root root 47k Sep 25 16:15 vpopbull* -rwxr-xr-x 1 root root 49k Sep 25 16:15 vqmaillocal* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vsetuserquota* -rwxr-xr-x 1 root root 54k Sep 25 16:15 vuserinfo* Does everyone see the same type of file size increase by including MYSQL? -Russell P.S. - List Owner - your list software is set to reply to the
Re: [vchkpw] vpopmail 5.3.27 + mysql
On Thursday, September 25, 2003, at 04:38 PM, Russell Mann wrote: Here's my /service/qmail-pop3d/run file: #!/bin/sh exec /usr/local/bin/softlimit -m 300 \ /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 21 Try this instead (includes vpopmail user and group): #!/bin/sh VPOPMAILUID=`id -u vpopmail` VPOPMAILGID=`id -g vpopmail` exec /usr/local/bin/tcpserver -l 0 -R -H -v \ -u$VPOPMAILUID -g$VPOPMAILGID 0 110 \ /var/qmail/bin/qmail-popup judah.khouse.org \ /home/vpopmail/bin/vchkpw \ /var/qmail/bin/qmail-pop3d Maildir 21 -- Tom Collins [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
