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

[Thomas Preud'homme]

Control: clone 731093 -1
Control: reassign -1 dspam
Control: retitle -1 "Incorrect permission on /var/log/dspam"

Le lundi 2 décembre 2013, 09:04:13 Craig Small a écrit :
> 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.

Duplicating this bug report to keep track of this separate issue.

> 
> 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

Did you already have libdspam7-drv-pgsql installed prior to the last upload 
and this error appeared after the upgrade? A change was made to the SQL query 
in the last upload so if you just encountered this error I guess it would be 
the cause. On the other hand, the change was just about marking strings as 
escape strings and shouldn't affect the encoding.

If you just installed libdspam7-drv-pgsql, could you try installing previous 
dspam version from snapshot.debian.org and see if you still have this error?

> 
> 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.

Ok, thanks for the test.

> 
>  - Craig

Best regards,

Thomas