[Exim] Exim 4.24 + Mysql 4.0.13: mysql lookup doesnt seem to…

Top Page
Delete this message
Reply to this message
Author: Yann MARQUE
Date:  
To: exim-users
Subject: [Exim] Exim 4.24 + Mysql 4.0.13: mysql lookup doesnt seem to work.
Hi,

Im currently using Exim 4.24 and mySQL 4.0.13. Exim has been compiled with
mysql support so everything should works fine... but for an unknown reason,
exim child stops or dies each time it has to use mysql to get data...

Please, does anyone have information regarding to this problem?
Thank you,
Yann

here is a dump of my debug screen:

16:53:48  2480 SMTP>> 220 mail.user-domain.com ESMTP Exim 4.24 Tue, 02 Dec
2003 16:53:48 +0100
16:53:48  2480 Process 2480 is ready for new message
16:53:48  2480 smtp_setup_msg entered
16:53:48  2480 SMTP<< EHLO user-domain.com
16:53:48  2480 sender_fullhost =
aaubervilliers-101-2-1-209.w193-252.abo.wanadoo.fr (soprec-corp.com)
[193.252.44.209]
16:53:48  2480 sender_rcvhost =
aaubervilliers-101-2-1-209.w193-252.abo.wanadoo.fr ([193.252.44.209]
helo=soprec-corp.com)
16:53:48  2480 set_process_info:  2480 handling incoming connection from
aaubervilliers-101-2-1-209.w193-252.abo.wanadoo.fr (user-dormain.com)
[193.252.44.209]
16:53:48  2480 host in pipelining_advertise_hosts? yes (matched "*")
16:53:48  2480 SMTP>> 250-mail.user-domain.com Hello
aaubervilliers-101-2-1-209.w193-252.abo.wanadoo.fr [193.252.44.209]
16:53:48  2480 250-SIZE 52428800
16:53:48  2480 250-PIPELINING
16:53:48  2480 250 HELP
16:53:48  2480 SMTP<< MAIL FROM:<user@???>
16:53:48  2480 SMTP>> 250 OK
16:53:49  2480 SMTP<< RCPT TO:<me@???>
16:53:49  2480 using ACL "acl_check_rcpt"
16:53:49  2480 processing "accept"
16:53:49  2480 check domains = +local_domains
16:53:49  2480 expanding: SELECT domain FROM domains
16:53:49  2480    result: SELECT domain FROM domains
16:53:49  2480 search_open: mysql "NULL"
16:53:49  2480 search_find: file="NULL"
16:53:49  2480   key="SELECT domain FROM domains" partial=-1 affix=NULL
starflags=0
16:53:49  2480 LRU list:
16:53:49  2480 internal_search_find: file="NULL"
16:53:49  2480   type=mysql key="SELECT domain FROM domains"
16:53:49  2480 database lookup required for SELECT domain FROM domains
16:53:49  2480 MYSQL query: SELECT domain FROM domains
16:53:49  2480 MYSQL new connection: host=xx.xx.xx.xx port=0 socket=NULL
database=exim user=exim
16:53:49  2480 lookup yielded: user-dormain.com
16:53:49  2480 expanding: $value
16:53:49  2480    result: user-dormain.com
16:53:49  2480 expanding: @ : ${lookup mysql {SELECT domain FROM
domains}{$value}}
16:53:49  2480    result: @ : user-dormain.com
16:53:49  2480 user-dormain.com in "@ : user-dormain.com"? yes (matched
"user-dormain.com")
16:53:49  2480 user-dormain.com in "+local_domains"? yes (matched
"+local_domains")
16:53:49  2480 accept: condition test succeeded
16:53:49  2480 SMTP>> 250 Accepted
16:53:49  2480 SMTP<< DATA
16:53:49  2480 SMTP>> 354 Enter message, ending with "." on a line by itself
16:53:49  2480 search_tidyup called
16:53:49  2480 close MYSQL connection: xx.xx.xx.xx/exim/exim
16:53:49  2479 child 2480 ended: status=0xb
16:53:49  2479 0 SMTP accept processes now running
16:53:49  2479 Listening...