hi,
i´m using amavis with a virtual domain system with postfix and cyrus-imapd
on fedora core 4. all the necessary data is stored in a mysql database.
i´m using amavis to scan mails with clamav and spamassassin. it is
configured to mark spam mails in the subject. at first i had the problem
that my spam mails havn´t been marked as spam. i added these lines to my
amavisd.conf:
@lookup_sql_dsn =
( ['DBI:mysql:database=mail;host=127.0.0.1;port=3306', 'user', 'pw'] );
$sql_select_policy = 'SELECT "Y" as local FROM domain WHERE
CONCAT("@",domain_name) IN (%k)';
what does the Y mean? there is no column named Y in that table. in the howto
where i got this from there is no such column in that table too. sorry, i´m
not that familiar with perl. after adding these lines all the test mail with
gtube-string was marked as spam. so everything worked fine.
my problem is that i want to use per-recipient white/black lists. in the
sample conf-file i saw these lines:
$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_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';
can i have more than one select policy? what if i just add the
sql_select_white_black_list line and just the select_policy from above? does
this work with virtual domains? what is the correct amavis-setting for
per-recipient white/black lists with virtual domains?
please help.
thank you
regards
philippe
--
I am using the free version of SPAMfighter for private users.
It has removed 3467 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
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/
