I have mailserver configure using dovecot+postfix+mysql and it was runnig fine in the server(Ubuntu Server). But during last week it stopped working correctly. It doesn't send email. When I try to
telnet localhost smtp I'm connecting successfully but when I do
mail from:<email@example.com> and hit Enter it hangs on, nothing happen.
/var/log/mail.log file I've found out that probably(99%) the problem is on postfix when it is trying to connect to MySQL server. If you see the log file given below you can see that it says
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2).
Nov 14 21:54:36 ns1 dovecot: dovecot: Killed with signal 15 (by pid=7731 uid=0 code=kill) Nov 14 21:54:36 ns1 dovecot: Dovecot v1.2.9 starting up (core dumps disabled) Nov 14 21:54:36 ns1 dovecot: auth-worker(default): mysql: Connected to localhost (mailserver) Nov 14 21:54:44 ns1 postfix/postfix-script: refreshing the Postfix mail system Nov 14 21:54:44 ns1 postfix/master: reload -- version 2.7.0, configuration /etc/postfix Nov 14 21:54:52 ns1 postfix/trivial-rewrite: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Nov 14 21:54:52 ns1 postfix/trivial-rewrite: fatal: mysql:/etc/postfix/mysql-virtual-alias-maps.cf(0,lock|fold_fix): table lookup problem Nov 14 21:54:53 ns1 postfix/master: warning: process /usr/lib/postfix/trivial-rewrite pid 7759 exit status 1 Nov 14 21:54:53 ns1 postfix/cleanup: warning: problem talking to service rewrite: Connection reset by peer Nov 14 21:54:53 ns1 postfix/master: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling Nov 14 21:54:53 ns1 postfix/smtpd: warning: problem talking to service rewrite: Success
netstat -ln | grep mysql and it returns
unix 2 [ ACC ] STREAM LISTENING 5817 /var/run/mysqld/mysqld.sock.
The content of
/etc/postfix/mysql-virtual-alias-maps.cf file is here:
user = stevejobs password = apple hosts = localhost dbname = mailserver query = SELECT destination FROM virtual_aliases WHERE source='%s'
Here I tried to change
hosts = 127.0.0.1 but it says
warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (110)
So, I am lost and don't know where else to change in order to solve the problem. Any help would be appreciated highly.
When I do netstat -na I see that mysql is not bind neither to localhost nor to 127.0.0.1. Could it be the problem also?
bakhtiyor@ns1:~$ netstat -na | grep 3306 tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN