Re: [Exim] problem with queries option

Etusivu
Poista viesti
Vastaa
Lähettäjä: Steffen Herold
Päiväys:  
Vastaanottaja: Philip Hazel, exim-users
Aihe: Re: [Exim] problem with queries option
Philip Hazel wrote:

> On Tue, 31 Jul 2001, Steffen Herold wrote:
>
> > I' ve read this before, but even when I use "::"
> >
> > MYSQL_ALIAS = SELECT MYSQL_ALIASUSERFIELD FROM MYSQL_ALIASTABLE WHERE
> > MYSQL_DOMAINFIELD LIKE '${quote_mysql:$domain}' AND MYSQL_ALIASFIELD
> > LIKE '${quote_mysql:$local_part}'
>
> But you haven't. There are just single colons there.
>
> --
> Philip Hazel            University of Cambridge Computing Service,
> ph10@???      Cambridge, England. Phone: +44 1223 334714.


Yes, I have tried this version too, but so every lookup will fail.


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='*'
virtual_alias director deferred failover
message: search_find deferred: MYSQL: query failed: You have an error in
your SQL syntax near ''' at line 1

failover@??? cannot be resolved at this time:
search_find deferred: MYSQL: query failed: You have an error in your SQL
syntax near ''' at line 1