Bug#731093: [Pkg-dspam-misc] Bug#731093: libdspam7-drv-pgsql: dspam logs showing invalid byte sequence
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,'\\xd0 [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 -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#731093: [Pkg-dspam-misc] Bug#731093: libdspam7-drv-pgsql: dspam logs showing invalid byte sequence
On Mon, Dec 02, 2013 at 01:31:34PM +0800, Thomas Preud'homme wrote: 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? With libdspam7-drv-pgsql 3.10.2+dfsg-11 I get none of these error messages. Looks like it was introduced in -12 then. - Craig -- Craig Small (@smallsees) http://enc.com.au/ csmall at : enc.com.au Debian GNU/Linux http://www.debian.org/ csmall at : debian.org GPG fingerprint:5D2F B320 B825 D939 04D2 0519 3938 F96B DF50 FEA5 -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#731093: [Pkg-dspam-misc] Bug#731093: libdspam7-drv-pgsql: dspam logs showing invalid byte sequence
Le mardi 3 décembre 2013, 23:01:52 Craig Small a écrit : On Mon, Dec 02, 2013 at 01:31:34PM +0800, Thomas Preud'homme wrote: 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? With libdspam7-drv-pgsql 3.10.2+dfsg-11 I get none of these error messages. Looks like it was introduced in -12 then. Thanks, it should help a lot. If I may, would you mind sending me one of the email that generate these errors? It would help me reproduce the problem and also reduce the number of hypothesis I have to do by looking at an actual message that cause the bug instead of imagining all what can happen. Thanks a lot again. Best regards, Thomas -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#731093: [Pkg-dspam-misc] Bug#731093: libdspam7-drv-pgsql: dspam logs showing invalid byte sequence
On Mon, Dec 02, 2013 at 01:31:34PM +0800, Thomas Preud'homme wrote: 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 It is a very recent thing, so while I cannot say it was the last upgrade it all points to it being that. 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? Will do and let you know how it goes. - Craig -- Craig Small (@smallsees) http://enc.com.au/ csmall at : enc.com.au Debian GNU/Linux http://www.debian.org/ csmall at : debian.org GPG fingerprint:5D2F B320 B825 D939 04D2 0519 3938 F96B DF50 FEA5 -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#731093: [Pkg-dspam-misc] Bug#731093: libdspam7-drv-pgsql: dspam logs showing invalid byte sequence
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 -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
