[vchkpw] Bounce Messages with Certain Attachments
I would like to setup qmail to bounce messages with *.vbs, *.scr and a few other attachments. If a message gets sent to a user on my system with an attachment like that, I want to bounce it back to the sender letting them know it was undeliverable because of the attachment. Is this possible? If so, how? Thanks, Chris Miller Compuville www.compuville.net
[vchkpw] qmailadmin question
When I setup a user in qmailadmin and check the Spam detection? box, it adds |preline /usr/local/bin/maildrop /etc/mailfilter to their ~/.qmail. This is great, except I need it to be something different. Where do I set what the Spam detection box adds to a users .qmail file? Thanks, Chris Miller Compuville www.compuville.net
RE: [vchkpw] Problem
When you say freezeing, what exactly do you mean? Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Simon [mailto:[EMAIL PROTECTED] Sent: Thursday, May 13, 2004 2:29 PM To: [EMAIL PROTECTED] Subject: [vchkpw] Problem Hopefully someone can help me with this. I am running Red Hat Linux 9.0, qmail, courier-imap-2.2.1, and vpopmail-5.2.1. For the past six months everything has been running smoothly almost no problems whatsoever. I have about 20 different domains using vpopmail. Recently, the mail has been freezing. Starting and stopping qmail seems to clear the problem up. I don't know if this is a vpopmail issue or a qmail issue. I've checked the que and everything has been processed. One of the domains did have a catch all account which they stopped using. Any suggestions would be appreciated. Simon
[vchkpw] SMTP Slowness
Now Ive got another problem with SMTP. When I try to connect, it takes FOREVER to send the welcome message. Go ahead and telnet into rhost1.zfx.com on port 25 and issue a HELO, and youll see what I mean. Just give it a few minutes before you do anything and youll see. After the initial wait, things are fine, but that first part takes forever. I thought that it could be something with DNS, but everything seems fine with DNS. The hostname and reverse DNS entries for the box are in there, and the DNS servers on the server are set correctly so it should be able to resolve its self pretty quickly (the DNS server it uses is on the local box, as is the zone for the domain). Any idea?? Thanks, Chris Miller Compuville www.compuville.net
RE: [vchkpw] Major SMTP AUTH Issues
Thanks, that fixed it. However, now SMTP is really slow (see my other message that should be coming through in a few minutes). Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Jeremy Kister [mailto:[EMAIL PROTECTED] Sent: Monday, April 26, 2004 1:52 AM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] Major SMTP AUTH Issues On Sunday, April 25, 2004 9:17 PM, Chris Miller wrote: I'm having major issues with SMTP AUTH. Currently, if a user authenticates they are allowed to relay. The problem is even if the user authenticates incorrectly, they are allowed to relay. I'm sure it's something in my qmail-smtpd run script, so I'm pasting it below: this has been discussed extensively, but... you are probably using Krzysztof Dabrowski's qmail-smtpd-auth-0.31 patch either patch your qmail with Erwin Hoffmann's http://www.fehcom.de/qmail/auth/qmail-smtpd-auth-043_tgz.bin or fix your run script: exec /usr/local/bin/softlimit -m 300 /usr/local/bin/tcpserver -v -R -l $LOCAL \ -x /etc/tcp.smtp.cdb -c $MAXSMTPD \ -u $VPOPUID -g $VPOPGID 0 smtp \ /var/qmail/bin/qmail-smtpd $LOCAL /var/vpopmail/bin/vchkpw /bin/true 21 I recommend Erwin's fixup, as it has bug fixes and updated functionality you may also want to investigate using the -H flag for tcpserver. Jeremy Kister http://jeremy.kister.net/
RE: [vchkpw] SMTP Slowness
No, qmail-smtpd. Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Rick Romero [mailto:[EMAIL PROTECTED] Sent: Monday, April 26, 2004 10:47 AM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] SMTP Slowness On Mon, 2004-04-26 at 08:42, Chris Miller wrote: Now I've got another problem with SMTP. When I try to connect, it takes FOREVER to send the welcome message. Go ahead and telnet into rhost1.zfx.com on port 25 and issue a HELO, and you'll see what I mean. Just give it a few minutes before you do anything and you'll see. After the initial wait, things are fine, but that first part takes forever. I thought that it could be something with DNS, but everything seems fine with DNS. The hostname and reverse DNS entries for the box are in there, and the DNS servers on the server are set correctly so it should be able to resolve it's self pretty quickly (the DNS server it uses is on the local box, as is the zone for the domain). Any idea?? Are you running rblsmtpd? Thanks, Chris Miller Compuville www.compuville.net
RE: [vchkpw] Re: SMTP Slowness
I just tested it again and timed it. 10 seconds until I get the banner from the time I connect and issue the EHLO command. That's unacceptable, it should be nearly instant. It's not like this is a slow box or anything (dual xeon box, it's got some ummph). Any ideas as to why the long delay? Also, you wanted me to run the command ps auxwww |grep '[t]cpserver .*qmail-smtpd': vpopmail 3628 0.0 0.1 2104 1328 ?S07:48 0:00 /usr/local/bin/tcpserver -v -R -l rhost1.zfx.com -x /etc/tcp.smtp.cdb -c 50 -u 89 -g 89 0 smtp /var/qmail/bin/qmail-smtpd rhost1.zfx.com /var/vpopmail/bin/vchkpw /bin/true Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Peter Palmreuther [mailto:[EMAIL PROTECTED] Sent: Monday, April 26, 2004 2:55 PM To: Chris Miller in vpop Subject: [vchkpw] Re: SMTP Slowness Hello Chris, On Monday, April 26, 2004 at 3:42:40 PM you wrote (at least in part): Now I've got another problem with SMTP. When I try to connect, it takes FOREVER to send the welcome message. Go ahead and telnet into rhost1.zfx.com on port 25 and issue a HELO, and you'll see what I mean. Both, connecting and issuing a EHLO (or HELO), is just a matter of seconds from here. I thought that it could be something with DNS, but everything seems fine with DNS. The hostname and reverse DNS entries for the box are in there, and the DNS servers on the server are set correctly so it should be able to resolve it's self pretty quickly (the DNS server it uses is on the local box, as is the zone for the domain). Well, it nevertheless could be a DNS related problem. The self referring reverse entries are not that much of a matter. What takes time most times this behavior is seen is reverse resolving of connecting client. So what's your 'tcpserver ... qmail-smtpd' invocation line[1]? [1]: ps auxwww |grep '[t]cpserver .*qmail-smtpd' -- Best regards Peter Palmreuther Progress is made on alternate Fridays.
RE: [vchkpw] Re: SMTP Slowness
Awesome, that did it. Thanks a bunch! Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Rick Morris [mailto:[EMAIL PROTECTED] Sent: Monday, April 26, 2004 4:47 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] Re: SMTP Slowness You haven't set the -H flag, so by default it's trying to look up the remote hostname in DNS for $TCPREMOTEHOST This may take a long time if reverse DNS isn't set up properly for the host connecting. On Monday 26 April 2004 12:23, Chris Miller wrote: I just tested it again and timed it. 10 seconds until I get the banner from the time I connect and issue the EHLO command. That's unacceptable, it should be nearly instant. It's not like this is a slow box or anything (dual xeon box, it's got some ummph). Any ideas as to why the long delay? Also, you wanted me to run the command ps auxwww |grep '[t]cpserver .*qmail-smtpd': vpopmail 3628 0.0 0.1 2104 1328 ?S07:48 0:00 /usr/local/bin/tcpserver -v -R -l rhost1.zfx.com -x /etc/tcp.smtp.cdb -c 50 -u 89 -g 89 0 smtp /var/qmail/bin/qmail-smtpd rhost1.zfx.com /var/vpopmail/bin/vchkpw /bin/true Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Peter Palmreuther [mailto:[EMAIL PROTECTED] Sent: Monday, April 26, 2004 2:55 PM To: Chris Miller in vpop Subject: [vchkpw] Re: SMTP Slowness Hello Chris, On Monday, April 26, 2004 at 3:42:40 PM you wrote (at least in part): Now I've got another problem with SMTP. When I try to connect, it takes FOREVER to send the welcome message. Go ahead and telnet into rhost1.zfx.com on port 25 and issue a HELO, and you'll see what I mean. Both, connecting and issuing a EHLO (or HELO), is just a matter of seconds from here. I thought that it could be something with DNS, but everything seems fine with DNS. The hostname and reverse DNS entries for the box are in there, and the DNS servers on the server are set correctly so it should be able to resolve it's self pretty quickly (the DNS server it uses is on the local box, as is the zone for the domain). Well, it nevertheless could be a DNS related problem. The self referring reverse entries are not that much of a matter. What takes time most times this behavior is seen is reverse resolving of connecting client. So what's your 'tcpserver ... qmail-smtpd' invocation line[1]? [1]: ps auxwww |grep '[t]cpserver .*qmail-smtpd' -- Rick Morris Network Manager WeDoHosting.com 101-4226 Commerce Circle Victoria BC V8Z 6N6 ph: +1 250 479 1595 fax: +1 250 479 1517 [EMAIL PROTECTED] http://www.wedohosting.com
[vchkpw] Major SMTP AUTH Issues
Im having major issues with SMTP AUTH. Currently, if a user authenticates they are allowed to relay. The problem is even if the user authenticates incorrectly, they are allowed to relay. Im sure its something in my qmail-smtpd run script, so Im pasting it below: #!/bin/sh # QMAILDUID=`id -u qmaild` # NOFILESGID=`id -g qmaild` VPOPUID=`id -u vpopmail` VPOPGID=`id -g vpopmail` MAXSMTPD=`cat /var/qmail/control/concurrencyincoming` LOCAL=`head -1 /var/qmail/control/me` if [ -z $VPOPUID -o -z $VPOPGID -o -z $MAXSMTPD -o -z $LOCAL ]; then echo VPOPUID, VPOPGID, 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 300 /usr/local/bin/tcpserver -v -R -l $LOCAL -x /etc/tcp.smtp.cdb -c $MAXSMTPD -u $VPOPUID -g $VPOPGID 0 smtp \ /var/qmail/bin/qmail-smtpd /var/vpopmail/bin/vchkpw /bin/true 21 Thanks, Chris Miller Compuville www.compuville.net
RE: [vchkpw] pros and cons of smtp auth and pop before smtp
Personally, I feel better knowing that each user authenticates before they send mail with SMTP AUTH rather then keeping an ad-hoc list of IPs that have POP-ed their mail in the last x-minutes. But that would be covered in Jeff's conceptually a more elegant approach bullet. Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Jeff Koch [mailto:[EMAIL PROTECTED] Sent: Monday, April 12, 2004 10:48 AM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] pros and cons of smtp auth and pop before smtp I'll take a crack at it. At 07:28 AM 4/12/2004, you wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, Can anybody point it out to me the pros and cons of: 1. smtp auth - some users have continual trouble configuring their email clients for smtp-auth - conceptually a more elegant approach - can allow the smtp and pop servers to be on different machines if you use mysql-auth 2. pop before smtp? - creates problems with qmail-scanner. Servers authorized to relay skip qmail-scanner virus checks. - simpler and easier to setup. Thanks. - -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux.arinet.org 18:27:38 up 9:50, Mandrake Linux release 9.2 (FiveStar) for i586 public key: https://www.arinet.org/fajar-pub.key -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAen1nkp5CsIXuxqURAsrHAJ9TQGI5ATNVH7TaUwLoVhVyJvKH+QCgvlON BGDFmqVjncW5pBi+41R2C3A= =mcA/ -END PGP SIGNATURE- Best Regards, Jeff Koch, Intersessions
RE: [vchkpw] domain quotas
I too would like to know the same information along those lines. Are the quotas in qmail a way to control actual disk quotas on the file system, meaning I'd have to have quota support in my kernel before I use this feature, or is this just something ad-hoc that vpopmail has done at a higher level than the file system quotas? Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Jeff Koch [mailto:[EMAIL PROTECTED] Sent: Monday, April 12, 2004 10:55 AM To: [EMAIL PROTECTED] Subject: [vchkpw] domain quotas Hi All: I'm thinking about implementing domain quotas on a new mailserver with qmailadmin and courier IMAP. Are domain quotas working OK in the latest vpopmail release? What should we be aware of in implementing this feature Any booby traps with clients and users? How does the notification process work? Are these hard quotas or soft quotas? Are they supported by qmailadmin and squirrelmail? Thanks in advance. Best Regards, Jeff Koch
RE: [vchkpw] roaming.
It's POP-before-SMTP. Personally, I like the idea of SMTP AUTH better, but both work... Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Jasmine [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 9:21 PM To: [EMAIL PROTECTED] Subject: [vchkpw] roaming. What exactly are roaming users? Jasmine
RE: [vchkpw] incdir
When you configure, include enable-incdir=/path/to/MySQL/include/directory/ Mine was /usr/local/mysql/include/ Thanks, Chris Miller Compuville www.compuville.net From: Jasmine [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 10:43 PM To: [EMAIL PROTECTED] Subject: [vchkpw] incdir I get this error whilst configuring vpopmail; configure: error: Unable to find your MySQL inc dir, specify --enable-incdir. what does it mean? I chose to use mysql authentication. Jaz.
RE: [vchkpw] Which File System?
I've had awful experiences with reiserfs. I've had many reisterfs file systems totally bomb on me -- not fun. Personally, I use XFS when possible and find it to be the fastest and most stable file system on the planet. Never had a problem with it. Ext3 is good too. Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Shane Chrisp [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 11:55 AM To: [EMAIL PROTECTED] Subject: [vchkpw] Which File System? Hi All, Im in the process of setting up a new server with a large disk array of sata disks running on debian and im wondering if I should stick with ext3 or go with reiserFS. Whats your experiences been either way? cheers Shane
[vchkpw] mbox to maildir
Not sure if this is the right place to post this or not. If its not, feel free to slap me.\ I have several mailboxes in the mbox format (traditional one file in /var/spool/mail/username). I need to convert these to maildir format. Ive seen the maildir2mbox, but thats going the wrong way. I need mbox2maildir. Thanks, Chris Miller Compuville www.compuville.net
RE: [vchkpw] MySQL has gone away
Well guys, Ive made progress on this. If I change the IP to my external IP rather than localhost it works. So apparently, its looking for the socket in the wrong place. Where does it pull the path of the socket from? Thanks, Chris Miller Compuville www.compuville.net From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 2:15 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] MySQL has gone away I am using 5.4.0, which is the latest version. I was using an older version before, but I ditched it and am reinstalling it. Thanks, Chris Miller Compuville www.compuville.net From: Remo Mattei [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 2:13 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] MySQL has gone away The version of vpopmail you are using is not using the file for password you need to modify the vmysql.c or .h I cant remember which one so make sure either you are using the latest version or modify that file and then recompile.. Remo Mattei NetworkSecurity Engineer cell 801-808-unix email [EMAIL PROTECTED] From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 12:03 PM To: [EMAIL PROTECTED] Subject: [vchkpw] MySQL has gone away Heres what I get when I try to add a domain: [/var/vpopmail/bin]# ./vadddomain test.com Please enter password for postmaster: enter password again: vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[2]: MySQL server has gone away Failed while attempting to add user to auth backend Error: (vadduser) no auth connection [/var/vpopmail/etc]# cat vpopmail.mysql localhost|0|vpopmail|***|vpopmail My password has odd characters in it, specifically the + character. Could that cause anything to break? I have tried connecting manually with the username/password in that file, and I can get in fine. Thanks, Chris Miller Compuville www.compuville.net
[vchkpw] SMTP AUTH with vchkpw
Below is the run script that supervise uses for qmail-smtpd. Notice now it uses /bin/checkpassword which is patched for MySQL support. However, Im moving to vchkpw, so how would I go about changing the script so that SMTP AUTH will work? [/var/qmail/supervise/qmail-smtpd]# cat run #!/bin/sh QMAILDUID=`id -u qmaild` NOFILESGID=`id -g qmaild` MAXSMTPD=`cat /var/qmail/control/concurrencyincoming` LOCAL=`head -1 /var/qmail/control/me` if [ -z $QMAILDUID -o -z $NOFILESGID -o -z $MAXSMTPD -o -z $LOCAL ]; then echo QMAILDUID $QMAILDUID, NOFILESGID $NOFILESGID, MAXSMTPD $MAXSMTPD, or LOCAL $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 1000 /usr/local/bin/tcpserver -v -R -l $LOCAL -u $QMAILDUID -x /etc/tcp.smtp.cdb -c $MAXSMTPD -g $NOFILESGID 0 smtp \ /var/qmail/bin/qmail-smtpd rhost1.zfx.com /bin/checkpassword /bin/true 21 Thank you! Thanks, Chris Miller Compuville www.compuville.net 423.276.6692
RE: [vchkpw] SMTP AUTH with vchkpw
Thank you. Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Werner Amon [mailto:[EMAIL PROTECTED] Sent: Sunday, March 28, 2004 3:53 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] SMTP AUTH with vchkpw Chris Miller schrieb: Below is the run script that supervise uses for qmail-smtpd. Notice now it uses /bin/checkpassword which is patched for MySQL support. However, I'm moving to vchkpw, so how would I go about changing the script so that SMTP AUTH will work? [/var/qmail/supervise/qmail-smtpd]# cat run #!/bin/sh QMAILDUID=`id -u qmaild` NOFILESGID=`id -g qmaild` MAXSMTPD=`cat /var/qmail/control/concurrencyincoming` LOCAL=`head -1 /var/qmail/control/me` if [ -z $QMAILDUID -o -z $NOFILESGID -o -z $MAXSMTPD -o -z $LOCAL ]; then echo QMAILDUID $QMAILDUID, NOFILESGID $NOFILESGID, MAXSMTPD $MAXSMTPD, or LOCAL $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 1000 /usr/local/bin/tcpserver -v -R -l $LOCAL -u $QMAILDUID -x /etc/tcp.smtp.cdb -c $MAXSMTPD -g $NOFILESGID 0 smtp \ /var/qmail/bin/qmail-smtpd rhost1.zfx.com /bin/checkpassword /bin/true 21 Thank you! Thanks, Chris Miller Compuville www.compuville.net 423.276.6692 Change QMAILDUID and NOFILESGID from qmaild to vpopmail and change /var/qmail/bin/qmail-smtpd rhost1.zfx.com /bin/checkpassword /bin/true 21 to /var/qmail/bin/qmail-smtpd rhost1.zfx.com /home/vpopmail/bin/vchkpw /bin/true 21 this should work Werner
[vchkpw] Learning Passwords
With the learning passwords feature enabled, does that set users passwords to the one they supply whenever they check their mail for the very first time? When Im adding a user, will it automatically overwrite the password that I enter? Thanks, Chris Miller Compuville www.compuville.net
[vchkpw] vpopmail database?
I just installed vpopmail and Im using MySQL support. I added the database vpopmail and user vpopmail and gave the user rights to the database. Now what? I cant find anything that documents the schema of the database. Do I have to manually create tables, or is there a SQL file somewhere that has the structure of the tables in the database? Also, my current setup uses the MySQL PASSWORD() function to store passwords encrypted. Am I going to be able to use this with vpopmail? I disable storing passwords in clear text, so Im assuming that it will use the same function to encrypt passwords correct? Thanks, Chris Miller Compuville www.compuville.net
RE: [vchkpw] vpopmail database?
I just realized that. I was using 5.2.1, but Im installing 5.4.0 right now -- MUCH more info with this version. I think Ill figure it out okay from here. J Thanks!! Thanks, Chris Miller Compuville www.compuville.net From: Remo Mattei [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 1:23 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] vpopmail database? You need to read the readme file for MySQL which is in the tar file. Remo Mattei NetworkSecurity Engineer cell 801-808-unix email [EMAIL PROTECTED] From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 11:11 AM To: [EMAIL PROTECTED] Subject: [vchkpw] vpopmail database? I just installed vpopmail and Im using MySQL support. I added the database vpopmail and user vpopmail and gave the user rights to the database. Now what? I cant find anything that documents the schema of the database. Do I have to manually create tables, or is there a SQL file somewhere that has the structure of the tables in the database? Also, my current setup uses the MySQL PASSWORD() function to store passwords encrypted. Am I going to be able to use this with vpopmail? I disable storing passwords in clear text, so Im assuming that it will use the same function to encrypt passwords correct? Thanks, Chris Miller Compuville www.compuville.net
RE: [vchkpw] vpopmail database?
Does vpopmail use the PASSWORD() function in MySQL to store passwords? I need this, since my current setup uses this method and I want to move accounts over without many problems. Thanks, Chris Miller Compuville www.compuville.net From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 1:21 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] vpopmail database? I just realized that. I was using 5.2.1, but Im installing 5.4.0 right now -- MUCH more info with this version. I think Ill figure it out okay from here. J Thanks!! Thanks, Chris Miller Compuville www.compuville.net From: Remo Mattei [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 1:23 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] vpopmail database? You need to read the readme file for MySQL which is in the tar file. Remo Mattei NetworkSecurity Engineer cell 801-808-unix email [EMAIL PROTECTED] From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 11:11 AM To: [EMAIL PROTECTED] Subject: [vchkpw] vpopmail database? I just installed vpopmail and Im using MySQL support. I added the database vpopmail and user vpopmail and gave the user rights to the database. Now what? I cant find anything that documents the schema of the database. Do I have to manually create tables, or is there a SQL file somewhere that has the structure of the tables in the database? Also, my current setup uses the MySQL PASSWORD() function to store passwords encrypted. Am I going to be able to use this with vpopmail? I disable storing passwords in clear text, so Im assuming that it will use the same function to encrypt passwords correct? Thanks, Chris Miller Compuville www.compuville.net
[vchkpw] MySQL has gone away
Heres what I get when I try to add a domain: [/var/vpopmail/bin]# ./vadddomain test.com Please enter password for postmaster: enter password again: vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[2]: MySQL server has gone away Failed while attempting to add user to auth backend Error: (vadduser) no auth connection [/var/vpopmail/etc]# cat vpopmail.mysql localhost|0|vpopmail|***|vpopmail My password has odd characters in it, specifically the + character. Could that cause anything to break? I have tried connecting manually with the username/password in that file, and I can get in fine. Thanks, Chris Miller Compuville www.compuville.net
RE: [vchkpw] SMTP AUTH
Is it safe to use 0.31 with vpopmail-5.4.0? Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Erwin Hoffmann [mailto:[EMAIL PROTECTED] Sent: Monday, March 22, 2004 12:12 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [vchkpw] SMTP AUTH Hi, dont use the version 0.32 of the smtp-auth patch; it's not gonna work with vpopmail 5.4.x. Read: http://www.fehcom.de/qmail/smtpauth.html regards. --eh. At 14:38 22.03.04 +0100, [EMAIL PROTECTED] wrote: Am Mo, 2004-03-22 um 14.30 schrieb Chris Miller: Does vpopmail come with SMTP AUTH? Is there a compatable patch out there? Try this one: qmail-smtpd-auth, http://members.elysium.pl/brush/qmail-smtpd-auth/, Gruss, Peter. -- [EMAIL PROTECTED], gpg -key http://blackhole.pca.dfn.de:11371/pks/lookup?op=getsearch=0x690A1AC2 Dr. Erwin Hoffmann | FEHCom | http://www.fehcom.de/ Wiener Weg 8, 50858 Cologne | T: +49 221 484 4923 | F: ...24
RE: [vchkpw] MySQL has gone away
I am using 5.4.0, which is the latest version. I was using an older version before, but I ditched it and am reinstalling it. Thanks, Chris Miller Compuville www.compuville.net From: Remo Mattei [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 2:13 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] MySQL has gone away The version of vpopmail you are using is not using the file for password you need to modify the vmysql.c or .h I cant remember which one so make sure either you are using the latest version or modify that file and then recompile.. Remo Mattei NetworkSecurity Engineer cell 801-808-unix email [EMAIL PROTECTED] From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 12:03 PM To: [EMAIL PROTECTED] Subject: [vchkpw] MySQL has gone away Heres what I get when I try to add a domain: [/var/vpopmail/bin]# ./vadddomain test.com Please enter password for postmaster: enter password again: vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[2]: MySQL server has gone away Failed while attempting to add user to auth backend Error: (vadduser) no auth connection [/var/vpopmail/etc]# cat vpopmail.mysql localhost|0|vpopmail|***|vpopmail My password has odd characters in it, specifically the + character. Could that cause anything to break? I have tried connecting manually with the username/password in that file, and I can get in fine. Thanks, Chris Miller Compuville www.compuville.net
RE: [vchkpw] SMTP AUTH
Yes, it does get me in. Let me try escaping the +. Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Shane Chrisp [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 2:19 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH does mysql -D vpopmail -user=vpopmail --password=pass get you in as well? Im guessing you might need to escape the \+ sign or your permissions on the vpopmail.mysql file are wrong. -rw-r-1 vpopmail vchkpw235 Sep 4 2003 vpopmail.mysql Shane. -Original Message- From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Sunday, 28 March 2004 3:04 AM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH Is it safe to use 0.31 with vpopmail-5.4.0? Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Erwin Hoffmann [mailto:[EMAIL PROTECTED] Sent: Monday, March 22, 2004 12:12 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [vchkpw] SMTP AUTH Hi, dont use the version 0.32 of the smtp-auth patch; it's not gonna work with vpopmail 5.4.x. Read: http://www.fehcom.de/qmail/smtpauth.html regards. --eh. At 14:38 22.03.04 +0100, [EMAIL PROTECTED] wrote: Am Mo, 2004-03-22 um 14.30 schrieb Chris Miller: Does vpopmail come with SMTP AUTH? Is there a compatable patch out there? Try this one: qmail-smtpd-auth, http://members.elysium.pl/brush/qmail-smtpd-auth/, Gruss, Peter. -- [EMAIL PROTECTED], gpg -key http://blackhole.pca.dfn.de:11371/pks/lookup?op=getsearch=0x690A1AC2 Dr. Erwin Hoffmann | FEHCom | http://www.fehcom.de/ Wiener Weg 8, 50858 Cologne | T: +49 221 484 4923 | F: ...24
RE: [vchkpw] SMTP AUTH
Nope, same error... -rw-r-1 vpopmail vchkpw 41 Mar 27 14:24 vpopmail.mysql Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Shane Chrisp [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 2:19 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH does mysql -D vpopmail -user=vpopmail --password=pass get you in as well? Im guessing you might need to escape the \+ sign or your permissions on the vpopmail.mysql file are wrong. -rw-r-1 vpopmail vchkpw235 Sep 4 2003 vpopmail.mysql Shane. -Original Message- From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Sunday, 28 March 2004 3:04 AM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH Is it safe to use 0.31 with vpopmail-5.4.0? Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Erwin Hoffmann [mailto:[EMAIL PROTECTED] Sent: Monday, March 22, 2004 12:12 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [vchkpw] SMTP AUTH Hi, dont use the version 0.32 of the smtp-auth patch; it's not gonna work with vpopmail 5.4.x. Read: http://www.fehcom.de/qmail/smtpauth.html regards. --eh. At 14:38 22.03.04 +0100, [EMAIL PROTECTED] wrote: Am Mo, 2004-03-22 um 14.30 schrieb Chris Miller: Does vpopmail come with SMTP AUTH? Is there a compatable patch out there? Try this one: qmail-smtpd-auth, http://members.elysium.pl/brush/qmail-smtpd-auth/, Gruss, Peter. -- [EMAIL PROTECTED], gpg -key http://blackhole.pca.dfn.de:11371/pks/lookup?op=getsearch=0x690A1AC2 Dr. Erwin Hoffmann | FEHCom | http://www.fehcom.de/ Wiener Weg 8, 50858 Cologne | T: +49 221 484 4923 | F: ...24
RE: [vchkpw] SMTP AUTH
Nope, Same problem. Is there any way to have it use a socket at '/var/run/mysqld/mysqld.sock' instead of over TCP/IP? Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Shane Chrisp [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 2:31 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH try changing the 0 in the file to 3306 like localhost|3306|vpopmail|pass|vpopmail Shouldn't have any effect but who knows. I have also had issues where ive needed to connect to the ip of the machine rather than localhost due to a few crazy mysql dns bugs. Adding the details to the hosts file sometimes fixes that one too. Shane -Original Message- From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Sunday, 28 March 2004 3:24 AM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH Nope, same error... -rw-r-1 vpopmail vchkpw 41 Mar 27 14:24 vpopmail.mysql Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Shane Chrisp [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 2:19 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH does mysql -D vpopmail -user=vpopmail --password=pass get you in as well? Im guessing you might need to escape the \+ sign or your permissions on the vpopmail.mysql file are wrong. -rw-r-1 vpopmail vchkpw235 Sep 4 2003 vpopmail.mysql Shane. -Original Message- From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Sunday, 28 March 2004 3:04 AM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH Is it safe to use 0.31 with vpopmail-5.4.0? Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Erwin Hoffmann [mailto:[EMAIL PROTECTED] Sent: Monday, March 22, 2004 12:12 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [vchkpw] SMTP AUTH Hi, dont use the version 0.32 of the smtp-auth patch; it's not gonna work with vpopmail 5.4.x. Read: http://www.fehcom.de/qmail/smtpauth.html regards. --eh. At 14:38 22.03.04 +0100, [EMAIL PROTECTED] wrote: Am Mo, 2004-03-22 um 14.30 schrieb Chris Miller: Does vpopmail come with SMTP AUTH? Is there a compatable patch out there? Try this one: qmail-smtpd-auth, http://members.elysium.pl/brush/qmail-smtpd-auth/, Gruss, Peter. -- [EMAIL PROTECTED], gpg -key http://blackhole.pca.dfn.de:11371/pks/lookup?op=getsearch=0x690A1AC2 Dr. Erwin Hoffmann | FEHCom | http://www.fehcom.de/ Wiener Weg 8, 50858 Cologne | T: +49 221 484 4923 | F: ...24
RE: [vchkpw] SMTP AUTH
Well, my connection file is correct. So why is it still saying MySQL Server has gone away? Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Michael Bowe [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 6:28 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] SMTP AUTH It is my understanding that : MYSQL CONNECTION SETTINGS FOR VPOPMAIL Line 1 defines the connection to use for database reads, Line 2 defines the connection to use for database updates/writes. If you omit line 2, then the same settings will be used for both read and write. settings for each line: host|port|user|password|database eg localhost|0|root|secret|vpopmail Note: The value of host may be either a hostname or an IP address. If host is 'localhost', then sockets (Unix) or named pipes (Windows) will be used instead of TCP/IP to connect to the server. Michael. - Original Message - From: Chris Miller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 28, 2004 5:43 AM Subject: RE: [vchkpw] SMTP AUTH Nope, Same problem. Is there any way to have it use a socket at '/var/run/mysqld/mysqld.sock' instead of over TCP/IP? Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Shane Chrisp [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 2:31 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH try changing the 0 in the file to 3306 like localhost|3306|vpopmail|pass|vpopmail Shouldn't have any effect but who knows. I have also had issues where ive needed to connect to the ip of the machine rather than localhost due to a few crazy mysql dns bugs. Adding the details to the hosts file sometimes fixes that one too. Shane -Original Message- From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Sunday, 28 March 2004 3:24 AM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH Nope, same error... -rw-r-1 vpopmail vchkpw 41 Mar 27 14:24 vpopmail.mysql Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Shane Chrisp [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 2:19 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH does mysql -D vpopmail -user=vpopmail --password=pass get you in as well? Im guessing you might need to escape the \+ sign or your permissions on the vpopmail.mysql file are wrong. -rw-r-1 vpopmail vchkpw235 Sep 4 2003 vpopmail.mysql Shane. -Original Message- From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Sunday, 28 March 2004 3:04 AM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH Is it safe to use 0.31 with vpopmail-5.4.0? Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Erwin Hoffmann [mailto:[EMAIL PROTECTED] Sent: Monday, March 22, 2004 12:12 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [vchkpw] SMTP AUTH Hi, dont use the version 0.32 of the smtp-auth patch; it's not gonna work with vpopmail 5.4.x. Read: http://www.fehcom.de/qmail/smtpauth.html regards. --eh. At 14:38 22.03.04 +0100, [EMAIL PROTECTED] wrote: Am Mo, 2004-03-22 um 14.30 schrieb Chris Miller: Does vpopmail come with SMTP AUTH? Is there a compatable patch out there? Try this one: qmail-smtpd-auth, http://members.elysium.pl/brush/qmail-smtpd-auth/, Gruss, Peter. -- [EMAIL PROTECTED], gpg -key http://blackhole.pca.dfn.de:11371/pks/lookup?op=getsearch=0x690A1AC2 Dr. Erwin Hoffmann | FEHCom | http://www.fehcom.de/ Wiener Weg 8, 50858 Cologne | T: +49 221 484 4923 | F: ...24
RE: [vchkpw] MySQL has gone away
Somehow, the subject of this conversation has gotten changed the original subject was MySQL has gone away. Please make sure all future messages related to this problem have this subject, NOT SMTP AUTH as that is a different problem. Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 8:39 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH Well, my connection file is correct. So why is it still saying MySQL Server has gone away? Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Michael Bowe [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 6:28 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] SMTP AUTH It is my understanding that : MYSQL CONNECTION SETTINGS FOR VPOPMAIL Line 1 defines the connection to use for database reads, Line 2 defines the connection to use for database updates/writes. If you omit line 2, then the same settings will be used for both read and write. settings for each line: host|port|user|password|database eg localhost|0|root|secret|vpopmail Note: The value of host may be either a hostname or an IP address. If host is 'localhost', then sockets (Unix) or named pipes (Windows) will be used instead of TCP/IP to connect to the server. Michael. - Original Message - From: Chris Miller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 28, 2004 5:43 AM Subject: RE: [vchkpw] SMTP AUTH Nope, Same problem. Is there any way to have it use a socket at '/var/run/mysqld/mysqld.sock' instead of over TCP/IP? Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Shane Chrisp [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 2:31 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH try changing the 0 in the file to 3306 like localhost|3306|vpopmail|pass|vpopmail Shouldn't have any effect but who knows. I have also had issues where ive needed to connect to the ip of the machine rather than localhost due to a few crazy mysql dns bugs. Adding the details to the hosts file sometimes fixes that one too. Shane -Original Message- From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Sunday, 28 March 2004 3:24 AM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH Nope, same error... -rw-r-1 vpopmail vchkpw 41 Mar 27 14:24 vpopmail.mysql Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Shane Chrisp [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 2:19 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH does mysql -D vpopmail -user=vpopmail --password=pass get you in as well? Im guessing you might need to escape the \+ sign or your permissions on the vpopmail.mysql file are wrong. -rw-r-1 vpopmail vchkpw235 Sep 4 2003 vpopmail.mysql Shane. -Original Message- From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Sunday, 28 March 2004 3:04 AM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH Is it safe to use 0.31 with vpopmail-5.4.0? Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Erwin Hoffmann [mailto:[EMAIL PROTECTED] Sent: Monday, March 22, 2004 12:12 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [vchkpw] SMTP AUTH Hi, dont use the version 0.32 of the smtp-auth patch; it's not gonna work with vpopmail 5.4.x. Read: http://www.fehcom.de/qmail/smtpauth.html regards. --eh. At 14:38 22.03.04 +0100, [EMAIL PROTECTED] wrote: Am Mo, 2004-03-22 um 14.30 schrieb Chris Miller: Does vpopmail come with SMTP AUTH? Is there a compatable patch out there? Try this one: qmail-smtpd-auth, http://members.elysium.pl/brush/qmail-smtpd-auth/, Gruss, Peter. -- [EMAIL PROTECTED], gpg -key http://blackhole.pca.dfn.de:11371/pks/lookup?op=getsearch=0x690A1AC2 Dr. Erwin Hoffmann | FEHCom | http://www.fehcom.de/ Wiener Weg 8, 50858 Cologne | T: +49 221 484 4923 | F: ...24
[vchkpw] SMTP AUTH
Does vpopmail come with SMTP AUTH? Is there a compatable patch out there? Thanks, Chris Miller Compuville www.compuville.net
RE: [vchkpw] Have I screwed myself?
Alright, thanks. Does anyone else know how I can migrate from what Ive got now to vpopmail? Also, hows this going to work with any SMTP AUTH patch? Thanks, Chris Miller Compuville www.compuville.net From: Shane Chrisp [mailto:[EMAIL PROTECTED] Sent: Sunday, March 07, 2004 9:45 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] Have I screwed myself? Yes if you use vpopmail + the chkusr patch, you can prevent those messages from ever reaching the queue of your mail server. Im not familiair with a qmail + Checkpassword with the MySQL patch setup, so you may need to recompile qmail to get it all working nicely. See a few of the howto documents like http://www.pipeline.com.au/staff/mbowe/isp/webmail-server.htmor http://www.shupp.org just to name 2 of the many howto's that are out there. Shane From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Monday, 8 March 2004 4:14 AM To: [EMAIL PROTECTED] Subject: [vchkpw] Have I screwed myself? Simple question: Have I screwed myself, and is it going to be possible to setup true multi domain hosting coming from what I have? My current setup is qmail + Checkpassword with the MySQL patch (from http://iain.cx/qmail/mysql/). It works great, but there is a major flaw with it. Lets say I setup an account to be [EMAIL PROTECTED] and another at [EMAIL PROTECTED]. If I send mail to [EMAIL PROTECTED] or [EMAIL PROTECTED], it will get to their mailbox. It should bounce, but it does not that is BAD. By using vchkpw, would that solve my problem? But how do I go about moving my current accounts in MySQL to work with the new schema of vchkpw? Also, is moving to vchkpw going to break my SMTP AUTH patch that I also use? Thanks, Chris Miller Compuville www.compuville.net
[vchkpw] Have I screwed myself?
Simple question: Have I screwed myself, and is it going to be possible to setup true multi domain hosting coming from what I have? My current setup is qmail + Checkpassword with the MySQL patch (from http://iain.cx/qmail/mysql/). It works great, but there is a major flaw with it. Lets say I setup an account to be [EMAIL PROTECTED] and another at [EMAIL PROTECTED]. If I send mail to [EMAIL PROTECTED] or [EMAIL PROTECTED], it will get to their mailbox. It should bounce, but it does not that is BAD. By using vchkpw, would that solve my problem? But how do I go about moving my current accounts in MySQL to work with the new schema of vchkpw? Also, is moving to vchkpw going to break my SMTP AUTH patch that I also use? Thanks, Chris Miller Compuville www.compuville.net