#1  
Old 15th June 2006, 06:16
jasutton jasutton is offline
Junior Member
 
Join Date: Jun 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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?
Reply With Quote
Sponsored Links
  #2  
Old 15th June 2006, 16:06
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
 
Default

Have a look here: http://www.howtoforge.com/forums/sho...22&postcount=9
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
postfix problems with smtp linkdeb Server Operation 13 15th March 2014 17:58
postfix - MySQL connection problem epo Installation/Configuration 7 4th August 2006 20:49
Autoreply problem using Virtual Users And Domains With Postfix, Courier And MySQL triak HOWTO-Related Questions 1 19th May 2006 15:25
Problem with Virtual Users And Domains With Postfix, Courier And MySQL Howto fenix Server Operation 4 11th March 2006 02:53
Another Problem: Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP bluegrass Installation/Configuration 24 8th March 2006 01:41


All times are GMT +2. The time now is 16:17.


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