Thread: Major recovery
View Single Post
  #5  
Old 1st August 2011, 14:20
Toucan Toucan is offline
Senior Member
 
Join Date: Dec 2009
Posts: 479
Thanks: 78
Thanked 40 Times in 34 Posts
Default

having restarted mysql the control panel has now gone green, but squirrel mail still won't send mail. it just hangs.

The mail.log looks like this now, still reporting connection problems to mysql i think:
Code:
Aug  1 13:04:31 badbison imapd: LOGIN, user=test@testdom.com, ip=[::ffff:127.0.0.1], port=[39633], protocol=IMAP
Aug  1 13:04:31 badbison imapd: LOGOUT, user=test@testdom.com, ip=[::ffff:127.0.0.1], headers=0, body=0, rcvd=119, sent=900, time=0
Aug  1 13:04:40 badbison postfix/trivial-rewrite[3464]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug  1 13:04:40 badbison postfix/trivial-rewrite[3464]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug  1 13:04:41 badbison postfix/smtpd[3436]: warning: problem talking to service rewrite: Success
Aug  1 13:04:41 badbison postfix/master[3237]: warning: process /usr/lib/postfix/trivial-rewrite pid 3464 exit status 1
Aug  1 13:04:41 badbison postfix/master[3237]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Aug  1 13:04:41 badbison postfix/smtpd[3465]: connect from localhost.localdomain[127.0.0.1]
Aug  1 13:05:03 badbison imapd: Connection, ip=[::ffff:127.0.0.1]
Aug  1 13:05:03 badbison imapd: Disconnected, ip=[::ffff:127.0.0.1], time=0
Aug  1 13:05:03 badbison pop3d: Connection, ip=[::ffff:127.0.0.1]
Aug  1 13:05:03 badbison pop3d: Disconnected, ip=[::ffff:127.0.0.1]
Aug  1 13:05:03 badbison postfix/smtpd[3499]: connect from localhost.localdomain[127.0.0.1]
Aug  1 13:05:03 badbison postfix/smtpd[3499]: lost connection after CONNECT from localhost.localdomain[127.0.0.1]
Aug  1 13:05:03 badbison postfix/smtpd[3499]: disconnect from localhost.localdomain[127.0.0.1]
Aug  1 13:05:41 badbison postfix/trivial-rewrite[3531]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug  1 13:05:41 badbison postfix/trivial-rewrite[3531]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug  1 13:05:42 badbison postfix/smtpd[3436]: warning: problem talking to service rewrite: Success
Aug  1 13:05:42 badbison postfix/smtpd[3465]: warning: problem talking to service rewrite: Connection reset by peer
Aug  1 13:05:42 badbison postfix/master[3237]: warning: process /usr/lib/postfix/trivial-rewrite pid 3531 exit status 1
Aug  1 13:05:43 badbison postfix/trivial-rewrite[3532]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug  1 13:05:43 badbison postfix/trivial-rewrite[3532]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug  1 13:05:44 badbison postfix/smtpd[3436]: warning: problem talking to service rewrite: Success
Aug  1 13:05:44 badbison postfix/smtpd[3465]: warning: problem talking to service rewrite: Connection reset by peer
Aug  1 13:05:44 badbison postfix/master[3237]: warning: process /usr/lib/postfix/trivial-rewrite pid 3532 exit status 1
Aug  1 13:05:44 badbison postfix/master[3237]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Aug  1 13:06:44 badbison postfix/trivial-rewrite[3547]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug  1 13:06:44 badbison postfix/trivial-rewrite[3547]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug  1 13:06:45 badbison postfix/smtpd[3436]: warning: problem talking to service rewrite: Success
Aug  1 13:06:45 badbison postfix/smtpd[3465]: warning: problem talking to service rewrite: Connection reset by peer
Aug  1 13:06:45 badbison postfix/master[3237]: warning: process /usr/lib/postfix/trivial-rewrite pid 3547 exit status 1
Aug  1 13:06:45 badbison postfix/master[3237]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Aug  1 13:07:45 badbison postfix/trivial-rewrite[3598]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug  1 13:07:45 badbison postfix/trivial-rewrite[3598]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug  1 13:07:46 badbison postfix/smtpd[3436]: warning: problem talking to service rewrite: Success
Aug  1 13:07:46 badbison postfix/smtpd[3465]: warning: problem talking to service rewrite: Connection reset by peer
Aug  1 13:07:46 badbison postfix/master[3237]: warning: process /usr/lib/postfix/trivial-rewrite pid 3598 exit status 1
Aug  1 13:07:46 badbison postfix/master[3237]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Aug  1 13:08:46 badbison postfix/trivial-rewrite[3613]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug  1 13:08:46 badbison postfix/trivial-rewrite[3613]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug  1 13:08:47 badbison postfix/smtpd[3436]: warning: problem talking to service rewrite: Success
Aug  1 13:08:47 badbison postfix/smtpd[3465]: warning: problem talking to service rewrite: Connection reset by peer
Aug  1 13:08:47 badbison postfix/master[3237]: warning: process /usr/lib/postfix/trivial-rewrite pid 3613 exit status 1
Aug  1 13:08:47 badbison postfix/master[3237]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Aug  1 13:09:37 badbison postfix/smtpd[3640]: connect from localhost.localdomain[127.0.0.1]
Aug  1 13:09:47 badbison postfix/trivial-rewrite[3641]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug  1 13:09:47 badbison postfix/trivial-rewrite[3641]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug  1 13:09:47 badbison postfix/trivial-rewrite[3642]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug  1 13:09:47 badbison postfix/trivial-rewrite[3642]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug  1 13:09:48 badbison postfix/smtpd[3436]: warning: problem talking to service rewrite: Success
Aug  1 13:09:48 badbison postfix/smtpd[3465]: warning: problem talking to service rewrite: Connection reset by peer
Aug  1 13:09:48 badbison postfix/master[3237]: warning: process /usr/lib/postfix/trivial-rewrite pid 3641 exit status 1
Aug  1 13:09:48 badbison postfix/master[3237]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Aug  1 13:09:48 badbison postfix/master[3237]: warning: process /usr/lib/postfix/trivial-rewrite pid 3642 exit status 1
Aug  1 13:10:03 badbison pop3d: Connection, ip=[::ffff:127.0.0.1]
Aug  1 13:10:03 badbison imapd: Connection, ip=[::ffff:127.0.0.1]
Aug  1 13:10:03 badbison pop3d: Disconnected, ip=[::ffff:127.0.0.1]
Aug  1 13:10:03 badbison imapd: Disconnected, ip=[::ffff:127.0.0.1], time=0
Aug  1 13:10:03 badbison postfix/smtpd[3671]: connect from localhost.localdomain[127.0.0.1]
Aug  1 13:10:03 badbison postfix/smtpd[3671]: lost connection after CONNECT from localhost.localdomain[127.0.0.1]
Aug  1 13:10:03 badbison postfix/smtpd[3671]: disconnect from localhost.localdomain[127.0.0.1]
Aug  1 13:10:48 badbison postfix/trivial-rewrite[3695]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug  1 13:10:48 badbison postfix/trivial-rewrite[3695]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug  1 13:10:48 badbison postfix/trivial-rewrite[3696]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug  1 13:10:48 badbison postfix/trivial-rewrite[3696]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug  1 13:10:49 badbison postfix/smtpd[3436]: warning: problem talking to service rewrite: Success
Aug  1 13:10:49 badbison postfix/smtpd[3465]: warning: problem talking to service rewrite: Connection reset by peer
Aug  1 13:10:49 badbison postfix/smtpd[3640]: warning: problem talking to service rewrite: Success
Aug  1 13:10:49 badbison postfix/master[3237]: warning: process /usr/lib/postfix/trivial-rewrite pid 3695 exit status 1
Aug  1 13:10:49 badbison postfix/master[3237]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Aug  1 13:10:49 badbison postfix/master[3237]: warning: process /usr/lib/postfix/trivial-rewrite pid 3696 exit status 1



netstat -tap | grep mysql
output
Code:
tcp        0      0 *:mysql                 *:*                     LISTEN      2627/mysqld
tcp        0      0 badbison.badbison:54964 badbison.co.uk:mysql    TIME_WAIT   -
badbison.badbison.com is the slave and badbison.co.uk is the master.
Reply With Quote