Package: amavisd-new
Version: 1:2.10.1-4
Severity: grave
Justification: causes non-serious data loss
Dear Maintainer,
With the latest update of Debian packages in Scratch, Amavis started to reject
more than 50% of all emails as spam.
>From Amavis debuging logs, all the MySQL fields that are of type "float" does
>not get its correct values from database anymore, but are all "0". Varchar,
>int and tinyints are still OK.
With spam_kill_level 0, Amavis behaves that all emails with spam score >= 0 are
rejected as sure spam. No quarantine, no spam tagging.
I guess it must be something with data type conversion, because SQL SELECT that
Amavis sends to Mysql (observed from Amavis.log and Mysql.log) returns all
values and all field names fine.
That is verified from Amavis debug log, where no "lookup_sql_field, no such
fields" are logged (except spam_tag3_level, sa_username, sa_userconf and
forward_method, same as before the bug).
-- System Information:
Debian Release: stretch/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 4.7.0-1-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages amavisd-new depends on:
ii adduser 3.115
ii debconf [debconf-2.0] 1.5.59
ii file 1:5.29-1
ii libarchive-zip-perl 1.59-1
ii libberkeleydb-perl 0.55-1+b2
ii libconvert-tnef-perl 0.18-1
ii libconvert-uulib-perl 1:1.4~dfsg-1+b5
pn libdigest-md5-perl <none>
ii libio-stringy-perl 2.111-2
ii libmail-dkim-perl 0.40-1
ii libmailtools-perl 2.13-1
pn libmime-base64-perl <none>
ii libmime-tools-perl 5.508-1
ii libnet-libidn-perl 0.12.ds-2+b3
ii libnet-server-perl 2.008-3
ii libperl5.22 [libtime-hires-perl] 5.22.2-3
ii libperl5.24 [libtime-hires-perl] 5.24.1~rc4-1
ii libunix-syslog-perl 1.1-2+b6
ii pax 1:20161104-2
ii perl 5.24.1~rc4-1
ii perl-modules-5.22 [libarchive-tar-perl] 5.22.2-3
ii perl-modules-5.24 [libarchive-tar-perl] 5.24.1~rc4-1
Versions of packages amavisd-new recommends:
pn altermime <none>
ii libnet-patricia-perl 1.22-1+b3
ii ripole 0.2.0+20081101.0215-3
Versions of packages amavisd-new suggests:
ii apt-listchanges 3.6
ii arj 3.10.22-15
ii cabextract 1.6-1
ii clamav 0.99.2+dfsg-4
ii clamav-daemon 0.99.2+dfsg-4
ii cpio 2.11+dfsg-6
pn dspam <none>
pn lhasa <none>
ii libauthen-sasl-perl 2.1600-1
ii libdbi-perl 1.636-1+b1
ii libmail-dkim-perl 0.40-1
ii libnet-ldap-perl 1:0.6500+dfsg-1
pn libsnmp-perl <none>
pn libzeromq-perl <none>
ii lzop 1.03-4
ii nomarch 1.4-3
pn p7zip <none>
pn rpm <none>
ii spamassassin 3.4.1-6
pn unrar <none>
-- Configuration Files:
/etc/amavis/conf.d/50-user changed:
use strict;
@bypass_virus_checks_maps = (
\%bypass_virus_checks, \@bypass_virus_checks_acl, \$bypass_virus_checks_re);
@bypass_spam_checks_maps = (
\%bypass_spam_checks, \@bypass_spam_checks_acl, \$bypass_spam_checks_re);
@lookup_sql_dsn =
( ['DBI:mysql:database=dbispconfig;host=127.0.0.1;port=3306', 'ispconfig',
'PASSWD was here'] );
$sql_select_policy =
'SELECT *,spamfilter_users.id'.
' FROM spamfilter_users LEFT JOIN spamfilter_policy ON
spamfilter_users.policy_id=spamfilter_policy.id'.
' WHERE spamfilter_users.email IN (%k) ORDER BY spamfilter_users.priority
DESC';
$sql_select_white_black_list = 'SELECT wb FROM spamfilter_wblist'.
' WHERE (spamfilter_wblist.rid=?) AND (spamfilter_wblist.email IN (%k)) AND
(spamfilter_wblist.active="y")' .
' ORDER BY spamfilter_wblist.priority DESC';
$final_virus_destiny = D_BOUNCE;
$final_spam_destiny = D_DISCARD;
$final_banned_destiny = D_BOUNCE;
$final_bad_header_destiny = D_PASS;
$sa_spam_subject_tag = '***SPAM*** ';
$sa_tag_level_deflt = 20.0; # add spam info headers if at, or above that level
$sa_tag2_level_deflt = 60.0; # add 'spam detected' headers at that level
$sa_kill_level_deflt = 60.0; # triggers spam evasive actions
$sa_dsn_cutoff_level = 100; # spam level beyond which a DSN is not sent
$virus_admin = undef;
$spam_admin = undef;
$DO_SYSLOG = 0;
$LOGFILE = "/var/log/amavis/amavis.log"; # (defaults to empty, no log)
$log_level = 5; # (defaults to 0)
$max_servers = 1;
$max_requests = 1;
$enable_db = 0;
$enable_global_cache = 0;
$inet_socket_port = [10024,10026];
$forward_method = 'smtp:127.0.0.1:*';
$notify_method = 'smtp:127.0.0.1:*';
$interface_policy{'10026'} = 'ORIGINATING';
$policy_bank{'ORIGINATING'} = {
originating => 1,
smtpd_discard_ehlo_keywords => ['8BITMIME'],
};
@mynetworks = qw(0.0.0.0/8 127.0.0.0/8 10.0.0.0/8 172.16.0.0/12 192.168.0.0/16
[::1] [FE80::]/10 [FEC0::]/10);
@inet_acl = qw( 127.0.0.1 [::1] 192.168.0.0/16 );
$enable_dkim_verification = 1;
$enable_dkim_signing = 1; # load DKIM signing code
$signed_header_fields{'received'} = 0; # turn off signing of Received
@dkim_signature_options_bysender_maps = (
{ '.' => { ttl => 21*24*3600, c => 'relaxed/simple' } } );
1; # insure a defined return
-- no debconf information
