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
