Re: [Exim] cannot connect to mysql socket

Top Page
Delete this message
Reply to this message
Author: Peter Bowyer
Date:  
To: exim-users
Subject: Re: [Exim] cannot connect to mysql socket
Harisha K.R. <harishkr@???> wrote:
> Hi
> in Exim 4.3 problem cannot to mysql error in /var/log/exim/main.log
>
> 2004-07-09 18:16:54 1BiuUC-0000Up-PH failed to expand "${lookup
> mysql{SELECT DISTINCT CONCAT(domain, ' : ') FROM domains WHERE type =
> 'local' AND enabled = '1'}}" while checking a list: lookup of "SELECT
> DISTINCT CONCAT(domain, ' : ') FROM domains WHERE type = 'local' AND
> enabled = '1'" gave DEFER: MYSQL connection failed: Can't connect to
> local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


Is the MySQL server running? Is that the correct path for the socket it's
listening on? Can you connect to the MySQL server with the mysql client?

I'd stake a small sum on the answer to at least one of those questions being
'no'.

Peter