Hi, I have installed ispconfig3 on a Debian Lenny box. I followed the howto on this site and everything else seems to work correctly except receiving emails for configured domains. The only change i made was to set Postfix (main.cf) to listen on all interfaces instead of loopback, or should it be on loopback? I have alot of errors in in my mail.log and mail.err below is a sample of some of the errors. mail.log Code: Nov 30 11:35:06 zork postfix/error[13013]: warning: connect to mysql server *.*.108.144: Can't connect to MySQL server on '209.4$ Nov 30 11:35:06 zork postfix/error[13013]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup p$ Nov 30 11:35:07 zork postfix/qmgr[12936]: 982274A00875: to=<[email protected]>, orig_to=<root>, relay=none, delay=889720, de$ Nov 30 11:38:16 zork postfix/qmgr[12936]: warning: connect to mysql server *.*.108.144: Can't connect to MySQL server on '209.44$ Nov 30 11:38:16 zork postfix/qmgr[12936]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup pr$ Nov 30 11:38:17 zork postfix/master[23520]: warning: process /usr/lib/postfix/qmgr pid 12936 exit status 1
hi just an update I have solved most of my problems except for one. Turns out i had my external ip configured in Postfix, Amavis and in ISPconfig in Server Config. I configured Postfix and Amavis with localhost. Also my hosts file was all wrong. So if anyone knows what this error is ? Code: Dec 1 14:33:59 zork postfix/trivial-rewrite[2067]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Hey Falko thanks for reply. all the cf files have the same credentials and host. Is there suppose to be something in this field in the db ? here is the content of that file. user = ispconfig password = ******** dbname = dbispconfig table = mail_transport select_field = domain where_field = domain additional_conditions = and active = 'y' and server_id = 1 hosts = localhost
here is the output of mail.log , cant figure this out?! Code: Dec 2 15:46:05 zork postfix/trivial-rewrite[9685]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Dec 2 15:46:05 zork postfix/trivial-rewrite[9685]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem Dec 2 15:46:05 zork postfix/trivial-rewrite[9687]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Dec 2 15:46:05 zork postfix/trivial-rewrite[9687]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem Dec 2 15:46:06 zork postfix/smtpd[8654]: warning: problem talking to service rewrite: Success Dec 2 15:46:06 zork postfix/smtpd[8655]: warning: problem talking to service rewrite: Connection reset by peer Dec 2 15:46:06 zork postfix/master[7421]: warning: process /usr/lib/postfix/trivial-rewrite pid 9685 exit status 1 Dec 2 15:46:06 zork postfix/master[7421]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling Dec 2 15:46:06 zork postfix/smtpd[7438]: warning: problem talking to service rewrite: Success Dec 2 15:46:06 zork postfix/master[7421]: warning: process /usr/lib/postfix/trivial-rewrite pid 9687 exit status 1 Dec 2 15:46:06 zork postfix/smtpd[7443]: warning: problem talking to service rewrite: Connection reset by peer
still trying to figure why i have a "table lookup problem". The cf file looks fine. table exists, has anyone ever had this error ? postfix/trivial-rewrite[2067]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
really ? of course its running. I solved the issue. The socket error is because of the chroot environment. Opening 127.0.0.1 in Mysql to the login id and changing host = 127.0.0.1 in all CF files aswell. So dont use "localhost" in your configs. all is working normally now.
