----- Forwarded message from Stephane Leclerc <sleclerc@???> -----
Envelope-to: mark@???
Delivery-date: Thu, 15 Nov 2001 21:19:45 +0000
Subject: Bug#119747: Problem with host_reject_recipients and mysql
Reply-To: Stephane Leclerc <sleclerc@???>, 119747@???
X-Debian-PR-Message: report 119747
X-Debian-PR-Package: exim
X-Debian-PR-Keywords:
User-Agent: Microsoft-Entourage/9.0.1.3108
Date: Thu, 15 Nov 2001 22:02:22 +0100
From: Stephane Leclerc <sleclerc@???>
To: Bug Debian <submit@???>
Delivered-To: submit@???
Package: exim
Version: 3.32-2
Severity: normal
Hi!
I've a problem with the host_reject_recipients and mysql. It's realy
difficult to know if its bug or not.
When using unqualified ip addresses with host_reject_recipients, the mysql
request is not done at all.
When using a qualified ip, the mysql request is done.
See below my examples:
On the smtp server, I don't want dns lookup.
I commented "host_lookup = *"
QUALIFIED
----------------------------------------------------------
I have this line in the exim.conf:
#host_reject_recipients = "+allow_unknown : mysql;MYSQL_REJECT_HOSTS"
I made a test using -bh 160.92.120.97
----------------------------------------------------------
sender_fullhost = [160.92.120.97]
sender_rcvhost = [160.92.120.97]
**** SMTP testing session as if from host 160.92.120.97
**** Not for real!
host in host_lookup? no (option unset)
host in host_reject? no (option unset)
looking up host name for 160.92.120.97
IP address lookup yielded net73.axime.com
sender_fullhost = net73.axime.com [160.92.120.97]
sender_rcvhost = net73.axime.com ([160.92.120.97])
search_open: mysql "NULL"
search_find: file="NULL"
key="SELECT rh_hosts FROM reject_hosts WHERE rh_hosts = 'net73.axime.com'"
partial=-1
LRU list:
internal_search_find: file="NULL"
type=mysql key="SELECT rh_hosts FROM reject_hosts WHERE rh_hosts =
'net73.axime.com'"
database lookup required for SELECT rh_hosts FROM reject_hosts WHERE
rh_hosts = 'net73.axime.com'
MYSQL query: SELECT rh_hosts FROM reject_hosts WHERE rh_hosts =
'net73.axime.com'
MYSQL new connection: host=localhost port=0 database=antispam user=antispam
password=12dfr23
MYSQL: no data found
lookup failed
host in host_reject_recipients? no (end of list)
host in rbl_hosts? yes (*)
----------------------------------------------------------
All is fine.
UNQUALIFIED
----------------------------------------------------------
I have this line in the exim.conf:
host_reject_recipients = "+allow_unknown : mysql;MYSQL_REJECT_HOSTS"
I made a test using -bh 62.4.76.141
----------------------------------------------------------
sender_fullhost = [62.4.76.141]
sender_rcvhost = [62.4.76.141]
**** SMTP testing session as if from host 62.4.76.141
**** Not for real!
host in host_lookup? no (option unset)
host in host_reject? no (option unset)
looking up host name for 62.4.76.141
IP address lookup failed
host in host_reject_recipients? no (failed to find host name or lookup
deferred)
host in rbl_hosts? yes (*)
----------------------------------------------------------
I have an address lookup (why!) AND I AM NOT GOING to the mysql request.
UNQUALIFIED WITHOUT +allow_unknown
----------------------------------------------------------
I have this line in the exim.conf:
host_reject_recipients = "mysql;MYSQL_REJECT_HOSTS"
I made a test using -bh 62.4.76.141
----------------------------------------------------------
host in host_lookup? no (option unset)
host in host_reject? no (option unset)
looking up host name for 62.4.76.141
IP address lookup failed
host in host_reject_recipients? yes (failed to find host name or lookup
deferred)
LOG: 1 MAIN REJECT
recipients from [62.4.76.141] refused (failed to find host name from IP
address)
host in sender_unqualified_hosts? no (option unset)
host in receiver_unqualified_hosts? no (option unset)
host in helo_verify? no (option unset)
host in helo_accept_junk_hosts? no (option unset)
----------------------------------------------------------
I have an address lookup, the test is ok.
..........................................................
. Linux - Debian - php4 - Apache - MySQL - Infogerance .
. email: info@??? - http://www.actionweb.fr .
. Tel: (0)141 906 100 - Fax: (0)141 906 101 .
..........................................................
----- End forwarded message -----
