Package: dspam Version: 3.10.1+dfsg-5 Severity: normal Dear Maintainer,
After migrating my dspam database to a new PostgreSQL server, I'm seeing the following errors in PG's log (edited for readability): ERROR: invalid byte sequence for encoding "UTF8": 0xae: INSERT INTO dspam_signature_data (uid,signature,length,created_on,data) VALUES (1,E'4ed4de1c291545272412566',752,CURRENT_DATE,... ') which results in the insert being aborted. Although the message gets delivered succesfully, users cannot retrain on these messages because the signature doesn't get stored in the database. According to http://article.gmane.org/gmane.mail.spam.dspam.user/18022 http://sourceforge.net/tracker/?func=detail&atid=1126468&aid=3023888&group_id=250683 the workaround is to set standard_conforming_strings=off in postgresql.conf, which works for me but may not be possible for others (e.g. because of other databases in the same cluster). I can think of multiple solutions here: - unblock 3.10.2 because it is said to have a fix for this issue (not verified, I don't want to start mixing releases even before wheezy is released) - backport the 3.10.2 fix to wheezy's 3.10.1 - document this incompatibility+workaround in the release notes Naturally the latter would be my least favourite option :) Regards, Arno -- System Information: Debian Release: wheezy/sid APT prefers testing APT policy: (990, 'testing'), (900, 'stable'), (300, 'unstable'), (200, 'stable-updates') Architecture: i386 (i686) Kernel: Linux 3.2.0-4-686-pae (SMP w/1 CPU core) Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Shell: /bin/sh linked to /bin/dash Versions of packages dspam depends on: ii libc6 2.13-35 ii libdspam7 3.10.1+dfsg-5 ii libdspam7-drv-pgsql 3.10.1+dfsg-5 ii libpq5 9.1.6-1 ii lsb-base 4.1+Debian8 ii perl 5.14.2-15 Versions of packages dspam recommends: ii dspam-doc 3.10.1+dfsg-5 ii procmail 3.22-20 Versions of packages dspam suggests: pn clamav-daemon <none> pn dspam-webfrontend <none> -- Configuration Files: /etc/default/dspam changed [not included] /etc/dspam/default.prefs changed [not included] /etc/dspam/dspam.conf changed [not included] /etc/dspam/dspam.d/extlookup.conf [Errno 2] No such file or directory: u'/etc/dspam/dspam.d/extlookup.conf' -- no debconf information -- debsums errors found: debsums: changed file /usr/bin/dspam_maintenance (from dspam package) -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
