> the reason for my format is for wildcards and to simplify the layout
>
> in my database I would have
>
> address table
> --------------------
> 1.2.3.%
> or %.domain.com
>
> The first works out as
> select reason from rejected where '1.2.3.4' like address;
> The second is
> select reason from rejected where 'mail.remote.com' like address;
Realy great. I've implemented your query for testing.
Why do you use $key instead of $sender_host_address or $sender_host_name?
What do you think of that:
MYSQL_REJECT_HOSTS_IP = SELECT rh_hosts FROM reject_hosts \
WHERE rh_hosts = '$sender_host_address'
MYSQL_REJECT_HOSTS_NAME = SELECT rh_hosts FROM reject_hosts \
WHERE rh_hosts = '$sender_host_name'
host_reject_recipients = "net-mysql;MYSQL_REJECT_HOSTS_IP: \
+allow_unknown:mysql;MYSQL_REJECT_HOSTS_NAME"
Is it equivalent to the system with $key?
Stef...
..........................................................
. Linux - Debian - php4 - Apache - MySQL - Infogerance .
. email: info@??? - http://www.actionweb.fr .
. Tel: (0)141 906 100 - Fax: (0)141 906 101 .
..........................................................
..........................................................
. Linux - Debian - php4 - Apache - MySQL - Infogerance .
. email: info@??? - http://www.actionweb.fr .
. Tel: (0)141 906 100 - Fax: (0)141 906 101 .
..........................................................
