yes its chrooted, i think that might be the issue. I am going to permisssion 127.0.0.1 in the db for the user and change my configs in cf files from localhost to 127.0.0.1.
On Fri, Dec 4, 2009 at 12:16 PM, David <[email protected]> wrote: > > Denny Stamos wrote: >> Hi gang! >> I have installed ispconfig3 on a Debian Lenny box following the guide >> on howtoforge. I am having an issue with Postfix and Mysql and >> I do not know where to look any more. So i am hopeing some people here >> have had expericence with postfix/mysql setups. >> >> its concerning the "table lookup problem" and "Can't connect to local >> MySQL server through socket '/var/run/mysqld/mysqld.sock" >> >> the user defined in the "mysql-virtual_relaydomains.cf" works and has >> access to the database and is also authorized to connect to localhost. >> >> Is my table lookup problem because it cant connect to Mysql ? >> >> here is the messages from my mail.log >> >> 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 >> >> thanks >> Denny >> _______________________________________________ >> mlug mailing list >> [email protected] >> https://listes.koumbit.net/cgi-bin/mailman/listinfo/mlug-listserv.mlug.ca >> > > > Does Postfix have access to the socket? (aka file permissions?, > chrooted? etc) > > David > > _______________________________________________ > mlug mailing list > [email protected] > https://listes.koumbit.net/cgi-bin/mailman/listinfo/mlug-listserv.mlug.ca > _______________________________________________ mlug mailing list [email protected] https://listes.koumbit.net/cgi-bin/mailman/listinfo/mlug-listserv.mlug.ca
