Ravanox / Gord Yes I can login with this account to localhost.
this also worked. # mysql -u myuser -p --socket=/var/run/mysqld/mysqld.sock Denny On Fri, Dec 4, 2009 at 12:31 AM, Gord Fisch Arboreta <[email protected]> wrote: > Hi Denny; > > It appears the problem is the connection as the first error is > > 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) > > If the socket seems ok, have you confirmed the access to mysql? Does this > work? > > #mysql -u myuser -pmypass > > or > > #mysql -u myuser -pmypass --socket=/var/run/mysqld/mysqld.sock > > > Gord > > Denny Stamos wrote: > > 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 > > > > _______________________________________________ > 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
