amavisd-new 2.7.0 load sql userpref but not apply
Florin, Portase
portase.florin at medianetork.ro
Sat Aug 20 21:37:47 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.amavis.org/pipermail/amavis-users/attachments/20110820/34a13da2/attachment.html>
More information about the amavis-users
mailing list