[Exim] quote_mysql in require_files

Pàgina inicial
Delete this message
Reply to this message
Autor: marte
Data:  
A: exim-users
Assumpte: [Exim] quote_mysql in require_files
Hi !

I tried to use the following to move SPAM-tagged Mails to another folder:

spammove_director:
driver = accept
condition = "${if eq{$h_X-Spam-Flag:}{YES} {1}{0}}"
require_files = /var/spool/virtual_mail/${lookup mysql {MYSQL_Q_BOXNAME}{$value}}/.SPAM/maildirfolder
transport = virtual_local_mdSPAM_delivery

with

MYSQL_Q_BOXNAME=SELECT box FROM MYSQL_EMAILTABLE WHERE domain='${quote_mysql:$domain}'
AND local_part='${quote_mysql:$local_part}'

Now I get the following error message:

2003-10-18 15:41:50 1AArKY-0001f5-TT == marte@??? R=spammove_director defer (-1): failed to expand "/var/spool/virtual_mail/${lookup mysql {SELECT box FROM emailtable WHERE domain='${quote_mysql" for require_files: "${quote_mysql" is not a known operator (or a } is missing in a variable reference)

I use the same SQL-query in my normal (non-Spam) transport - it works fine there.
Has anyone any hint / solution ?

- marte
--
/--------------------------------------------------------------------\
| Martin Tettke                 | Tel.:   + 49 - 30 - 742 22 94      |
| Schillerstr. 78B              | FAX :   + 49 - 30 - 743 768 47     |
| 12305 Berlin                  | EMAIL:  marte@???        |

\--------------------------------------------------------------------/