if you read the manual $key is automatically created for queries. And
it was just a natural choice for me. I know in my first query $key will
always be an IP Address, and in my second query it will always be a
domain, unless there is no reverse where it would fail the second one.
On 19 Nov 2001 at 21:39, Stephane Leclerc wrote:
Date sent: Mon, 19 Nov 2001 21:39:25 +0100
Subject: Re: [Exim] [sleclerc@???: Bug#119747: Problem
with
host_reject_recipients and mysql]
From: Stephane Leclerc <sleclerc@???>
To: Jason Robertson <jason@???>
Copies to: Exim Users Mailing List <exim-users@???>
> > 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 .
> ..........................................................
>
>
--
Jason Robertson
Network/Security Analyst
jason@???
http://www.ifuture.com, http://www.astroadvice.com,
http://www.astroeast.com
Also if you are looking for an employee, I may be available soon, so
feel free to
contact me for my resume.
