Re: [Exim] Exim_MySQL problem

Pàgina inicial
Delete this message
Reply to this message
Autor: Tamas TEVESZ
Data:  
A: exim-users
Assumpte: Re: [Exim] Exim_MySQL problem
On Wed, 10 Jul 2002, George wrote:

fishy.

if you use mysql on localhost, then why force all kinds of strange
options to exim (thus libmysqlclient), when the defaults will just be
fine for you ?

> MYSQL_AUTHSERVER=localhost
> MYSQL_AUTHPORT=3306


this at the very least suggests you want it to connect over a tcp
socket

> mysql_servers =
> "MYSQL_AUTHSERVER::MYSQL_AUTHPORT/MYSQL_AUTHDB/MYSQL_AUTHUSER/MYSQL_AUTHPASS


can't comment that, never tried this way

 >     MYSQL connection failed: Can't connect to local MySQL server through
 > socket '/var/lib/mysql/mysql.sock' (13)


this clearly suggests exim (libmysqlclient, actually) wants to connect
over a unix domain socket.

 >                 > mysql -u exim -peximpass


how does `mysql' connect ?

do you have only one mysql installed ? server and library as well ? if
not, are you using the correct library ? does it know the correct
location for the socket ? what if you specify a socket-to-use by hand
(as for the syntax i'm afraid you'll have to dig that for yourself
from exim's *and* libmysqlclient's source) ?

what if you just skip the host/port/socketpath part altogether ? it
goes like:

hide mysql_servers = "/MYSQL_AUTHDB/MYSQL_AUTHUSER/MYSQL_AUTHPASS"

you'd better not be lazy and *do* write the quotation marks. further
info on as to why is in libmysqlclient's source.

--
[-]