Philip Hazel wrote:
>
> 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.
No problem.
So when I want to use this config of queries.......
virtual_alias:
driver = aliasfile
domains = ${lookup mysql {MYSQL_DOMAINALIAS}{$value}}
search_type = mysql
queries = MYSQL_ALIAS : MYSQL_POSTMASTER
rewrite = false
user = mail
qualify_preserve_domain
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='*'
.....and I use a real existing alias everything is o.k. but
when I use " exim -bt not-a-real-alias@??? " I got
root@mx01:/etc/exim# exim -d4 -bt not-real
Exim version 3.22 debug level 4 uid=0 gid=0
Berkeley DB: Sleepycat Software: Berkeley DB 3.1.17: (July 31, 2000)
Caller is an admin user
Caller is a trusted user
not-real@??? in *@*? yes (*@*)
not-real@??? in *@*? yes (*@*)
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='*'
virtual_alias director deferred not-real
message: search_find deferred: MYSQL: query failed: You have an error in your
SQL syntax near 'LIKE '' at line 1
not-real@??? cannot be resolved at this time:
search_find deferred: MYSQL: query failed: You have an error in your SQL
syntax near 'LIKE '' at line1
Steffen
--
-------------------------------------------------
Steffen Herold IN-Systeme
steffen.herold@??? Curiestr. 2
70563 Stuttgart
