HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=4)
-   -   Postfix+MySQL Problem (http://www.howtoforge.com/forums/showthread.php?t=4913)

jasutton 15th June 2006 06:16

Postfix+MySQL Problem
 
I've got a problem with the Postfix+MySQL setup (running Ubuntu Breezy). It will deliver mail just fine for a while (maybe an hour or so), and then it will just stop delivering mail. Here's a sampling of the log file for what seems to be a single piece of incoming mail:

Code:

Jun 14 07:15:59 mywebsitestinks postfix/proxymap[21432]: warning: connect to mysql server 127.0.0.1: Host 'localhost.localdomain' is blocked because of many c
onnection errors.  Unblock with 'mysqladmin flush-hosts'
Jun 14 07:15:59 mywebsitestinks postfix/proxymap[21432]: warning: connect to mysql server 127.0.0.1: Host 'localhost.localdomain' is blocked because of many c
onnection errors.  Unblock with 'mysqladmin flush-hosts'
Jun 14 07:15:59 mywebsitestinks postfix/trivial-rewrite[21451]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem
Jun 14 07:15:59 mywebsitestinks postfix/trivial-rewrite[21453]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem
Jun 14 07:16:00 mywebsitestinks postfix/smtpd[21431]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Jun 14 07:16:00 mywebsitestinks postfix/smtpd[21431]: warning: problem talking to service rewrite: Success
Jun 14 07:16:00 mywebsitestinks postfix/smtpd[21438]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Jun 14 07:16:00 mywebsitestinks postfix/smtpd[21438]: warning: problem talking to service rewrite: Connection reset by peer
Jun 14 07:16:00 mywebsitestinks postfix/master[20636]: warning: process /usr/lib/postfix/trivial-rewrite pid 21451 exit status 1
Jun 14 07:16:00 mywebsitestinks postfix/master[20636]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Jun 14 07:16:00 mywebsitestinks postfix/smtpd[21443]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Jun 14 07:16:00 mywebsitestinks postfix/smtpd[21443]: warning: problem talking to service rewrite: Success
Jun 14 07:16:00 mywebsitestinks postfix/master[20636]: warning: process /usr/lib/postfix/trivial-rewrite pid 21453 exit status 1

That first part seems to be the root of the problem. MySQL is blocking connections to this database from localhost because of too many interrupted connection requests (according to the MySQL docs). The easiest solution would be to whitelist localhost somehow so that MySQL will never block it (no matter how many interrupted requests it gets from it), however, I can't find any documentation to suggest that this is even possible. I'd really like to know what is causing the problem.

Anyone had a similar problem?

falko 15th June 2006 16:06

Have a look here: http://www.howtoforge.com/forums/sho...22&postcount=9


All times are GMT +2. The time now is 10:15.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.