hey Ravanox thanks for the reply. yup it there.
ls -la /var/run/mysqld/ total 12 drwxr-xr-x 2 mysql root 4096 Dec 3 01:10 . drwxr-xr-x 12 root root 4096 Dec 3 01:10 .. -rw-rw---- 1 mysql mysql 5 Dec 3 01:10 mysqld.pid srwxrwxrwx 1 mysql mysql 0 Dec 3 01:10 mysqld.sock No socket is not commented. # * Basic Settings # user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock On Thu, Dec 3, 2009 at 4:10 PM, <[email protected]> wrote: > 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 > _______________________________________________ mlug mailing list [email protected] https://listes.koumbit.net/cgi-bin/mailman/listinfo/mlug-listserv.mlug.ca
