<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hello,<BR>
<BR>
I've added to:<BR>
<FONT size=2 face="Courier New">/etc/amavis/conf.d/50-user</FONT><BR>
<BR>
these lines:<BR>
<FONT style="FONT-SIZE: 10pt" size=2 face="Courier New">@lookup_sql_dsn = (['DBI:mysql:database=maildb;host=127.0.0.1', 'mail', 'mailPASS']);<BR>$sql_select_policy = 'SELECT spam_tag_level, spam_tag2_level, spam_kill_level, spam_subject_tag FROM users WHERE id IN (%k)';<BR>$sql_select_white_black_list = 'SELECT wb FROM wblist WHERE (user=?) AND (address IN (%k)) AND enabled = 1';</FONT><BR>
<FONT size=2 face="Courier New"></FONT> <BR>
<FONT size=2 face="Courier New">Per user spam* are being fetched and applied - I can see query in MySQL log and each user has different spam levels. </FONT><BR>
<FONT size=2 face="Courier New">I can not get white and blacklist working. There is no single error in amavis log and MySQL log doesnt contain any entry with wblist query.</FONT><BR>
<FONT size=2 face="Courier New"></FONT> <BR>
<FONT size=2 face="Courier New">In wblist table i have 2 sample records:</FONT><BR>
<FONT size=2 face="Courier New">mysql> SELECT * FROM wblist;<BR>+------------------+------------------+----+---------+<BR>| user | address | wb | enabled |<BR>+------------------+------------------+----+---------+<BR>| <A href="mailto:user1@gugunet.pl">user1@gugunet.pl</A> | <A href="mailto:user2@gugunet.pl">user2@gugunet.pl</A> | B | 1 |<BR>| <A href="mailto:user2@gugunet.pl">user2@gugunet.pl</A> | <A href="mailto:user1@gugunet.pl">user1@gugunet.pl</A> | B | 1 |<BR>+------------------+------------------+----+---------+<BR>2 rows in set (0.00 sec)</FONT><BR>
<FONT size=2 face="Courier New"></FONT> <BR>
<FONT size=2 face="Courier New">So, communication between both users should be blocked, but is not - all mails are delivered. </FONT><BR> </div></body>
</html>