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

[Thomas Preud'homme]

Le jeudi 5 décembre 2013, 19:11:26 Adrien Clerc a écrit :
> Hi,
> 
> I got exactly the same behavior since upgrade to last package. Before
> that, I got something like this in /var/log/postgresql/:
> 
> 2013-12-05 18:58:49 CET ATTENTION: utilisation non standard de \\ dans
> une chaîne littérale au caractère 127
> 2013-12-05 18:58:49 CET ASTUCE : Utilisez la syntaxe de chaîne
> d'échappement pour les antislashs, c'est-à-dire E'\\'.
> 2013-12-05 18:58:49 CET LOG: instruction : INSERT INTO
> dspam_signature_data (uid,signature,length,created_on,data) VALUES
> (4,'52a0bed916707
> 9777898567',4392,CURRENT_DATE,'\\x0000d0 [truncated…]
> 
> (Basicaly, it say to use escape sequence for backslashes, instead of \\x
> inside the value)

Yes it was already reported and that is one of the bug that the latest version 
was supposed to fix. I'll see what I did wrong there and try to fix it as soon 
as possible.

> 
> After upgrade, I got:
> 
> 2013-12-04 13:55:53 CET ERREUR: séquence d'octets invalide pour
> l'encodage « UTF8 » : 0xf6 0x33 0x65 0x30
> 2013-12-04 13:55:53 CET INSTRUCTION : INSERT INTO dspam_signature_data
> (uid,signature,length,created_on,data) VALUES (4,E'529f2659145699019
> 213421',1644,CURRENT_DATE,E'\xf63e0 [truncated…]
> 
> So exactly the same message. And exactly the same behavior as reported,
> if I try to decode this in Python. The signature seems to be wrong. I
> can provide you a simple email if you like.

Yes please.

Best regards,

Thomas