Well after some ideas from the irc guys, I fianlly got my setup
working. Instead of the usual query:
#$sql_select_policy = 'SELECT *,users.id FROM users,policy'.
# ' WHERE (users.policy_id=policy.id) AND (users.email IN (%k))'.
# ' ORDER BY users.priority DESC';
I am replacing the value of spam_quarantine_to to the [EMAIL PROTECTED] of
the destination, basically changing the value of the column into:
#IF(ISNULL(spam_quarantine_to),NULL,CONCAT("spam",SUBSTRING_INDEX(email,"@",
2))) as spam_quarantine_to
That way it works like a charm, thank you all !
2008/1/30, Joan <[EMAIL PROTECTED]>:
> Hello,
>
> I've the usual amavisd-new+spamassassin+SQL setup
> I would like to have a "per domain" spam address so I could set
> spam_quarantine_to to send the spam to [EMAIL PROTECTED]
>
> Is that possible, any other ways to accomplish the purpose?
>
> Thanks in advance
>
> Joan
>
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
