Tried that :
MYSQL_RELAY = SELECT ip FROM relay_ip WHERE ip="${sender_host_address}"
host_accept_relay = 10.10.10.0/24 : mysql;MYSQL_RELAY
The table actually looks like :
mysql> select * from relay_ip;
+-----------------+
| ip |
+-----------------+
| 159.148.69.0/24 |
| 159.148.69.1 |
| 159.148.69.2 |
+-----------------+
3 rows in set (0.03 sec)
mysql>
And the test :
su-2.05a# /usr/local/sbin/exim -bh 159.148.69.2
**** SMTP testing session as if from host 159.148.69.2
**** Not for real!
>>> host in host_lookup? no (option unset)
>>> host in host_reject? no (end of list)
>>> host in host_reject_recipients? no (option unset)
>>> host in auth_hosts? no (option unset)
>>> host in auth_over_tls_hosts? no (option unset)
>>> host in tls_hosts? no (option unset)
>>> 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)
220 ns2.spektrs.lv ESMTP Exim 3.34 #1 Thu, 09 May 2002 08:57:54 +0000
helo there
>>> there in local_domains? no (end of list)
250 ns2.spektrs.lv Hello there [159.148.69.2]
mail from: alex@???
>>> alex@??? in sender_reject? no (option unset)
>>> alex@??? in sender_reject_recipients? no (option unset)
250 <alex@???> is syntactically correct
rcpt to: admin@???
>>> zeus.ru in local_domains? no (end of list)
>>> zeus.ru in relay_domains? no (end of list)
>>> looking up host name for 159.148.69.2
>>> IP address lookup failed
>>> host in host_accept_relay? no (failed to find host name or lookup
deferred)
550 relaying to <admin@???> prohibited by administrator (failed to find
host name from IP address)
LOG: refused relay (host) to <admin@???> from <alex@???> H=(there)
[159.148.69.2] (failed to find host name from IP address)
----- Original Message -----
From: Torsten Mueller <torsten@???>
To: Alex Vinogradoff <alex@???>
Cc: <exim-users@???>
Sent: Thursday, May 09, 2002 5:49 AM
Subject: Re: [Exim] Exim 3.34+MySQL host_accept_relay
> Hey,
>
> for me works:
>
> MYSQL_RELAY = SELECT ip FROM relay_ip WHERE ip="${sender_host_address}"
> host_accept_relay = localhost:mysql;MYSQL_RELAY
>
> (exim 3.35)
>
> Greetings Torsten
>
