[Pkg-dspam-misc] Bug#731093: libdspam7-drv-pgsql: dspam logs showing invalid byte sequence

[Craig Small]

Package: libdspam7-drv-pgsql
Version: 3.10.2+dfsg-12
Severity: normal

Hi,
  First of all, there is a problem with the permissions on
/var/log/dspam. I think they need to be dspam group writeable. My mail
logs were filling up with unable to write to the logfile before I fixed
that.

Second, there is a problem with the encoding when sending signatures
into the postgresql backend.  I don't get it for every email but it is
quite a few:

[12/02/2013 07:04:42] 21058: ERROR:  invalid byte sequence for encoding "UTF8": 0xcf 0x37
[12/02/2013 07:13:45] 22856: ERROR:  invalid byte sequence for encoding "UTF8": 0xca 0x37
[12/02/2013 07:33:28] 26369: ERROR:  invalid byte sequence for encoding "UTF8": 0xb7
[12/02/2013 07:39:34] 27253: ERROR:  invalid byte sequence for encoding "UTF8": 0xf7 0x36 0x34 0x34

I take the offending string and put it into python and try to decode it
and get a similiar message. If I take one of the signatures out of the
database and do the same trick in python, it does decode correctly.
So it seems that dspam is not feeding correct UTF-8 into the database
and the database is having a whinge about it.

 - Craig

-- System Information:
Debian Release: jessie/sid
  APT prefers unstable
  APT policy: (500, 'unstable')
Architecture: amd64 (x86_64)

Kernel: Linux 3.11-1-amd64 (SMP w/6 CPU cores)
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages libdspam7-drv-pgsql depends on:
ii  dbconfig-common                            1.8.47+nmu1
ii  debconf [debconf-2.0]                      1.5.52
ii  libc6                                      2.17-96
ii  libdspam7                                  3.10.2+dfsg-12
ii  libpq5                                     9.3.1-1
ii  postgresql-client-9.3 [postgresql-client]  9.3.1-1
ii  ucf                                        3.0027+nmu1

Versions of packages libdspam7-drv-pgsql recommends:
ii  postgresql  9.3+150

libdspam7-drv-pgsql suggests no packages.

-- debconf information excluded