--- Begin Message ---
- To: Debian Bug Tracking System <submit@bugs.debian.org>
- Subject: dspam: incompatible with wheezy's postgresql version
- From: aelschuring@hotmail.com
- Date: Sun, 02 Dec 2012 15:53:13 +0100
- Message-id: <20121202145313.31686.79008.reportbug@gnome.loos.site>
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)
--- End Message ---
--- Begin Message ---
- To: Julien Cristau <jcristau@debian.org>, 701922-done@bugs.debian.org
- Cc: Thomas Preud'homme <robotux@debian.org>, 694942@bugs.debian.org
- Subject: Re: Bug#701922: cloning 694942, reassign -1 to release-notes
- From: "Adam D. Barratt" <adam@adam-barratt.org.uk>
- Date: Wed, 24 Apr 2013 20:37:32 +0100
- Message-id: <1366832252.18536.13.camel@jacala.jungle.funky-badger.org>
- In-reply-to: <20130302143623.GS5761@radis.cristau.org>
- References: <1362078139-1944-bts-robotux@debian.org> <20130302135038.GQ5761@radis.cristau.org> <20130302135319.GR5761@radis.cristau.org> <20130302143623.GS5761@radis.cristau.org>
On Sat, 2013-03-02 at 15:36 +0100, Julien Cristau wrote:
> On Sat, Mar 2, 2013 at 14:53:19 +0100, Julien Cristau wrote:
>
> > Still seems like something that should be fixed instead of documenting
> > that we're shipping non-working stuff.
> >
> By which I guess I mean something like this:
[...]
> Not even build-tested, so there's some work left, but hopefully you get
> the idea.
As far as I can tell, this was fixed in dspam so there's no need for a
release note. If I'm missing something, please apply relevant
cluebats. :-)
Regards,
Adam
--- End Message ---