Re: [exim] domainlist mysql lookup not working

トップ ページ
このメッセージを削除
このメッセージに返信
著者: Craig Jackson
日付:  
To: Craig Whitmore, exim-users
題目: 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.