Hello,
Grateful for any help on the following problem.
I am seeing the following in my exim (4.34) main log file...
2004-11-10 12:50:08 SMTP connection from [65.105.133.5]:1178 (TCP/IP
connection count = 2)
2004-11-10 12:50:38 ident connection to 65.105.133.5 timed out
2004-11-10 12:50:39 H=mugsy.emf0.com [65.105.133.5]:1178 Warning: Warn:
65.105.133.5 by bl.spamcop.net (127.0.0.2)
m^@^@^@^C select distinct domain_name from DOMAIN where domain_name =
'domain.com' and host_email = 1 2004-11-10 12:50:39 failed to expand
"@:${lookup mysql{ select distinct domain_name from DOMAIN where
domain_name = '${quote_mysql:$domain}' and host_email = 1 }{$value}}"
while checking a list: lookup of " select distinct domain_name from DOMAIN
where domain_name = 'domain.com' and host_email = 1 " gave DEFER:
MYSQL: query failed: Lost connection to MySQL server during query
2004-11-10 12:50:39 H=mugsy.emf0.com [65.105.133.5]:1178
F=<L9402968426.133708.2@???> temporarily rejected RCPT
<user@???>: MYSQL: query failed: Lost connection to MySQL server
during query
2004-11-10 12:50:39 H=mugsy.emf0.com [65.105.133.5]:1178 incomplete
transaction (RSET) from <L9402968426.133708.2@???>
2004-11-10 12:50:40 SMTP connection from mugsy.emf0.com [65.105.133.5]:1178
closed by QUIT
The panic log gets the following...
2004-11-10 12:50:39 failed to expand "@:${lookup mysql{ select distinct
domain_name from DOMAIN where domain_name = '${quote_mysql:$domain}' and
host_email = 1 }{$value}}" while checking a list: lookup of " select
distinct domain_name from DOMAIN where domain_name = 'domain.com' and
host_email = 1 " gave DEFER: MYSQL: query failed: Lost connection to MySQL
server during query
The reject log gets the following...
2004-11-10 12:50:39 H=mugsy.emf0.com [65.105.133.5]:1178
F=<L9402968426.133708.2@???> temporarily rejected RCPT
<user@???>: MYSQL: query failed: Lost connection to MySQL server
during query
The errors are repeatedly occurring as the sending host retries, approx once
per minute. Emails to the same address from other senders are fine. Manual
execution of the query against the mysql database is also fine.
Can anyone shed some light on what is happening here? Are the m^@^@^@^C
characters causing the problem? Are they coming from the sender somehow?
Is the 'incomplete transaction' warning a clue that they are sending
something bad via the SMTP dialogue, and if so is there an easy way to get
exim to log the details?
Thanks,
Steve
