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@??? |
\--------------------------------------------------------------------/
