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=27)
-   -   BIG Problem Postfix issue (http://www.howtoforge.com/forums/showthread.php?t=39862)

admins 4th October 2009 17:43

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

till 5th October 2009 11:41

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.

Ovidiu 11th November 2009 15:19

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?

till 11th November 2009 15:20

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.

Ovidiu 11th November 2009 15:32

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...

till 11th November 2009 15:33

Anything in the mysql or mail error logs?

Ovidiu 11th November 2009 15:47

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

till 11th November 2009 15:51

These errors seem to be related to the mysql problem:

http://www.mail-archive.com/amavis-u.../msg06448.html

Ovidiu 11th November 2009 15:56

kind of. the max connection usage rarely reaches the limit: http://h1550830.stratoserver.net/mun...net.html#Mysql

Ovidiu 12th November 2009 11:10

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...


All times are GMT +2. The time now is 12:37.

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