Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 4th October 2009, 18:43
admins admins is offline
Senior Member
 
Join Date: Apr 2009
Location: Switzerland
Posts: 210
Thanks: 6
Thanked 6 Times in 3 Posts
Default BIG Problem Postfix issue

Hi all

I've the following in the log:
Code:
Oct 4 17:33:22 websrv1 postfix/smtpd[24341]: warning: problem talking to service rewrite: Success
Oct 4 17:33:22 websrv1 postfix/smtpd[24346]: warning: problem talking to service rewrite: Success
Oct 4 17:33:22 websrv1 postfix/master[21531]: warning: process /usr/lib/postfix/trivial-rewrite pid 25847 exit status 1
Oct 4 17:33:22 websrv1 postfix/master[21531]: warning: process /usr/lib/postfix/trivial-rewrite pid 25848 exit status 1
Oct 4 17:34:17 websrv1 amavis[21591]: (21591-01) (!)rw_loop: leaving rw loop, no progress
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26416]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26416]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26417]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26417]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26418]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26418]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26419]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26419]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26420]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26420]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26421]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26421]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26422]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26422]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26423]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26423]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26424]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26424]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26425]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26425]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26426]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26426]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26427]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26427]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Oct 4 17:34:22 websrv1 postfix/trivial-rewrite[26428]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Where could I fix this problem?

thanks
admins
Reply With Quote
Sponsored Links
  #2  
Old 5th October 2009, 12:41
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,733
Thanks: 840
Thanked 5,597 Times in 4,407 Posts
Default

Please cjeck if you are able to login to the mysql database with the mysql login details that can be found in the /etc/postfix/mysql* files.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 11th November 2009, 16:19
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,267
Thanks: 83
Thanked 25 Times in 21 Posts
Default

got the same problem but just from time to time so the credentials are fine. could be mysql is overloaded?
already upped the max connections, any other advice?
Reply With Quote
The Following User Says Thank You to Ovidiu For This Useful Post:
AbannyvabVask (20th December 2013)
  #4  
Old 11th November 2009, 16:20
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,733
Thanks: 840
Thanked 5,597 Times in 4,407 Posts
Default

Please make sure that you set also the max user connections to a higher value and not just the max connactions as all services connect with the same username.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 11th November 2009, 16:32
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,267
Thanks: 83
Thanked 25 Times in 21 Posts
Default

hmmmm I upped the max connections. should be good now.
the max_user_connections is on default=0 meaning unlimited...

well, I guess there is not much more I can do...
Reply With Quote
  #6  
Old 11th November 2009, 16:33
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,733
Thanks: 840
Thanked 5,597 Times in 4,407 Posts
Default

Anything in the mysql or mail error logs?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 11th November 2009, 16:47
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,267
Thanks: 83
Thanked 25 Times in 21 Posts
Default

todays mysql logs are empty.

mail.err shows this:

