Your message dated Mon, 06 Mar 2017 08:02:05 +1100 with message-id <[email protected]> and subject line Re: Bug#847311: amavisd-new: After the last Debian update Amavis does not read data type float from Mysql DB correctly. All fields are "0". has caused the Debian Bug report #847311, regarding amavisd-new: After the last Debian update Amavis does not read data type float from Mysql DB correctly. All fields are "0". to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 847311: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=847311 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---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
--- End Message ---
--- Begin Message ---Fixed version of libdbd-mysql-perl in Debian unstable and testing (Version 4.041-2 see #856064), so I think it should be OK to close this bug. -- Brian May <[email protected]>
--- End Message ---
