<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<blockquote type="cite"
cite="mid:545b4dac-aa73-0489-dcfe-71ac534fd06e@marmedia.net.pl"><font
size="2">I read it and unfortunately I still don't know how to
set it up.<br>
@lookup_sql_dsn i have set for vmail database.<br>
Please write how to make amavis read "required_score" from
database "spamassassin" from table "userpref" and if it finds a
user let it use individual spam threshold "value".</font></blockquote>
<font size="2">Something for you to play around with:</font>
<blockquote type="cite"><font size="2">root@752bab637002:~# echo
SELECT * FROM userpref | mysql spamassassin<br>
username preference value prefid<br>
<a class="moz-txt-link-abbreviated" href="mailto:demo@example.com">demo@example.com</a> required_score 4.4 3<br>
</font></blockquote>
<font size="2">and</font><br>
<blockquote type="cite"><font size="2">root@752bab637002:~# cat
/etc/amavis/conf.d/60-demo <br>
@spam_kill_level_maps = {<br>
'<a class="moz-txt-link-abbreviated" href="mailto:demo2@example.com">demo2@example.com</a>' => 42,<br>
'.' => 303,<br>
};<br>
<br>
%sql_clause = (<br>
sel_policy => 'SELECT value AS spam_kill_level FROM
userpref WHERE preference = "required_score" AND username = %a',<br>
);<br>
</font></blockquote>
yield<br>
<blockquote type="cite">X-Spam-Status: Yes, score=999.998 tag=2
tag2=6.31 kill=4.4 tests=[GTUBE=1000,<br>
</blockquote>
for <a class="moz-txt-link-abbreviated" href="mailto:demo@example.com">demo@example.com</a>,<br>
<br>
<blockquote type="cite">X-Spam-Status: Yes, score=999.998 tag=2
tag2=6.31 kill=303 tests=[GTUBE=1000,<br>
</blockquote>
for <a class="moz-txt-link-abbreviated" href="mailto:other@example.com">other@example.com</a>, and<br>
<br>
<blockquote type="cite">X-Spam-Status: Yes, score=999.998 tag=2
tag2=6.31 kill=42 tests=[GTUBE=1000,<br>
</blockquote>
for <a class="moz-txt-link-abbreviated" href="mailto:demo2@example.com">demo2@example.com</a>.<br>
<br>
</body>
</html>