RE: [vchkpw] Vpopmail using 5 Sleeping SQL's
Dear Shane, Yes, I'm using qmail-scanner + clamav + spamassassin. Would they cause multiple open connections to the SQL database? Thanks, Russell -Original Message- From: Shane Chrisp [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 12:07 PM To: vchkpw@inter7.com Subject: Re: [vchkpw] Vpopmail using 5 Sleeping SQL's On Fri, 2006-02-10 at 11:27 -0800, Russell Mann wrote: Hello List, I'm tracking down a problem with my linux server crashing about once a week, and one thing that pops up as a resource hog is vpopmail constantly running 5 sleeping processes, for lots and lots of seconds. Is this normal? Is this inefficient for sql? Is there a reason it keeps these connections open? I'm on vpopmail 5.4.13, using mysql 4.1.12 for authentication. Any input would be greatly appreciated. Are you running anything like qmail-scanner or other tools for spam/virus scanning? They can quickly wipe out whatever resources your system has available. Shane
[vchkpw] Vpopmail using 5 Sleeping SQL's
Hello List, I'm tracking down a problem with my linux server crashing about once a week, and one thing that pops up as a resource hog is vpopmail constantly running 5 sleeping processes, for lots and lots of seconds. Is this normal? Is this inefficient for sql? Is there a reason it keeps these connections open? I'm on vpopmail 5.4.13, using mysql 4.1.12 for authentication. Any input would be greatly appreciated. Thank you, Russell Mann
RE: [vchkpw] chkuser patch
The standard chkuser patch that vpopmail uses (see Bill Shupp's update to the original: http://www.shupp.org/patches/chkuser-0.6.mysql.patch) has some rather nasty behaviours. If for some reason your mysql server is unavailable (load has shot so high that mysql can't return a prompt reply, you're upgrading mysql, taking db down for maintenance, etc.) the chkusr patch will start telling remote smtp clients that the user doesn't exist. This is not good; you never want to send a 550 on a user that really does exist; people get upset when things bounce, and mailing lists start looking at auto-removal. That explains a lot. I thought the chkuser patch was awesome until I started seeing 550's bouncing to customers for email addresses that aren't actually 550. I'll be happy when the new patch comes about that fixes this issue. -Russell
[vchkpw] Mailman with Vpopmail
Hello, Has anyone on this list used Mailman for email list management in conjunction with vpopmail? I'm looking for a good set of instructions on setting this up. Thanks, Russell Mann
RE: [vchkpw] QS to reject misaddressed email at SMTP conversation
-Original Message- From: Shane Chrisp [mailto:[EMAIL PROTECTED] Sent: Friday, January 16, 2004 9:56 AM To: 'Russell Mann' Subject: RE: [vchkpw] QS to reject misaddressed email at SMTP conversation I had the same issues until I realised I needed to run the smtp daemon as the vpopmail user so it could look up the user. Shane Dear Shane, I changed my supervise script to do this: -- [EMAIL PROTECTED] qmail-smtpd]# more /service/qmail-smtpd/run #!/bin/sh # when QMAILQUEUE is set, all mail will be sent to the nominated script QMAILQUEUE=/var/qmail/bin/qmail-scanner-queue.pl export QMAILQUEUE VPOPMAILUID=`id -u vpopmail` VPOPMAILGID=`id -g vpopmail` MAXSMTPD=`cat /var/qmail/control/concurrencyincoming` LOCAL=`head -1 /var/qmail/control/me` if [ -z $VPOPMAILUID -o -z $VPOPMAILGID -o -z $MAXSMTPD -o -z $LOCAL ]; then echo VPOPMAILUID, VPOPMAILGID, MAXSMTPD, or LOCAL is unset in echo /var/qmail/supervise/qmail-smtpd/run exit 1 fi if [ ! -f /var/qmail/control/rcpthosts ]; then echo No /var/qmail/control/rcpthosts! echo Refusing to start SMTP listener because it'll create an open relay exit 1 fi exec /usr/local/bin/softlimit -m 1500 \ /usr/local/bin/tcpserver -v -R -l $LOCAL \ -x /home/vpopmail/etc/tcp.smtp.cdb -c $MAXSMTPD \ -u $VPOPMAILUID -g $VPOPMAILGID -c100 0 smtp rblsmtpd \ /var/qmail/bin/qmail-smtpd 21 -- It still doesn't appear to be working, but I'm not sure if I'm doing this right. Thanks, Russell
RE: [vchkpw] QS to reject misaddressed email at SMTP conversation
You'll need to run qmail-smtpd as vpopmail.vchkpw or suid root so it can access the vpopmail files. His web page fully explains how to do it and why it has to be done. Example #!/bin/sh QMAILDUID=`id -u vpopmail` NOFILESGID=`id -g vpopmail` MAXSMTPD=`cat /var/qmail/control/concurrencyincoming` exec /usr/local/bin/softlimit -m 1900 \ /usr/local/bin/tcpserver -p -v -R \ -x /home/vpopmail/etc/tcp.smtp.cdb -c $MAXSMTPD \ -u $QMAILDUID -g $NOFILESGID 0 smtp \ /var/qmail/bin/qmail-smtpd-chkusr domain.com \ /home/vpopmail/bin/vchkpw /bin/true Regards, Rick Ok, following the instructions on: http://www.interazioni.it/qmail/#qmail-smtpd I thought I was doing it right to have it like this: [EMAIL PROTECTED] l /var/qmail/bin/qmail-smtpd -r-sr-sr-x 1 qmaild nofiles 30k Jan 15 16:17 /var/qmail/bin/qmail-smtpd* Should it be something different? I've readjusted my supervise script like this: - [EMAIL PROTECTED] bin]# more /service/qmail-smtpd/run #!/bin/sh # when QMAILQUEUE is set, all mail will be sent to the nominated script QMAILQUEUE=/var/qmail/bin/qmail-scanner-queue.pl export QMAILQUEUE VPOPMAILUID=`id -u vpopmail` VPOPMAILGID=`id -g vpopmail` MAXSMTPD=`cat /var/qmail/control/concurrencyincoming` LOCAL=`head -1 /var/qmail/control/me` if [ -z $VPOPMAILUID -o -z $VPOPMAILGID -o -z $MAXSMTPD -o -z $LOCAL ]; then echo VPOPMAILUID, VPOPMAILGID, MAXSMTPD, or LOCAL is unset in echo /var/qmail/supervise/qmail-smtpd/run exit 1 fi if [ ! -f /var/qmail/control/rcpthosts ]; then echo No /var/qmail/control/rcpthosts! echo Refusing to start SMTP listener because it'll create an open relay exit 1 fi exec /usr/local/bin/softlimit -m 1500 \ /usr/local/bin/tcpserver -v -R -l $LOCAL \ -x /home/vpopmail/etc/tcp.smtp.cdb -c $MAXSMTPD \ -u $VPOPMAILUID -g $VPOPMAILGID -c100 0 smtp rblsmtpd \ /var/qmail/bin/qmail-smtpd 21 - Is that effectively doing the same thing? Thanks, Russell
[vchkpw] qmail-smtpd-chkusr patch not applying
Hello, Ok, my previous emails have been assuming that the patch was applied, however by diffing the old qmail-smtpd and the new qmail-smtpd and finding zero binary differences, I figured out that my previous patch had been failing due to an earlier patch moving lines around in qmail-smtpd.c. So, I stripped it back to just vanilla qmail-1.03, plus the patch, just to see where I could get, and this is whats up: I've been having some trouble applying the qmail-smtpd-chkusr patch to qmail-1.03. I'm on a RedHat 6.2 system, and I tried to make it as simple as possible. Below are what I hope are the relevant information for figuring out what's wrong. I'm using the regular-patch from this page: http://www.interazioni.it/qmail/#qmail-smtpd Any suggestions would be great. Thanks, Russell Mann -- Commands I use to unpack, patch, and compile. -- tar -xzpf qmail-1.03.tar.gz cp qmail-smtpd-chkusr-1.0.patch qmail-1.03 cd qmail-1.03 patch qmail-smtpd.c qmail-smtpd-chkusr-1.0.patch make -- last few lines of compile output -- ./compile qmail-smtpd.c qmail-smtpd.c: In function `realrcpt_check': qmail-smtpd.c:346: warning: comparison between pointer and integer qmail-smtpd.c: In function `main': qmail-smtpd.c:637: warning: return type of `main' is not `int' ./load qmail-smtpd rcpthosts.o commands.o timeoutread.o \ timeoutwrite.o ip.o ipme.o ipalloc.o control.o constmap.o \ received.o date822fmt.o now.o qmail.o cdb.a fd.a wait.a \ datetime.a getln.a open.a sig.a case.a env.a stralloc.a \ alloc.a substdio.a error.a str.a fs.a auto_qmail.o `cat \ socket.lib` qmail-smtpd.o: In function `realrcpt_check': qmail-smtpd.o(.text+0x803): undefined reference to `default_domain' qmail-smtpd.o(.text+0x87a): undefined reference to `vget_assign' qmail-smtpd.o(.text+0x957): undefined reference to `vauth_getpw' qmail-smtpd.o(.text+0x987): undefined reference to `valias_select' collect2: ld returned 1 exit status make: *** [qmail-smtpd] Error 1 -- Patch Edited: -- 26a37,47 #include pwd.h #include sys/types.h #include unistd.h #include dirent.h #include stdio.h #include open.h #include /home/vpopmail/include/vpopmail.h #include /home/vpopmail/include/vauth.h #include /home/vpopmail/include/vpopmail_config.h 62d82 -- Patch Edited Again: -- /* Check if domain is a real domain */ /* Let's get domain's real path */ -- [EMAIL PROTECTED] qmail-1.03]# l /home/vpopmail/include/ -- total 24k -r--r--r-- 1 vpopmail vchkpw 3.6k Oct 2 09:45 config.h -r--r--r-- 1 vpopmail vchkpw 3.7k Oct 2 09:45 vauth.h -r--r--r-- 1 vpopmail vchkpw 1.8k Oct 2 09:45 vlimits.h -r--r--r-- 1 vpopmail vchkpw 5.8k Oct 2 09:45 vpopmail.h -r--r--r-- 1 vpopmail vchkpw 3.6k Oct 2 09:45 vpopmail_config.h -- [EMAIL PROTECTED] qmail-1.03]# more qmail-smtpd.c -- /* * * Patch 'qmail-smtpd-chkusr' v.1.0 * for qmail 1.03 and vpopmail 5.3.3 * * Antonio Nati [EMAIL PROTECTED] * */ /* Lots of includes here, edited for brevity /* #include pwd.h #include sys/types.h #include unistd.h #include dirent.h #include stdio.h #include open.h #include /home/vpopmail/include/vpopmail.h #include /home/vpopmail/include/vauth.h #include /home/vpopmail/include/vpopmail_config.h --
RE: [vchkpw] QS to reject misaddressed email at SMTP conversation
ok so we're both right and we're both wrong. the patch functionality itself does not require the qmail-toaster patch, however, since the patch file itself was created against the qmail-toaster patch, it requires it to be cleanly patched without manual intervention. So, if you don't want to do any work, then I guess it requires the toaster patch. Perhaps he should make a patch against stock qmail so those of us who don't want to use his 'toaster' patch can use it anyways. -Jeremy Or he should at least say somewhere on his site that the chkuser patch requires the toaster. At least then I would have ignored it instead of trying to get it to work against vanilla qmail :) -Russell
RE: [vchkpw] qmail-smtpd-chkusr patch not applying
You didn't patch the Makefile to include the vpopmail libs... From the documentation on his site *** Modify your qmail Makefile and include vpopmail and crypt libraries (also include mysql or whenever other libraries you're using for authentication within vpopmail - i.e. ldap, sybase, postgres, etc.) Make make and rebuild qmake-smtpd, and rename it qmail-smtpd-chkusr, in order to know later which version you're using. ie in the Make file add -L/home/vpopmail/lib -lvpopmail to the end of the qmail-smtpd: compile line in the Makefile. Mine reads as below (I have extra stuff like mysql, so don't worry about that). qmail-smtpd: \ load qmail-smtpd.o rcpthosts.o commands.o timeoutread.o \ timeoutwrite.o ip.o ipme.o ipalloc.o control.o constmap.o received.o \ date822fmt.o now.o qmail.o cdb.a fd.a wait.a datetime.a getln.a \ open.a sig.a case.a env.a stralloc.a alloc.a substdio.a error.a str.a \ fs.a auto_qmail.o base64.o socket.lib ./load qmail-smtpd rcpthosts.o commands.o timeoutread.o \ timeoutwrite.o ip.o ipme.o ipalloc.o control.o constmap.o \ received.o date822fmt.o now.o qmail.o cdb.a fd.a wait.a \ datetime.a getln.a open.a sig.a case.a env.a stralloc.a \ alloc.a substdio.a error.a str.a fs.a auto_qmail.o base64.o `cat \ socket.lib` -L/usr/local/ssl/lib -L/home/vpopmail/lib -lssl -lcrypto -lv popmail \ -L/usr/local/mysql/lib -lmysqlclient -lz Thanks Rick... I'm sure that's where I'm hanging up, but there are no good instructions on how to do this, just This is what you should do. The patch author pointed me to this url: http://www.kendzorra.de/chkusr.html So, I've tried several things in the Makefile, to no avail. - Original Makefile: - qmail-smtpd: \ load qmail-smtpd.o rcpthosts.o commands.o timeoutread.o \ timeoutwrite.o ip.o ipme.o ipalloc.o control.o constmap.o received.o \ date822fmt.o now.o qmail.o cdb.a fd.a wait.a datetime.a getln.a \ open.a sig.a case.a env.a stralloc.a alloc.a substdio.a error.a str.a \ fs.a auto_qmail.o socket.lib ./load qmail-smtpd rcpthosts.o commands.o timeoutread.o \ timeoutwrite.o ip.o ipme.o ipalloc.o control.o constmap.o \ received.o date822fmt.o now.o qmail.o cdb.a fd.a wait.a \ datetime.a getln.a open.a sig.a case.a env.a stralloc.a \ alloc.a substdio.a error.a str.a fs.a auto_qmail.o `cat \ socket.lib` - - Failed Makefile: - qmail-smtpd: \ load qmail-smtpd.o rcpthosts.o commands.o timeoutread.o \ timeoutwrite.o ip.o ipme.o ipalloc.o control.o constmap.o received.o \ date822fmt.o now.o qmail.o cdb.a fd.a wait.a datetime.a getln.a \ open.a sig.a case.a env.a stralloc.a alloc.a substdio.a error.a str.a \ fs.a auto_qmail.o socket.lib ./load qmail-smtpd rcpthosts.o commands.o timeoutread.o \ timeoutwrite.o ip.o ipme.o ipalloc.o control.o constmap.o \ received.o date822fmt.o now.o qmail.o cdb.a fd.a wait.a \ datetime.a getln.a open.a sig.a case.a env.a stralloc.a \ alloc.a substdio.a error.a str.a fs.a auto_qmail.o `cat \ socket.lib` \ -lcrypt /home/vpopmail/lib/libvpopmail.a \ -L/usr/lib/mysql -lmysqlclient - Failure Messages: - qmail-smtpd.c: In function `realrcpt_check': qmail-smtpd.c:346: warning: comparison between pointer and integer qmail-smtpd.c: In function `main': qmail-smtpd.c:637: warning: return type of `main' is not `int' ./load qmail-smtpd rcpthosts.o commands.o timeoutread.o \ timeoutwrite.o ip.o ipme.o ipalloc.o control.o constmap.o \ received.o date822fmt.o now.o qmail.o cdb.a fd.a wait.a \ datetime.a getln.a open.a sig.a case.a env.a stralloc.a \ alloc.a substdio.a error.a str.a fs.a auto_qmail.o `cat \ socket.lib` \ -lcrypt /home/vpopmail/lib/libvpopmail.a \ -L/usr/lib/mysql -lmysqlclient /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x9a): undefined reference to `uncompress' /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12a): undefined reference to `compress' collect2: ld returned 1 exit status make: *** [qmail-smtpd] Error 1 - Thanks, Russell Mann
RE: [vchkpw] QS to reject misaddressed email at SMTP conversation
It does: Qmail chkuser patch Checks that the vpopmail recipient is valid before accepting the message. requires vpopmail to be installed first, and that the 0.5 patch above is applied to qmail. Please select the appropriate version: --Doug Oops, my bad. Sorry bout that. I shouldn't have been so grumpy either. 32 hours awake with a little 1 hour nap. Turns out using the toaster and Shupp's patch worked best for me. Almost all the other patches worked too, except this one: nullenvsender-recipcount.patch. I guess that'll have to be an OK trade off. Thanks Bill, and thanks eveyone else! -Russell
[vchkpw] QS to reject misaddressed email at SMTP conversation
through this server, and 90% of the spam is misaddressed. Clamscanning and SpamAssassin'ing, with RBL checks, on all those emails that aren't going anywhere, is not cool. Thanks for your help, Russell Mann
[vchkpw] qmail CNAME lookup failed temporarily
Hello, Vpopmail 5.3.27 Qmail 1.03 patch doublebounce-trim.patch patch qmail-remote.diff patch qmail-local.diff patch qmail-1.03-mfcheck.3.patch patch nullenvsender-recipcount.patch patch sendmail-flagf.patch patch qmail-maildir++.patch patch qmail-queue.patch I'm getting the CNAME lookup failed temporarily error for earthlink.net addresses. I've read this: http://web.infoave.net/~dsill/lwq.html#dns-patches -- dnscache is, as the name implies, a caching DNS server. It knows how to handle large DNS responses and generally improves DNS lookup performance for all services that use DNS. Because it doesn't require patching qmail, this is by far the best solution. See the djbdns section under Related Packages for more information. -- Question I have is what if I don't own the DNS server? I'm using an /etc/resolv.conf file to point to my Colo companies DNS server. Maybe I don't understand something? Thanks, Russell
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] Aliases on Vpopmail + Qmail + mysql
Hello , I am new on list , but I come request a help. I should like of creating a ally , what you sent the messages about to another . example : I have the mail : [EMAIL PROTECTED] what distributing about to another emails. I tried act a part into the ~ alias/ of the qmail , but I send the message return the the next I mistake : Sorry, no mailbox here by that name. vpopmail (#5.1.1) I should like of knowing I eat behave. - THIAGO ANDERSON SANTOS Adm. de Rede - Uniminas http://www.uniminas.br Linux 4ever - Slackware Bom dia Thiago, You will need to create an alias file in /home/vpopmail/domains/domain/ directory. If you have qmailadmin installed, this can be done through a web based admin. -Russell
RE: [vchkpw] istn´t allowed rcpthosts error
How can I start qmail-smtpd smtp service by tcpserver so that my customers which are relying from overall can relay. I read selective relaying But what can I do now? Oliver -- t-host GmbH Mobil: 0170/2781117 D-80337 München Tel: +49 89 54071102 Tumblinger Straße 50 Fax: +49 89 54071103 Guten Tag Oliver, If you're trying to use POP before SMTP auth to get roaming users to be able to relay, set the --enable-roaming-users=y flag on compile of vpopmail. In your qmail-smtpd/run file, you'll need this line: -x /home/vpopmail/etc/tcp.smtp.cdb added in. An example from my machine is: exec /usr/local/bin/softlimit -m 1500 \ /usr/local/bin/tcpserver -v -R -l $LOCAL \ -x /home/vpopmail/etc/tcp.smtp.cdb -c $MAXSMTPD \ -u $QMAILDUID -g $NOFILESGID -c100 0 smtp rblsmtpd \ /var/qmail/bin/qmail-smtpd 21 You'll also need a crontab: 40 0 * * * su -c /home/vpopmail/bin/clearopensmtp 21 /dev/null vpopmail Note: Some of the filenames may be different depending on how you've installed everything. Viele Gluck! Russell Mann
RE: [vchkpw] vpopmail 5.3.28 + mysql + mac osx mail
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? -Russell
[vchkpw] vpopmail + mysql
Hello, Finally fixed the vpopmail 5.3.27 + mysql non-working issue (see previous posts). In trying to track this down I've come across some other problems. [EMAIL PROTECTED] new.bin]# ./vadddomain media.khouse.org Please enter password for postmaster: enter password again: Error: Domain already exists [EMAIL PROTECTED] new.bin]# Domain already exists eh? media.khouse.org not found in: ~vpopmail/domains/* /var/qmail/users/assign /var/qmail/control/rcpthosts /var/qmail/control/virtualdomains Whats up with that? By the way, this is how I fixed the mysql issue: After this, I made some changes to ~vpopmail/etc/vpopmail.mysql I went from two lines to one line, and gave the one line user these permissions: SELECT, INSERT, UPDATE, DELETE, CREATE Thanks, Russell
RE: [vchkpw] vpopmail + mysql
On Thursday, October 2, 2003, at 10:52 AM, Russell Mann wrote: Finally fixed the vpopmail 5.3.27 + mysql non-working issue (see previous posts). In trying to track this down I've come across some other problems. [EMAIL PROTECTED] new.bin]# ./vadddomain media.khouse.org Please enter password for postmaster: enter password again: Error: Domain already exists [EMAIL PROTECTED] new.bin]# Domain already exists eh? media.khouse.org not found in: ~vpopmail/domains/* /var/qmail/users/assign /var/qmail/control/rcpthosts /var/qmail/control/virtualdomains Whats up with that? Is it still in the MySQL database? Nope, I dropped it manually. By the way, this is how I fixed the mysql issue: After this, I made some changes to ~vpopmail/etc/vpopmail.mysql I went from two lines to one line, and gave the one line user these permissions: SELECT, INSERT, UPDATE, DELETE, CREATE Hmm. This is good to know. What happens if you use the same login information on both lines? Does it still work? With one simple test it seems to work. I didn't try anything but popping in, as this is a production box. There's a chance that part of the auth module is opening a read connection when it should be opening an update connection. This is what I suspected, but I'm not familiar enough with this code base to track down which exact line it is. I was getting a sql error[3] which is always listed as a read open.
RE: [vchkpw] vpopmail + mysql
After removing it from users/assign, did you run qmail-newu to update users/cdb? The vpopmail code actually uses the cdb file, and not the assign file used to create it, when checking to see if a domain already exists. [EMAIL PROTECTED] /var/qmail/bin/qmail-newu qmail-newu: fatal: bad format in users/assign
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
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.
[vchkpw] vpopmail 5.3.27 + mysql
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 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 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