<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN">
<html><body>
<pre>Hi everyone,<br /><br />So here is my config: postfix 2.6.6+spam+clam+dovecot<br /><br />1. spamassassin config: <br /><br /><strong>local.cf</strong><br />required_score 4.5<br /><br />clear_report_template<br />clear_unsafe_report_template<br /><br />use_bayes 1<br />bayes_auto_learn 1<br />use_dcc 1<br /><br />dcc_home /var/dcc<br />dcc_path /usr/local/bin/dccproc<br />dcc_timeout 15<br />use_pyzor 1<br /><br />razor_config /var/amavis/.razor/razor-agent.conf<br />bayes_path /var/amavis/.spamassassin/bayes<br />auto_whitelist_path /var/amavis/.spamassassin/auto-whitelist<br />lock_method flock<br /><br /><strong>sql.cf</strong><br />user_scores_dsn DBI:mysql:sql_prefs:localhost<br />user_scores_sql_password pass1<br />user_scores_sql_username user1 <br />user_scores_sql_custom_query SELECT preference, value from userpref where username = _USERNAME_ order by username ASC<br /><br />select * from userpref;<br />*************************** 1. row ***************************<br /> username: postmaster@domain-t1-ro<br />preference: blacklist_from<br /> value: user1@domain-t1.ro<br /> prefid: 1<br />*************************** 2. row ***************************<br /> username: postmaster@domain-t1.ro<br />preference: required_score<br /> value: 3.8<br /> prefid: 2<br /><br /><br /><br />snip.... amavisd.conf<br /><br />@sa_userconf_maps = (<br /> {<br /> '.domain-t1.ro' => 'sql:'<br /> }<br /> );<br />....<br />....<br />$sa_tag_level_deflt = undef;<br />$sa_tag2_level_deflt = 4.5;<br />$sa_kill_level_deflt = 10000;<br />$sa_dsn_cutoff_level = 9;<br />...<br />...<br />However .... looking in maillog::<br /><br />Aug 20 21:21:14 postdev spamd[27058]: spamd: result: Y 99 - ALL_TRUSTED,USER_IN_BLACKLIST scantime=1.7,size=804,user=postmaster@postfixdev.cz,uid=5002,required_score=3.8,rhost=localhost,raddr=127.0.0.1,rport=41187,mid=,autolearn=no<br />Aug 20 21:21:14 postdev postfix/pickup[30048]: EB1D486D95: uid=5002 from=<br />Aug 20 21:21:14 postdev postfix/cleanup[30187]: EB1D486D95: message-id=<br />Aug 20 21:21:14 postdev postfix/pipe[30189]: 22926849AB: to=, relay=spamfilter, delay=1.8, delays=0.07/0.01/0/1.8, dsn=2.0.0, status=sent (delivered via spamfilter service)<br />Aug 20 21:21:14 postdev postfix/qmgr[2208]: 22926849AB: removed<br />...<br />...<br />Aug 20 21:21:19 postdev postfix/smtp[30207]: EB1D486D95: to=, relay=127.0.0.1[127.0.0.1]:10024, delay=4.3, delays=0.05/0.01/0.01/4.3, dsn=2.0.0, status=sent (250 2.0.0 from MTA(smtp:[127.0.0.1]:10025): 250 2.0.0 Ok: queued as 3DF5B849AB)<br />Aug 20 21:21:19 postdev postfix/qmgr[2208]: EB1D486D95: removed<br />Aug 20 21:21:19 postdev postfix/pipe[30214]: 3DF5B849AB: to=, relay=dovecot, delay=0.09, delays=0.03/0.01/0/0.06, dsn=2.0.0, status=sent (delivered via dovecot service)<br />Aug 20 21:21:19 postdev postfix/qmgr[2208]: 3DF5B849AB: removed<br />.....<br /><br />So, the message is delivered, but here is the content of mail header::<br /><br /></pre>
<pre>X-Virus-Scanned: amavisd-new at domain-t1.ro<br />X-Spam-Flag: NO<br />X-Spam-Score: -0.001<br />X-Spam-Level:<br />X-Spam-Status: No, score=-0.001 required=<strong>4.5</strong> tests=[NO_RELAYS=-0.001]</pre>
<pre><br /><br />So, it looks like the default settings from local.cf are applied<br /><br /><br /></pre>
<div> </div>
</body></html>