amavisd-new 2.7.0 load sql userpref but not apply
Florin, Portase
portase.florin at medianetork.ro
Sat Aug 20 21:49:31 CEST 2011
Hi everyone,
So here is my config: postfix 2.6.6+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