Code:
h1550830:/var/log# tail -f /var/log/mail.err
Nov 11 15:44:50 h1550830 amavis[24189]: (24189-01) (!!)TROUBLE in process_request: Can't create directory /var/lib/amavis/tmp/amavis-20091111T154450-24189: Too many links at /usr/sbin/amavisd-new line 5081, <GEN33> line 4.
Nov 11 15:44:50 h1550830 amavis[24191]: (24191-01) (!!)TROUBLE in process_request: Can't create directory /var/lib/amavis/tmp/amavis-20091111T154450-24191: Too many links at /usr/sbin/amavisd-new line 5081, <GEN33> line 4.
Nov 11 15:44:51 h1550830 amavis[24192]: (24192-01) (!!)TROUBLE in process_request: Can't create directory /var/lib/amavis/tmp/amavis-20091111T154451-24192: Too many links at /usr/sbin/amavisd-new line 5081, <GEN33> line 4.
Nov 11 15:44:52 h1550830 amavis[24193]: (24193-01) (!!)TROUBLE in process_request: Can't create directory /var/lib/amavis/tmp/amavis-20091111T154452-24193: Too many links at /usr/sbin/amavisd-new line 5081, <GEN33> line 4.
Nov 11 15:44:52 h1550830 amavis[24196]: (24196-01) (!!)TROUBLE in process_request: Can't create directory /var/lib/amavis/tmp/amavis-20091111T154452-24196: Too many links at /usr/sbin/amavisd-new line 5081, <GEN33> line 4.
Nov 11 15:44:53 h1550830 amavis[24198]: (24198-01) (!!)TROUBLE in process_request: Can't create directory /var/lib/amavis/tmp/amavis-20091111T154453-24198: Too many links at /usr/sbin/amavisd-new line 5081, <GEN33> line 4.
Nov 11 15:44:55 h1550830 amavis[24199]: (24199-01) (!!)TROUBLE in process_request: Can't create directory /var/lib/amavis/tmp/amavis-20091111T154455-24199: Too many links at /usr/sbin/amavisd-new line 5081, <GEN33> line 4.
Nov 11 15:44:56 h1550830 amavis[24200]: (24200-01) (!!)TROUBLE in process_request: Can't create directory /var/lib/amavis/tmp/amavis-20091111T154456-24200: Too many links at /usr/sbin/amavisd-new line 5081, <GEN33> line 4.
Nov 11 15:44:56 h1550830 amavis[24202]: (24202-01) (!!)TROUBLE in process_request: Can't create directory /var/lib/amavis/tmp/amavis-20091111T154456-24202: Too many links at /usr/sbin/amavisd-new line 5081, <GEN33> line 4.
Nov 11 15:44:56 h1550830 amavis[24203]: (24203-01) (!!)TROUBLE in process_request: Can't create directory /var/lib/amavis/tmp/amavis-20091111T154456-24203: Too many links at /usr/sbin/amavisd-new line 5081, <GEN33> line 4.
otherwise nothing remotely interesting...

if I chekc the mailqueue I see some messages with this error:

Code:
delivery temporarily suspended: lost connection with 127.0.0.1[127.0.0.1] while sending RCPT TO
Code:
delivery temporarily suspended: connect to 127.0.0.1[127.0.0.1]:10024: Connection refused
Reply With Quote
  #8  
Old 11th November 2009, 16:51
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,733
Thanks: 840
Thanked 5,597 Times in 4,407 Posts
Default

These errors seem to be related to the mysql problem:

http://www.mail-archive.com/amavis-u.../msg06448.html
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #9  
Old 11th November 2009, 16:56
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,267
Thanks: 83
Thanked 25 Times in 21 Posts
Default

kind of. the max connection usage rarely reaches the limit: http://h1550830.stratoserver.net/mun...net.html#Mysql
Reply With Quote
The Following User Says Thank You to Ovidiu For This Useful Post:
AbannyvabVask (20th December 2013)
  #10  
Old 12th November 2009, 12:10
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,267
Thanks: 83
Thanked 25 Times in 21 Posts
 
Default

I have used this command to count hte number of files:

Quote:
h1550830:/var/lib/amavis/tmp# find . -type f | wc -l
97663
it was 110.000 then I used this command to delete everything older than 3 days:

Quote:
h1550830:/var/lib/amavis/tmp# find /var/lib/amavis/tmp * -type f -mtime +3 -exec rm -f {} \;
because 3 days ago I moved a client with a fairly huge newsletter with lots of dead recipients. We are currently in the process of cleaning it up via the bounces.

Anything else I can do in the meantime?
Oh, btw. the tmp fodler seems to be fully cluttered with te,porary spamassassin files...

Last edited by Ovidiu; 12th November 2009 at 12:27.
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 18:58
error: File /root/rpm/SOURCES/postfix-2.3.3-vda.patch: No such file or directory mxtdn Installation/Configuration 1 25th July 2009 10:20
421 Unexpected failure Lizard King Installation/Configuration 20 7th July 2009 21:43
Virtual users... Ubuntu 8.04 spaceuser HOWTO-Related Questions 12 19th June 2008 09:04
big problem with postfix pierremoreau Installation/Configuration 2 23rd October 2007 18:39


All times are GMT +2. The time now is 05:29.


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