Re: [Exim] problem with queries option

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: Philip Hazel
Ημερομηνία:  
Προς: Steffen Herold
Υ/ο: exim-users
Αντικείμενο: 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 ':domain.com' AND alias LIKE ':failover' : SELECT users FROM aliases
> WHERE_DOMAINFIELD LIKE ':domain.com' AND alias='*'


Ah. Silly me. I told you a lie before. Of course the "queries" options
is expanded *before* it is interpreted as a list of queries when you use
it in an aliasfile director. So you don't need those :: after all. Sorry
about that.

I had to go and read my own manual to remember exactly how it happens.

So, what is the equivalent output when you just have single colons? What
does it say in that debugging output line and error message?

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