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[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 > > > > > > > >> > >> > > > > > > > -- Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger !DSPAM:1011,491e0128150922483315290!