Re: [dspam-users] mysql fetch row error
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"
>
> 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"
>
> >> 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
> >
> >
> >
> >>
> >>
> >
> >
>
>
>
--
Pt! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen:
http://www.gmx.net/de/go/multimessenger
!DSPAM:1011,491e0128150922483315290!
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"
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!
Re: [dspam-users] mysql fetch row error
Original-Nachricht
> Datum: Fri, 14 Nov 2008 18:11:55 +0100
> Von: Marko Weber <[EMAIL PROTECTED]>
> An: "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
> >
>
>
>
--
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer
!DSPAM:1011,491dd5c7150921807288528!
[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 ? do any1 need my dspam.conf , then i can paste it on web. thank for helping. marko !DSPAM:1011,491db159150924938112922!
Re: [dspam-users] TP Not incrementing
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 ? do any1 need my dspam.conf , then i can paste it on web. thank for helping. marko !DSPAM:1011,491d8bc0150921705732886!
