Hello George,
Wednesday, July 10, 2002, 5:32:35 PM, you wrote:
G> Hello Tamas,
G> Wednesday, July 10, 2002, 2:56:35 PM, you wrote:
TT>> On Wed, 10 Jul 2002, George wrote:
TT>> fishy.
TT>> if you use mysql on localhost, then why force all kinds of strange
TT>> options to exim (thus libmysqlclient), when the defaults will just be
TT>> fine for you ?
TT>> > MYSQL_AUTHSERVER=localhost
TT>> > MYSQL_AUTHPORT=3306
G> There are not options. There are variables.
TT>> this at the very least suggests you want it to connect over a tcp
TT>> socket
TT>> > mysql_servers =
TT>> > "MYSQL_AUTHSERVER::MYSQL_AUTHPORT/MYSQL_AUTHDB/MYSQL_AUTHUSER/MYSQL_AUTHPASS
TT>> can't comment that, never tried this way
G> I tried this without MYSQL_AUTHSERVER::MYSQL_AUTHPORT - no effect.
TT>> > MYSQL connection failed: Can't connect to local MySQL server through
TT>> > socket '/var/lib/mysql/mysql.sock' (13)
G> I tried something "crazy": hide mysql_servers="mysql -u MYSQL_AUTHUSER
G> -pMYSQL_AUTHPASSWORD"...
G> ...and the error message above was dissappeared, but I still have a
G> problem. :(
G> >[root@webserver libexec]# /usr/local/exim-3.36/bin/exim -bv -d9
G> >Exim version 3.36 debug level 9 uid=0 gid=0
G> >Berkeley DB: Sleepycat Software: Berkeley DB 3.2.9: (January 24, 2001)
G> >Caller is an admin user
G> >Caller is a trusted user
G> >originator: uid=0 gid=0 login=root name=root
G> >sender address = root@webserver
G> >Verifying: uid=0 gid=0 euid=111 egid=12
G> >> postmaster@mixanorganosi.gr
G> >>>>>>>>>>>>>>>>>>>>>>>>>
G> >Verifying postmaster@mixanorganosi.gr
G> >search_open: mysql "NULL"
G> >search_find: file="NULL"
G> > key="SELECT DISTINCT domain FROM auth WHERE domain='mixanorganosi.gr'" partial=-1
G> >LRU list:
G> >internal_search_find: file="NULL"
G> > type=mysql key="SELECT DISTINCT domain FROM auth WHERE domain='mixanorganosi.gr'"
G> >database lookup required for SELECT DISTINCT domain FROM auth WHERE domain='mixanorganosi.gr'
G> >MYSQL query: SELECT DISTINCT domain FROM auth WHERE domain='mixanorganosi.gr'
G> >lookup deferred
G> >mixanorganosi.gr in local_domains? lookup deferred
G> >postmaster@mixanorganosi.gr cannot be resolved at this time:
G> > local_domains lookup deferred
TT>> this clearly suggests exim (libmysqlclient, actually) wants to connect
TT>> over a unix domain socket.
TT>> > > mysql -u exim -peximpass
TT>> how does `mysql' connect ?
G> As you see - via socket.
TT>> do you have only one mysql installed ? server and library as well ? if
TT>> not, are you using the correct library ? does it know the correct
TT>> location for the socket ? what if you specify a socket-to-use by hand
TT>> (as for the syntax i'm afraid you'll have to dig that for yourself
TT>> from exim's *and* libmysqlclient's source) ?
G> I have built and installed MySQL from source package - mysql-3.23.49.tar.gz.
G> The location is correct.
G> Any idea ?
--
Best regards,
George mailto:george@mixanorganosi.gr