Re: [exim] domainlist mysql lookup not working

Top Page
Delete this message
Reply to this message
Author: Craig Jackson
Date:  
To: Craig Whitmore, exim-users
Subject: Re: [exim] domainlist mysql lookup not working

>
> ----- Original Message -----
> From: "Craig Jackson" <CJackson@???>
> To: <exim-users@???>
> Sent: Thursday, October 25, 2007 7:42 AM
> Subject: [exim] domainlist mysql lookup not working
>
>
> >I have created a named list populated by a mysql lookup in
> the general
> > section like this:
> >
> > BLOCK_REGEX = SELECT regex_domain FROM whitelist WHERE
> regex_domain !=
> > '' AND block = '-1'
> >
>
> BLOCK_REGEX = SELECT DISTINCT regex_domain FROM whitelist
> WHERE regex_domain
> !='' AND block ='-1';
>
> Thanks
>



I got it working like this:

domainlist dom_regex = ${sg {${lookup mysql{BLOCK_REGEX}}}{\n}{:}}


I know there's an easier way, but so be it.

Thanks, Craig, for your response.