Re: [dspam-users] mysql fetch row error
Hallo Marko This is not normal. DSPAM does not add the encoding. It must be something else you are using/doing to get that tagged with the encoding in front of every DSPAM tag. And I don't see the DSPAM signature in your header. This is not normal. If you have the other DSPAM header lines, then you should have the result as well. What MTA are you using? How is the integration between MTA and DSPAM? Do you have other filters running before and after DSPAM? What IMAP server are you using? What OS are you using? Could you post your DSPAM config? (Grüsse aus Zürich) // Steve Original-Nachricht Datum: Sat, 15 Nov 2008 10:37:38 +0100 Von: Marko Weber [EMAIL PROTECTED] An: dspam-users@lists.nuclearelephant.com dspam-users@lists.nuclearelephant.com Betreff: Re: [dspam-users] mysql fetch row error Hello Steve this is the full Header of a spam mail where the training also fails. withe the mysql fetch error. marko Return-Path: [EMAIL PROTECTED] X-Original-To: [EMAIL PROTECTED] Delivered-To: [EMAIL PROTECTED] Received: from localhost (localhost [127.0.0.1]) by salonwebserver.de (Postfix) with ESMTP id 02C8613BC09B for [EMAIL PROTECTED]; Fri, 14 Nov 2008 21:38:09 +0100 (CET) X-DSPAM-Result: =?iso-8859-1?Q?Spam=0D?= X-DSPAM-Confidence: =?iso-8859-1?Q?0.7177=0D?= X-DSPAM-Probability: =?iso-8859-1?Q?1.=0D?= ?iso-8859-1?Q?491de1b0254959695846858=0D?= X-DSPAM-Factors: 15, X-Virus-Scanned: amavisd-new at salonwebserver.de X-Spam-Flag: NO X-Spam-Score: 2.415 X-Spam-Level: ** X-Spam-Status: No, score=2.415 tagged_above=-1000 required=2.5 tests=[DNS_FROM_SECURITYSAGE=0.127, RCVD_IN_BL_SPAMCOP_NET=2.188, RDNS_DYNAMIC=0.1] Received: from salonwebserver.de ([127.0.0.1]) by localhost (kraftwerk1.salonwebserver.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id nOQQilMNvp-o for [EMAIL PROTECTED]; Fri, 14 Nov 2008 21:38:07 +0100 (CET) Received: from zackbummfertig.de (static.243.42.46.78.clients.your-server.de [78.46.42.243]) (using TLSv1 with cipher ADH-CAMELLIA256-SHA (256/256 bits)) (No client certificate requested) by salonwebserver.de (Postfix) with ESMTPS id E86BD13BC078 for [EMAIL PROTECTED]; Fri, 14 Nov 2008 21:38:06 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by zackbummfertig.de (Postfix) with ESMTP id BC4BDECC067 for [EMAIL PROTECTED]; Fri, 14 Nov 2008 21:37:46 +0100 (CET) X-Virus-Scanned: amavisd-new at zackbummfertig.de Received: from zackbummfertig.de ([127.0.0.1]) by localhost (weberweb.zackbummfertig.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id xr6ayW0lyDGC for [EMAIL PROTECTED]; Fri, 14 Nov 2008 21:37:43 +0100 (CET) Received: from rachel22b12579 (unknown [78.146.113.186]) by zackbummfertig.de (Postfix) with SMTP id 3E83CECC040 for [EMAIL PROTECTED]; Fri, 14 Nov 2008 21:37:43 +0100 (CET) Date: Fri, 14 Nov 2008 20:38:01 + From: Chrystal Huddleston [EMAIL PROTECTED] Subject: gambling slot machines To: [EMAIL PROTECTED] Message-id: [EMAIL PROTECTED] Organization: fightingbobfest.org MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Priority: 3 (Normal) Steve schrieb: Can you post the full header of the message in question? Original-Nachricht Datum: Fri, 14 Nov 2008 23:18:39 +0100 Von: Marko Weber [EMAIL PROTECTED] An: dspam-users@lists.nuclearelephant.com dspam-users@lists.nuclearelephant.com Betreff: Re: [dspam-users] mysql fetch row error Hi Steve, this sed thing dont worked for me.. sorry how i can get dspam working without this mysql fetch error ? u have any hints ? marko Steve schrieb: Original-Nachricht Datum: Fri, 14 Nov 2008 18:11:55 +0100 Von: Marko Weber [EMAIL PROTECTED] An: dspam-users@lists.nuclearelephant.com dspam-users@lists.nuclearelephant.com Betreff: [dspam-users] mysql fetch row error Hello to all in the Mailinglist, i installed dspam on our server and it works so far that incoming mails are tagged by dspam. i installed dovecot-antispam for retraining. when in try to retrain a mail i get this in the dspam.debug log = 9056: [11/14/2008 15:23:01] mysql_fetch_row() failed in _ds_get_signature in the /var/log/messages log i get this = Nov 14 15:29:25 kraftwerk1 imap: antispam: /usr/bin/dspam --source=error --class=spam --signature==?iso-8859-1?Q?491d76cb23581804284693=0D?= ... Nov 14 15:29:25 kraftwerk1 dspam[9189]: Signature retrieval for '=?iso-8859-1?Q?491d76cb23581804284693=0D?=' failed Nov 14 15:29:25 kraftwerk1 dspam[9189]: Unable to find a valid signature. Aborting. Nov 14 15:29:25 kraftwerk1 dspam
Re: [dspam-users] mysql fetch row error
Hi Steve, MTA = Postfix I have amavis - spamassassin - dspam installed. i think spamassassin scnas after dspam, cuase in the mail headers dspam comes at first. I use Dovecot as Imap Server OS = Gentoo Linux i put the config of dspam here = http://rafb.net/p/VCX8XO97.html if u need more confs just tell me , i can paste then marko Steve schrieb: Hallo Marko This is not normal. DSPAM does not add the encoding. It must be something else you are using/doing to get that tagged with the encoding in front of every DSPAM tag. And I don't see the DSPAM signature in your header. This is not normal. If you have the other DSPAM header lines, then you should have the result as well. What MTA are you using? How is the integration between MTA and DSPAM? Do you have other filters running before and after DSPAM? What IMAP server are you using? What OS are you using? Could you post your DSPAM config? (Grüsse aus Zürich) // Steve Original-Nachricht Datum: Sat, 15 Nov 2008 10:37:38 +0100 Von: Marko Weber [EMAIL PROTECTED] An: dspam-users@lists.nuclearelephant.com dspam-users@lists.nuclearelephant.com Betreff: Re: [dspam-users] mysql fetch row error Hello Steve this is the full Header of a spam mail where the training also fails. withe the mysql fetch error. marko Return-Path: [EMAIL PROTECTED] X-Original-To: [EMAIL PROTECTED] Delivered-To: [EMAIL PROTECTED] Received: from localhost (localhost [127.0.0.1]) by salonwebserver.de (Postfix) with ESMTP id 02C8613BC09B for [EMAIL PROTECTED]; Fri, 14 Nov 2008 21:38:09 +0100 (CET) X-DSPAM-Result: =?iso-8859-1?Q?Spam=0D?= X-DSPAM-Confidence: =?iso-8859-1?Q?0.7177=0D?= X-DSPAM-Probability: =?iso-8859-1?Q?1.=0D?= ?iso-8859-1?Q?491de1b0254959695846858=0D?= X-DSPAM-Factors: 15, X-Virus-Scanned: amavisd-new at salonwebserver.de X-Spam-Flag: NO X-Spam-Score: 2.415 X-Spam-Level: ** X-Spam-Status: No, score=2.415 tagged_above=-1000 required=2.5 tests=[DNS_FROM_SECURITYSAGE=0.127, RCVD_IN_BL_SPAMCOP_NET=2.188, RDNS_DYNAMIC=0.1] Received: from salonwebserver.de ([127.0.0.1]) by localhost (kraftwerk1.salonwebserver.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id nOQQilMNvp-o for [EMAIL PROTECTED]; Fri, 14 Nov 2008 21:38:07 +0100 (CET) Received: from zackbummfertig.de (static.243.42.46.78.clients.your-server.de [78.46.42.243]) (using TLSv1 with cipher ADH-CAMELLIA256-SHA (256/256 bits)) (No client certificate requested) by salonwebserver.de (Postfix) with ESMTPS id E86BD13BC078 for [EMAIL PROTECTED]; Fri, 14 Nov 2008 21:38:06 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by zackbummfertig.de (Postfix) with ESMTP id BC4BDECC067 for [EMAIL PROTECTED]; Fri, 14 Nov 2008 21:37:46 +0100 (CET) X-Virus-Scanned: amavisd-new at zackbummfertig.de Received: from zackbummfertig.de ([127.0.0.1]) by localhost (weberweb.zackbummfertig.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id xr6ayW0lyDGC for [EMAIL PROTECTED]; Fri, 14 Nov 2008 21:37:43 +0100 (CET) Received: from rachel22b12579 (unknown [78.146.113.186]) by zackbummfertig.de (Postfix) with SMTP id 3E83CECC040 for [EMAIL PROTECTED]; Fri, 14 Nov 2008 21:37:43 +0100 (CET) Date: Fri, 14 Nov 2008 20:38:01 + From: Chrystal Huddleston [EMAIL PROTECTED] Subject: gambling slot machines To: [EMAIL PROTECTED] Message-id: [EMAIL PROTECTED] Organization: fightingbobfest.org MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Priority: 3 (Normal) Steve schrieb: Can you post the full header of the message in question? Original-Nachricht Datum: Fri, 14 Nov 2008 23:18:39 +0100 Von: Marko Weber [EMAIL PROTECTED] An: dspam-users@lists.nuclearelephant.com dspam-users@lists.nuclearelephant.com Betreff: Re: [dspam-users] mysql fetch row error Hi Steve, this sed thing dont worked for me.. sorry how i can get dspam working without this mysql fetch error ? u have any hints ? marko Steve schrieb: Original-Nachricht Datum: Fri, 14 Nov 2008 18:11:55 +0100 Von: Marko Weber [EMAIL PROTECTED] An: dspam-users@lists.nuclearelephant.com dspam-users@lists.nuclearelephant.com Betreff: [dspam-users] mysql fetch row error Hello to all in the Mailinglist, i installed dspam on our server and it works so far that incoming mails are tagged by dspam. i installed dovecot-antispam for retraining. when in try to retrain a mail i get this in the dspam.debug log = 9056: [11/14/2008 15:23:01] mysql_fetch_row() failed in _ds_get_signature in the /var/log/messages log i get this = Nov 14 15:29:25 kraftwerk1 imap: antispam
Re: [dspam-users] mysql fetch row error
Original-Nachricht Datum: Sat, 15 Nov 2008 11:23:24 +0100 Von: Marko Weber [EMAIL PROTECTED] An: dspam-users@lists.nuclearelephant.com dspam-users@lists.nuclearelephant.com Betreff: Re: [dspam-users] mysql fetch row error Hi Steve, Mallo Marko MTA = Postfix I have amavis - spamassassin - dspam installed. I think it's amavisd-new producing that iso stuff. Could you post your amaivs configuration somewhere? And your main.cf and master.cf as well. i think spamassassin scnas after dspam, cuase in the mail headers dspam comes at first. I use Dovecot as Imap Server OS = Gentoo Linux Okay. Then you are using my DSPAM ebuild. I am the one who created the DSPAM ebuild currently used in Gentoo :) i put the config of dspam here = http://rafb.net/p/VCX8XO97.html if u need more confs just tell me , i can paste then marko // Steve Steve schrieb: Hallo Marko This is not normal. DSPAM does not add the encoding. It must be something else you are using/doing to get that tagged with the encoding in front of every DSPAM tag. And I don't see the DSPAM signature in your header. This is not normal. If you have the other DSPAM header lines, then you should have the result as well. What MTA are you using? How is the integration between MTA and DSPAM? Do you have other filters running before and after DSPAM? What IMAP server are you using? What OS are you using? Could you post your DSPAM config? (Grüsse aus Zürich) // Steve Original-Nachricht Datum: Sat, 15 Nov 2008 10:37:38 +0100 Von: Marko Weber [EMAIL PROTECTED] An: dspam-users@lists.nuclearelephant.com dspam-users@lists.nuclearelephant.com Betreff: Re: [dspam-users] mysql fetch row error Hello Steve this is the full Header of a spam mail where the training also fails. withe the mysql fetch error. marko Return-Path: [EMAIL PROTECTED] X-Original-To: [EMAIL PROTECTED] Delivered-To: [EMAIL PROTECTED] Received: from localhost (localhost [127.0.0.1]) by salonwebserver.de (Postfix) with ESMTP id 02C8613BC09B for [EMAIL PROTECTED]; Fri, 14 Nov 2008 21:38:09 +0100 (CET) X-DSPAM-Result: =?iso-8859-1?Q?Spam=0D?= X-DSPAM-Confidence: =?iso-8859-1?Q?0.7177=0D?= X-DSPAM-Probability: =?iso-8859-1?Q?1.=0D?= ?iso-8859-1?Q?491de1b0254959695846858=0D?= X-DSPAM-Factors: 15, X-Virus-Scanned: amavisd-new at salonwebserver.de X-Spam-Flag: NO X-Spam-Score: 2.415 X-Spam-Level: ** X-Spam-Status: No, score=2.415 tagged_above=-1000 required=2.5 tests=[DNS_FROM_SECURITYSAGE=0.127, RCVD_IN_BL_SPAMCOP_NET=2.188, RDNS_DYNAMIC=0.1] Received: from salonwebserver.de ([127.0.0.1]) by localhost (kraftwerk1.salonwebserver.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id nOQQilMNvp-o for [EMAIL PROTECTED]; Fri, 14 Nov 2008 21:38:07 +0100 (CET) Received: from zackbummfertig.de (static.243.42.46.78.clients.your-server.de [78.46.42.243]) (using TLSv1 with cipher ADH-CAMELLIA256-SHA (256/256 bits)) (No client certificate requested) by salonwebserver.de (Postfix) with ESMTPS id E86BD13BC078 for [EMAIL PROTECTED]; Fri, 14 Nov 2008 21:38:06 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by zackbummfertig.de (Postfix) with ESMTP id BC4BDECC067 for [EMAIL PROTECTED]; Fri, 14 Nov 2008 21:37:46 +0100 (CET) X-Virus-Scanned: amavisd-new at zackbummfertig.de Received: from zackbummfertig.de ([127.0.0.1]) by localhost (weberweb.zackbummfertig.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id xr6ayW0lyDGC for [EMAIL PROTECTED]; Fri, 14 Nov 2008 21:37:43 +0100 (CET) Received: from rachel22b12579 (unknown [78.146.113.186]) by zackbummfertig.de (Postfix) with SMTP id 3E83CECC040 for [EMAIL PROTECTED]; Fri, 14 Nov 2008 21:37:43 +0100 (CET) Date: Fri, 14 Nov 2008 20:38:01 + From: Chrystal Huddleston [EMAIL PROTECTED] Subject: gambling slot machines To: [EMAIL PROTECTED] Message-id: [EMAIL PROTECTED] Organization: fightingbobfest.org MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Priority: 3 (Normal) Steve schrieb: Can you post the full header of the message in question? Original-Nachricht Datum: Fri, 14 Nov 2008 23:18:39 +0100 Von: Marko Weber [EMAIL PROTECTED] An: dspam-users@lists.nuclearelephant.com dspam-users@lists.nuclearelephant.com Betreff: Re: [dspam-users] mysql fetch row error Hi Steve, this sed thing dont worked for me.. sorry how i can get dspam working without this mysql fetch error ? u have any hints ? marko Steve schrieb: Original-Nachricht
Re: [dspam-users] mysql fetch row error
Hi Steve, this sed thing dont worked for me.. sorry how i can get dspam working without this mysql fetch error ? u have any hints ? marko Steve schrieb: Original-Nachricht Datum: Fri, 14 Nov 2008 18:11:55 +0100 Von: Marko Weber [EMAIL PROTECTED] An: dspam-users@lists.nuclearelephant.com dspam-users@lists.nuclearelephant.com Betreff: [dspam-users] mysql fetch row error Hello to all in the Mailinglist, i installed dspam on our server and it works so far that incoming mails are tagged by dspam. i installed dovecot-antispam for retraining. when in try to retrain a mail i get this in the dspam.debug log = 9056: [11/14/2008 15:23:01] mysql_fetch_row() failed in _ds_get_signature in the /var/log/messages log i get this = Nov 14 15:29:25 kraftwerk1 imap: antispam: /usr/bin/dspam --source=error --class=spam --signature==?iso-8859-1?Q?491d76cb23581804284693=0D?= ... Nov 14 15:29:25 kraftwerk1 dspam[9189]: Signature retrieval for '=?iso-8859-1?Q?491d76cb23581804284693=0D?=' failed Nov 14 15:29:25 kraftwerk1 dspam[9189]: Unable to find a valid signature. Aborting. Nov 14 15:29:25 kraftwerk1 dspam[9189]: process_message returned error -5. dropping message. but when i search for the signatur 491d76cb23581804284693 in the mysql database i can find it there. what is this ?iso-8859-1?Q? , is this causing the error ? This means, that the plugin developer used the signature from the body instead of the one found in the header. You can verify yourself what the proper signature would be. Just issue this small one liner in sed: sed -e '/^$/q' -ne 's/^X\-DSPAM\-Signature: \(\([1-9][0-9]*,\)\{0,1\}\([a-f0-9]\{20,32\}\)\)$/\1/p' /path/to/your/message This should print out the proper signature DSPAM should receive from the plugin. The iso-8859-1 part indicates to me that the message is taken from a iso8859-1 encoded message body. do any1 need my dspam.conf , then i can paste it on web. thank for helping. marko Steve !DSPAM:1011,491df903150921679976700!