amavisd load sql userpref but not apply

Florin, Portase portase.florin at medianetork.ro
Sat Aug 20 22:16:45 CEST 2011


Hi everyone,

So here is my config: postfix 2.6.8+spam+clam+dovecot

1. spamassassin config:

local.cf
required_score 4.5

clear_report_template
clear_unsafe_report_template

use_bayes 1
bayes_auto_learn 1
use_dcc 1

dcc_home /var/dcc
dcc_path /usr/local/bin/dccproc
dcc_timeout 15
use_pyzor 1

razor_config /var/amavis/.razor/razor-agent.conf
bayes_path /var/amavis/.spamassassin/bayes
auto_whitelist_path /var/amavis/.spamassassin/auto-whitelist
lock_method flock

sql.cf
user_scores_dsn            DBI:mysql:sql_prefs:localhost
user_scores_sql_password    pass1
user_scores_sql_username    user1
user_scores_sql_custom_query    SELECT preference, value from userpref 
where username = _USERNAME_ order by username ASC

select * from userpref;
*************************** 1. row ***************************
   username: postmaster at domain-t1-ro
preference: blacklist_from
      value: user1 at domain-t1.ro
     prefid: 1
*************************** 2. row ***************************
   username: postmaster at domain-t1.ro
preference: required_score
      value: 3.8
     prefid: 2



snip.... amavisd.conf

@sa_userconf_maps = (
       {
          '.domain-t1.ro' => 'sql:'
       }
     );
....
....
$sa_tag_level_deflt  = undef;
$sa_tag2_level_deflt = 4.5;
$sa_kill_level_deflt = 10000;
$sa_dsn_cutoff_level = 9;
...
...
However .... looking in maillog::

Aug 20 21:21:14 postdev spamd[27058]: spamd: result: Y 99 - 
ALL_TRUSTED,USER_IN_BLACKLIST 
scantime=1.7,size=804,user=postmaster at postfixdev.cz,uid=5002,required_score=3.8,rhost=localhost,raddr=127.0.0.1,rport=41187,mid=,autolearn=no
Aug 20 21:21:14 postdev postfix/pickup[30048]: EB1D486D95: uid=5002 
from=
Aug 20 21:21:14 postdev postfix/cleanup[30187]: EB1D486D95: message-id=
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)
Aug 20 21:21:14 postdev postfix/qmgr[2208]: 22926849AB: removed
...
...
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)
Aug 20 21:21:19 postdev postfix/qmgr[2208]: EB1D486D95: removed
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)
Aug 20 21:21:19 postdev postfix/qmgr[2208]: 3DF5B849AB: removed
.....

So, the message is delivered, but here is the content of mail header::

X-Virus-Scanned: amavisd-new at domain-t1.ro
X-Spam-Flag: NO
X-Spam-Score: -0.001
X-Spam-Level:
X-Spam-Status: No, score=-0.001 required=4.5 tests=[NO_RELAYS=-0.001]



So, it looks like the default settings from local.cf are applied



More information about the amavis-users mailing list