amavisd-new 2.7.0 load sql userpref but not apply

[Florin, Portase]

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>