RE: [vchkpw] intermittent smtp auth errors
New development.. what's even more strange about this is that it is primarily happening on one server in the cluster and not the others. All of which have identical mysql configs, with the exception of their ID in the cluster, vpopmail and qmail installations. -Original Message- From: Ken Jones [mailto:[EMAIL PROTECTED] Sent: Thursday, September 22, 2005 10:09 AM To: vchkpw@inter7.com Subject: Re: [vchkpw] intermittent smtp auth errors Clayton Weise wrote: > I've got an odd error that is coming up and I can't quite put my finger > on it. I have 3 mail servers running qmail/vpopmail (5.4.10) and MySQL > 3.23.58. I also have mysql replication running and vpopmail is > configured in accordance with that (reads on localhost, writes on the db > server). We've been receiving complaints from customers about > intermittent smtp errors and when I tail the maillog I'm seeing errors > like this: > > Sep 22 08:58:37 qmail1 vpopmail[64930]: vchkpw-smtp: vpopmail user not > found [EMAIL PROTECTED]:1.2.3.4 > Sep 22 08:58:39 qmail1 vpopmail[64995]: vchkpw-smtp: vpopmail user not > found [EMAIL PROTECTED]:1.2.3.4 > Sep 22 08:58:40 qmail1 vpopmail[65022]: vchkpw-smtp: vpopmail user not > found [EMAIL PROTECTED]:1.2.3.4 > > In the interest of our users' privacy I have replaced the various email > & ip addresses with the [EMAIL PROTECTED] and 1.2.3.4. What's strange is that > it's not happening with any other authentication method (pop3, imap, > etc), only smtp. It fails out saying "user not found" and yet a > 'vuserinfo' on that user reveals they actually do exist. I have qmail > patched with the smtp auth patch from: > > http://members.elysium.pl/brush/qmail-smtpd-auth/ > > I'm happy to provide any other information that might be helpful in > figuring this out. Any suggestions are, of course, welcomed. You might be running out of mysql connections. Check your my.cnf file for max_connections variable. The default value is 100 connections. You'll need the max_connections to cover your max smtp, imap, pop3 local concurrency and any other services that connect to the mysql database. Hope that helps, Ken Jones
RE: [vchkpw] intermittent smtp auth errors
I knew I forgot to mention something. I've got max connections set to 500 and if I log into mysql and run a 'SHOW PROCESSLIST' I get anywhere from 40-60 records returned back. Is there another good way to measure the number of connections coming into mysql? -Original Message- From: Ken Jones [mailto:[EMAIL PROTECTED] Sent: Thursday, September 22, 2005 10:09 AM To: vchkpw@inter7.com Subject: Re: [vchkpw] intermittent smtp auth errors --- TRUNCATED --- You might be running out of mysql connections. Check your my.cnf file for max_connections variable. The default value is 100 connections. You'll need the max_connections to cover your max smtp, imap, pop3 local concurrency and any other services that connect to the mysql database. Hope that helps, Ken Jones
Re: [vchkpw] intermittent smtp auth errors
Clayton Weise wrote: I've got an odd error that is coming up and I can't quite put my finger on it. I have 3 mail servers running qmail/vpopmail (5.4.10) and MySQL 3.23.58. I also have mysql replication running and vpopmail is configured in accordance with that (reads on localhost, writes on the db server). We've been receiving complaints from customers about intermittent smtp errors and when I tail the maillog I'm seeing errors like this: Sep 22 08:58:37 qmail1 vpopmail[64930]: vchkpw-smtp: vpopmail user not found [EMAIL PROTECTED]:1.2.3.4 Sep 22 08:58:39 qmail1 vpopmail[64995]: vchkpw-smtp: vpopmail user not found [EMAIL PROTECTED]:1.2.3.4 Sep 22 08:58:40 qmail1 vpopmail[65022]: vchkpw-smtp: vpopmail user not found [EMAIL PROTECTED]:1.2.3.4 In the interest of our users' privacy I have replaced the various email & ip addresses with the [EMAIL PROTECTED] and 1.2.3.4. What's strange is that it's not happening with any other authentication method (pop3, imap, etc), only smtp. It fails out saying "user not found" and yet a 'vuserinfo' on that user reveals they actually do exist. I have qmail patched with the smtp auth patch from: http://members.elysium.pl/brush/qmail-smtpd-auth/ I'm happy to provide any other information that might be helpful in figuring this out. Any suggestions are, of course, welcomed. You might be running out of mysql connections. Check your my.cnf file for max_connections variable. The default value is 100 connections. You'll need the max_connections to cover your max smtp, imap, pop3 local concurrency and any other services that connect to the mysql database. Hope that helps, Ken Jones
