Re: [Exim] Exim4 and MySQL lookups in rewrite gives unknown …

Top Page
Delete this message
Reply to this message
Author: Richard F Rebel
Date:  
To: exim-users
Subject: Re: [Exim] Exim4 and MySQL lookups in rewrite gives unknown rewrite flag character 'm']
Hello Philip,

^(.*)@(.*)$     ${lookup mysql{select dst_uri from redirects where
uri_scheme_path='${quote_mysql:$0@$1}'}{"$value"}{"$0@$1"}}  ST


returns with:

unknown rewrite flag character 'm' (could be missing quotes round
replacement item)

Maybe I am just being dense, Oh, wait I see. You know what, I
mis-copied the data below, sorry, I never put the pattern and the
replacement in quotes, I used:

^(.*)@(.*)$     "${lookup mysql{select dst_uri from redirects where
uri_scheme_path='${quote_mysql:$0@$1}'}{$value}{$0@$1}}"  ST


Which when I run tests I get:

failed to expand "^(.*)@(.*)$" while checking for SMTP rewriting: $ not
followed by letter, digit, or {

Hope this is more clear.

Thanks,

Richard.

On Friday, March 15, 2002, at 03:37 AM, Philip Hazel wrote:

> On Thu, 14 Mar 2002, Richard F. Rebel wrote:
>
>> When I put the replacment in quotes:
>>
>> "^(.*)@(.*)$     ${lookup mysql{select dst_uri from redirects where
>> uri_scheme_path='${quote_mysql:$0@$1}'}{$value}{$0@$1}}"      ST

>
> But you didn't put the replacement in quotes. You put the pattern and
> the replacement in quotes.
>
> Try putting just the replacement in quotes.
>
>> Actually when I type in exact verbatim entries in the exim book, I get
>> errors as well.
>
> Thanks for pointing that out. I'll take a look (I've started work on the
> 2nd edition).
>
> --
> Philip Hazel            University of Cambridge Computing Service,
> ph10@???      Cambridge, England. Phone: +44 1223 334714.

>
>
> --
>
> ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim
> details at http://www.exim.org/ ##
>