[sam] using sam imp spamassasin????

[Ryan]

Mark Fink <mark_fink <at> web.de> writes:


> > 
> I removed the order clause an it seems to work ))
> amavisd.conf:
> # $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';
> $sql_select_policy = 'SELECT *,users.id FROM users,policy'.
>    ' WHERE (users.policy_id=policy.id) AND (users.email IN (%k))';
> #
> # The SQL select clause to check sender in per-recipient whitelist/blacklist
> # The first SELECT argument '?' will be users.id from recipient SQL lookup,
> # the %k will be sender addresses (e.g. full address, domain only, 
> catchall).
> # $sql_select_white_black_list = 'SELECT wb FROM wblist,mailaddr'.
> #     ' WHERE (wblist.rid=?) AND (wblist.sid=mailaddr.id)'.
> #     '   AND (mailaddr.email IN (%k))'.
> #   ' ORDER BY mailaddr.priority DESC';
> $sql_select_white_black_list = 'SELECT wb FROM wblist,mailaddr'.
>      ' WHERE (wblist.rid=?) AND (wblist.sid=mailaddr.id)'.
>      '   AND (mailaddr.email IN (%k))';
> 

Hi Mark,

It seems you managed to get Spamassassin and Clamav working with Horde 3.x based
on your above posts.

Are you still using it and are there any new pieces of information one might
need to know to get it working properly in a production environment?

Regards,

Ryan