[Pkg-dspam-misc] Bug#694942: dspam: incompatible with wheezy's postgresql version

[aelschuring at hotmail.com]

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)