Can you find "/var/run/mysqld/mysqld.sock" when mysqld is running?
And is the socket commented in your mysql config file?(my.cnf?) A connection through a socket is different than a connection using the loopback if I remember correctly. -- Ravnox On Thu, 3 Dec 2009 11:47:05 -0500 Denny Stamos <[email protected]> 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 _______________________________________________ mlug mailing list [email protected] https://listes.koumbit.net/cgi-bin/mailman/listinfo/mlug-listserv.mlug.ca
