Re: [Exim] problem with queries option

Top Page
Delete this message
Reply to this message
Author: Philip Hazel
Date:  
To: Steffen Herold
CC: exim-users
Subject: Re: [Exim] problem with queries option
On Tue, 31 Jul 2001, Steffen Herold wrote:

> MYSQL_ALIAS = SELECT MYSQL_ALIASUSERFIELD FROM MYSQL_ALIASTABLE WHERE
> MYSQL_DOMAINFIELD LIKE '${quote_mysql:$domain}' AND MYSQL_ALIASFIELD
> LIKE '${quote_mysql:$local_part}'
>
> MYSQL_POSTMASTER = SELECT MYSQL_ALIASUSERFIELD FROM MYSQL_ALIASTABLE
> WHERE_DOMAINFIELD LIKE '${quote_mysql:$domain}' AND MYSQL_ALIASFIELD='*'


> virtual_alias director: mysql query=SELECT users FROM aliases WHERE domain LIKE
> 'in-systeme.com' AND alias LIKE 'not-real' : SELECT users FROM aliases
> WHERE_DOMAINFIELD LIKE ':in-systeme.com' AND alias='*'


Surely there's a mistake in your macro there? You shouldn't have
WHERE_DOMAINFIELD appearing in the query, should you?

-- 
Philip Hazel            University of Cambridge Computing Service,
ph10@???      Cambridge, England. Phone: +44 1223 334714.