subject:"\[dspam\-users\] mysql fetch row error"

Hi Steve,
yes i am very interested if you would post whole configs you would
change. i think you are more experienced and can show
maybe how to speed up things with proxy maps u mention and its
interesting to understand the stuff.

thank you from cloudy rainy Hamburg

marko

Steve schrieb:

Original-Nachricht

Datum: Sat, 15 Nov 2008 12:10:04 +0100
Von: Marko Weber <[EMAIL PROTECTED]>
An: "dspam-users@lists.nuclearelephant.com"

Betreff: Re: [dspam-users] mysql fetch row error

Hi Steve,
nice to hear you are the ebuilder great job.

Not only the ebuild. There is a bunch of patches/fixes in Gentoo for DSPAM.
Some of them are already in the CVS edition of DSPAM.

amvisd.conf = http://rafb.net/p/fkrpk553.html
main.cf = http://rafb.net/p/9nhKMt93.html
master.cf = http://rafb.net/p/QDiAPu11.html

hope you can find anything that i can get work proper.
thank you at this time for all the effort

Phuu... I would rewrite much of it. Anway... I try to keep the changes as small
as possible. So I will not post whole config files. Is that okay with you? If
you want, I could. Just let me know. I see you use Postfix.Admin. Right? You
could speed up a lot of things by using proxy maps and other stuff. But there
is no point for me to rewrite the config if you don't want/need.

Anyway lets do the config stuff.

In main.cf remove the content_filter part:
content_filter = amavis:[127.0.0.1]:10024

master.cf use this one here (I did a rewrite of it. Sorry for that. But the
changes are commented in the file and I think you will understand why I changed
things):
http://rafb.net/p/f5PGTy80.html

amavis.conf do this:

Add a forward method on port 10025:
$forward_method = 'smtp:[127.0.0.1]:10025'; # where to forward checked mail

Add notify method on port 10026 (we will use it in DSPAM as well for delivery
of certain stuff):
$notify_method = 'smtp:[127.0.0.1]:10026'; # where to submit notifications

Remove DSPAM access from Amavis (it's better to run DSPAM outside amavisd-new
and use other ways then amavisd-new for tagging mails. Amavis just runs under
one single user and this is limiting the possibilities of DSPAM):
#$dspam = 'dspam';

In dspam.conf:

Your trusted and untrusted agent should probably be the sendmail binary
(Postfix edition but the ebuild is already taken care of this):
TrustedDeliveryAgent "/usr/sbin/sendmail"
UntrustedDeliveryAgent "/usr/sbin/sendmail"

Switch the delivery to SMTP (remember the port 10026 above for amavisd-new?
Well... we are going to reuse that port for DSPAM delivery):
DeliveryHost127.0.0.1
DeliveryPort10026
DeliveryIdent localhost
DeliveryProto SMTP

Change the DSPAM server to use auto mode:
ServerQueueSize 32
ServerMode auto

Add config to identify the DSPAM agent and daemon (as ident I used kw1 for
kraftwerk1):
ServerPass.kw1 "9252173122311528111"
ServerParameters"--deliver=innocent"
ServerIdent "kw1.dspam.server"
ServerDomainSocketPath /var/run/dspam/dspam.sock
ClientHost /var/run/dspam/dspam.sock
ClientIdent "[EMAIL PROTECTED]"

In the Gentoo forum you will find much more configuration tips and tricks.. Just search for the
user "SteveB" and for the keyword dspam or postfix or amavis. I run DSPAM for a long time
and have probably a different viewpoint on DSPAM then you. This does not mean that "my
way" is better then other configurations. I just got used of doing it a certain way. I as well
have patched my DSPAM with about 20 own made patches. Some of them add new functions and some of
them fix memory leaks and others do speed up things (I speeded up the MySQL part significantly on
my setup). I do the training as well much different then probably most users here. I use TONE
(train on or near error) and I use a own made patch to do that as well with whitelisted DSPAM
results (if the whitelisted message would result in spam if no whitelisting would be active). The
result looks something like that here:
Nov 15 02:46:03 mail postfix/lmtp[30960]: 9229E15B3E49: to=,
relay=127.0.0.1[127.0.0.1]:10024, delay=7.4, delays=7/0.02/0..01/0.4, dsn=2.0.0,
status=sent (250 2.0.0 Ok, id=29240-17, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok:
queued as 2962C15B3E4F)
Nov 15 02:46:08 mail dspam[24389]: forcing learning of auto-whitelisted SPAM
message as INNOCENT
Nov 15 02:46:08 mail dspam[24389]: innocent message from 211.115.216.226

I like DSPAM much and it does tag spam messages very well but the most problem
I have is that ham messages don't get so well recognized as spam. So I had to
take care of this and that's the reason why I added that functionality into
DSPAM.

Anyway... this has nothing to do with your problem. I just tried to explain why
I have changed things in maste

Re: AW: [dspam-users] mysql fetch row error


Hi Steve,
man, 100 thanks for your effort and taking time for all.
i just arrived at home and now have to fix some things in house that my 
girlfriend wants be done.

after that , i do backups of all , and try your settings and config.
i cant wait to see dspam working, when moving mails from SPAM folder to 
incoming, and then all should go fine.


also i try to understand what happens in these configs,
i am very interested to under stand more of this area. if you have 
enough stamina maybe we can stay in contact in this list here. :-)


and yes , this dspam-forum would be great.
at first  i will try your hints and config you gave me

marko



Steve schrieb:

 Original-Nachricht 
  

Datum: Sat, 15 Nov 2008 15:58:27 +0100
Von: "Imposit.com - Webmaster" <[EMAIL PROTECTED]>
An: dspam-users@lists.nuclearelephant.com
Betreff: AW: [dspam-users] mysql fetch row error



  

Ill make a Forum with an ListGateway. Also it should be secure and Fast
and
and and.. :-)



No problem. I have read last week that you wanted or that you will do the forum 
and the list gateway. I did not jumped in to offer anything since I wanted to 
see others doing something as well. And I am happy/glad you did. :)


  

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Im Auftrag von Steve
Gesendet: Samstag, 15. November 2008 15:32
An: dspam-users@lists.nuclearelephant.com
Betreff: AW: [dspam-users] mysql fetch row error


 Original-Nachricht 


Datum: Sat, 15 Nov 2008 15:28:06 +0100
Von: "Imposit.com - Webmaster" <[EMAIL PROTECTED]>
An: dspam-users@lists.nuclearelephant.com
Betreff: AW: [dspam-users] mysql fetch row error
  
Maybe ife another idea.


I dont know the Gentoo Version but maybe this encoding comes from the
Database.

  

No. It can not come from the DB backend as it is the dovecot plugin
executing the command even without contacting the DB backend.




Please Post your my.cnf from the Mysql DB and also which Charset your
system
is using.
Also we have to know which charset u use in the mysql tables and which
  

one


fort he database.
General ist a good idea to use for everything UTF-8. 



PS: i hope ill have this weekend more time fort he dev list and the
  

forum.

I could add a forum and a dev mailing list in 10 minutes if you want me to

do that for the DSPAM community.




-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Im Auftrag von
  

Steve


Gesendet: Samstag, 15. November 2008 14:09
An: dspam-users@lists.nuclearelephant.com
Betreff: Re: [dspam-users] mysql fetch row error

 Original-Nachricht 
  

Datum: Sat, 15 Nov 2008 12:10:04 +0100
Von: Marko Weber <[EMAIL PROTECTED]>
An: "dspam-users@lists.nuclearelephant.com"
    


      

Betreff: Re: [dspam-users] mysql fetch row error

Hi Steve,

nice to hear you are the ebuilder great job.



Not only the ebuild. There is a bunch of patches/fixes in Gentoo for
DSPAM.
Some of them are already in the CVS edition of DSPAM.



  

amvisd.conf = http://rafb.net/p/fkrpk553.html
main.cf = http://rafb.net/p/9nhKMt93.html
master.cf  = http://rafb.net/p/QDiAPu11.html

hope you can find anything that i can get work proper.
thank you at this time for all the effort



Phuu... I would rewrite much of it. Anway... I try to keep the changes
  

as


small as possible. So I will not post whole config files. Is that okay
with
you? If you want, I could. Just let me know. I see you use
  

Postfix.Admin.


Right? You could speed up a lot of things by using proxy maps and other
stuff. But there is no point for me to rewrite the config if you don't
want/need.


Anyway lets do the config stuff.

In main.cf remove the content_filter part:
content_filter = amavis:[127.0.0.1]:10024

master.cf use this one here (I did a rewrite of it. Sorry for that. But
the
changes are commented in the file and I think you will understand why I
changed things):
http://rafb.net/p/f5PGTy80.html

amavis.conf do this:

Add a forward method on port 10025:
$forward_method = 'smtp:[127.0.0.1]:10025';  # where to forward checked
mail

Add notify method on port 10026 (we will use it in DSPAM as well for
delivery of certain stuff):
$notify_method = 'smtp:[127.0.0.1]:10026';  # where to submit
notifications

Remove DSPAM access from Amavis (it's better to run DSPAM outside
amavisd-new and use other ways then amavisd-new for tagging mails.
  

Amavis


just runs under one single user and this is limiting the possibilities
  

of


DSPAM):
#$dspam  = 'dspam';


In dspam.conf:

Your trusted and untrusted agent should probably be the sendmail binary
(Postfix edition but the ebuild is already taken care of this):
TrustedDeliveryAgent "/usr/sbin/sendmail"
UntrustedDeliveryA

AW: [dspam-users] mysql fetch row error


 Original-Nachricht 
> Datum: Sat, 15 Nov 2008 15:58:27 +0100
> Von: "Imposit.com - Webmaster" <[EMAIL PROTECTED]>
> An: dspam-users@lists.nuclearelephant.com
> Betreff: AW: [dspam-users] mysql fetch row error

> Ill make a Forum with an ListGateway. Also it should be secure and Fast
> and
> and and.. :-)
> 
No problem. I have read last week that you wanted or that you will do the forum 
and the list gateway. I did not jumped in to offer anything since I wanted to 
see others doing something as well. And I am happy/glad you did. :)


> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Im Auftrag von Steve
> Gesendet: Samstag, 15. November 2008 15:32
> An: dspam-users@lists.nuclearelephant.com
> Betreff: AW: [dspam-users] mysql fetch row error
> 
> 
>  Original-Nachricht 
> > Datum: Sat, 15 Nov 2008 15:28:06 +0100
> > Von: "Imposit.com - Webmaster" <[EMAIL PROTECTED]>
> > An: dspam-users@lists.nuclearelephant.com
> > Betreff: AW: [dspam-users] mysql fetch row error
> 
> > Maybe ife another idea.
> > 
> > I dont know the Gentoo Version but maybe this encoding comes from the
> > Database.
> > 
> No. It can not come from the DB backend as it is the dovecot plugin
> executing the command even without contacting the DB backend.
> 
> 
> > Please Post your my.cnf from the Mysql DB and also which Charset your
> > system
> > is using.
> > Also we have to know which charset u use in the mysql tables and which
> one
> > fort he database.
> > General ist a good idea to use for everything UTF-8. 
> > 
> > 
> > PS: i hope ill have this weekend more time fort he dev list and the
> forum.
> > 
> I could add a forum and a dev mailing list in 10 minutes if you want me to
> do that for the DSPAM community.
> 
> 
> > -----Ursprüngliche Nachricht-
> > Von: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Im Auftrag von
> Steve
> > Gesendet: Samstag, 15. November 2008 14:09
> > An: dspam-users@lists.nuclearelephant.com
> > Betreff: Re: [dspam-users] mysql fetch row error
> > 
> >  Original-Nachricht 
> > > Datum: Sat, 15 Nov 2008 12:10:04 +0100
> > > Von: Marko Weber <[EMAIL PROTECTED]>
> > > An: "dspam-users@lists.nuclearelephant.com"
> > 
> > > Betreff: Re: [dspam-users] mysql fetch row error
> > 
> > > Hi Steve,
> > > nice to hear you are the ebuilder great job.
> > > 
> > Not only the ebuild. There is a bunch of patches/fixes in Gentoo for
> > DSPAM.
> > Some of them are already in the CVS edition of DSPAM.
> > 
> > 
> > 
> > > amvisd.conf = http://rafb.net/p/fkrpk553.html
> > > main.cf = http://rafb.net/p/9nhKMt93.html
> > > master.cf  = http://rafb.net/p/QDiAPu11.html
> > > 
> > > hope you can find anything that i can get work proper.
> > > thank you at this time for all the effort
> > > 
> > Phuu... I would rewrite much of it. Anway... I try to keep the changes
> as
> > small as possible. So I will not post whole config files. Is that okay
> > with
> > you? If you want, I could. Just let me know. I see you use
> Postfix.Admin.
> > Right? You could speed up a lot of things by using proxy maps and other
> > stuff. But there is no point for me to rewrite the config if you don't
> > want/need.
> > 
> > 
> > Anyway lets do the config stuff.
> > 
> > In main.cf remove the content_filter part:
> > content_filter = amavis:[127.0.0.1]:10024
> > 
> > master.cf use this one here (I did a rewrite of it. Sorry for that. But
> > the
> > changes are commented in the file and I think you will understand why I
> > changed things):
> > http://rafb.net/p/f5PGTy80.html
> > 
> > amavis.conf do this:
> > 
> > Add a forward method on port 10025:
> > $forward_method = 'smtp:[127.0.0.1]:10025';  # where to forward checked
> > mail
> > 
> > Add notify method on port 10026 (we will use it in DSPAM as well for
> > delivery of certain stuff):
> > $notify_method = 'smtp:[127.0.0.1]:10026';  # where to submit
> > notifications
> > 
> > Remove DSPAM access from Amavis (it's better to run DSPAM outside
> > amavisd-new and use other ways then amavisd-new for tagging mails.
> Amavis
> > just runs under one single user and this is limiting the possibilities
> of
> > DSPAM):
> > #$dspam  = 'dspam';
> > 
> &g

AW: [dspam-users] mysql fetch row error


 Original-Nachricht 
> Datum: Sat, 15 Nov 2008 16:18:13 +0100
> Von: "Imposit.com - Webmaster" <[EMAIL PROTECTED]>
> An: dspam-users@lists.nuclearelephant.com
> Betreff: AW: [dspam-users] mysql fetch row error

> Why you think the encoding comes from the dovecot?
> It isnt envoled yet i think, isnt it?
> 
It is involved. It must. Because the mail got delivered to his IMAP server and 
from there he is using a plugin (I think it is called dovecot antispam plugin) 
which scans certain folders for spam missclassification and depending on where 
the plugin finds the mail it will extract the DSPAM signature and execute the 
DSPAM binary with parameters in order to get the message trained.
And I asked Markus to post the full header of the message in question. And 
already those headers have the encoding part in it. So it is not the plugin 
which is not okay. It must be something else. I suspect that amavisd-new is 
doing it. But I am not 100% sure.


> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Im Auftrag von Steve
> Gesendet: Samstag, 15. November 2008 15:32
> An: dspam-users@lists.nuclearelephant.com
> Betreff: AW: [dspam-users] mysql fetch row error
> 
> 
>  Original-Nachricht 
> > Datum: Sat, 15 Nov 2008 15:28:06 +0100
> > Von: "Imposit.com - Webmaster" <[EMAIL PROTECTED]>
> > An: dspam-users@lists.nuclearelephant.com
> > Betreff: AW: [dspam-users] mysql fetch row error
> 
> > Maybe ife another idea.
> > 
> > I dont know the Gentoo Version but maybe this encoding comes from the
> > Database.
> > 
> No. It can not come from the DB backend as it is the dovecot plugin
> executing the command even without contacting the DB backend.
> 
> 
> > Please Post your my.cnf from the Mysql DB and also which Charset your
> > system
> > is using.
> > Also we have to know which charset u use in the mysql tables and which
> one
> > fort he database.
> > General ist a good idea to use for everything UTF-8. 
> > 
> > 
> > PS: i hope ill have this weekend more time fort he dev list and the
> forum.
> > 
> I could add a forum and a dev mailing list in 10 minutes if you want me to
> do that for the DSPAM community.
> 
> 
> > -----Ursprüngliche Nachricht-
> > Von: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Im Auftrag von
> Steve
> > Gesendet: Samstag, 15. November 2008 14:09
> > An: dspam-users@lists.nuclearelephant.com
> > Betreff: Re: [dspam-users] mysql fetch row error
> > 
> >  Original-Nachricht 
> > > Datum: Sat, 15 Nov 2008 12:10:04 +0100
> > > Von: Marko Weber <[EMAIL PROTECTED]>
> > > An: "dspam-users@lists.nuclearelephant.com"
> > 
> > > Betreff: Re: [dspam-users] mysql fetch row error
> > 
> > > Hi Steve,
> > > nice to hear you are the ebuilder great job.
> > > 
> > Not only the ebuild. There is a bunch of patches/fixes in Gentoo for
> > DSPAM.
> > Some of them are already in the CVS edition of DSPAM.
> > 
> > 
> > 
> > > amvisd.conf = http://rafb.net/p/fkrpk553.html
> > > main.cf = http://rafb.net/p/9nhKMt93.html
> > > master.cf  = http://rafb.net/p/QDiAPu11.html
> > > 
> > > hope you can find anything that i can get work proper.
> > > thank you at this time for all the effort
> > > 
> > Phuu... I would rewrite much of it. Anway... I try to keep the changes
> as
> > small as possible. So I will not post whole config files. Is that okay
> > with
> > you? If you want, I could. Just let me know. I see you use
> Postfix.Admin.
> > Right? You could speed up a lot of things by using proxy maps and other
> > stuff. But there is no point for me to rewrite the config if you don't
> > want/need.
> > 
> > 
> > Anyway lets do the config stuff.
> > 
> > In main.cf remove the content_filter part:
> > content_filter = amavis:[127.0.0.1]:10024
> > 
> > master.cf use this one here (I did a rewrite of it. Sorry for that. But
> > the
> > changes are commented in the file and I think you will understand why I
> > changed things):
> > http://rafb.net/p/f5PGTy80.html
> > 
> > amavis.conf do this:
> > 
> > Add a forward method on port 10025:
> > $forward_method = 'smtp:[127.0.0.1]:10025';  # where to forward checked
> > mail
> > 
> > Add notify method on port 10026 (we will use it in DSPAM as well for
> > delivery of certain stuff):
> > $notify_method = 'smtp:[127.0.0

AW: [dspam-users] mysql fetch row error

Uh yes some thought error. Ok it is envolved and no d bis involed yet yes
sorry.. 



-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Im Auftrag von Steve
Gesendet: Samstag, 15. November 2008 15:32
An: dspam-users@lists.nuclearelephant.com
Betreff: AW: [dspam-users] mysql fetch row error


 Original-Nachricht 
> Datum: Sat, 15 Nov 2008 15:28:06 +0100
> Von: "Imposit.com - Webmaster" <[EMAIL PROTECTED]>
> An: dspam-users@lists.nuclearelephant.com
> Betreff: AW: [dspam-users] mysql fetch row error

> Maybe ife another idea.
> 
> I dont know the Gentoo Version but maybe this encoding comes from the
> Database.
> 
No. It can not come from the DB backend as it is the dovecot plugin
executing the command even without contacting the DB backend.


> Please Post your my.cnf from the Mysql DB and also which Charset your
> system
> is using.
> Also we have to know which charset u use in the mysql tables and which one
> fort he database.
> General ist a good idea to use for everything UTF-8. 
> 
> 
> PS: i hope ill have this weekend more time fort he dev list and the forum.
> 
I could add a forum and a dev mailing list in 10 minutes if you want me to
do that for the DSPAM community.


> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Im Auftrag von Steve
> Gesendet: Samstag, 15. November 2008 14:09
> An: dspam-users@lists.nuclearelephant.com
> Betreff: Re: [dspam-users] mysql fetch row error
> 
>  Original-Nachricht 
> > Datum: Sat, 15 Nov 2008 12:10:04 +0100
> > Von: Marko Weber <[EMAIL PROTECTED]>
> > An: "dspam-users@lists.nuclearelephant.com"
> 
> > Betreff: Re: [dspam-users] mysql fetch row error
> 
> > Hi Steve,
> > nice to hear you are the ebuilder great job.
> > 
> Not only the ebuild. There is a bunch of patches/fixes in Gentoo for
> DSPAM.
> Some of them are already in the CVS edition of DSPAM.
> 
> 
> 
> > amvisd.conf = http://rafb.net/p/fkrpk553.html
> > main.cf = http://rafb.net/p/9nhKMt93.html
> > master.cf  = http://rafb.net/p/QDiAPu11.html
> > 
> > hope you can find anything that i can get work proper.
> > thank you at this time for all the effort
> > 
> Phuu... I would rewrite much of it. Anway... I try to keep the changes as
> small as possible. So I will not post whole config files. Is that okay
> with
> you? If you want, I could. Just let me know. I see you use Postfix.Admin.
> Right? You could speed up a lot of things by using proxy maps and other
> stuff. But there is no point for me to rewrite the config if you don't
> want/need.
> 
> 
> Anyway lets do the config stuff.
> 
> In main.cf remove the content_filter part:
> content_filter = amavis:[127.0.0.1]:10024
> 
> master.cf use this one here (I did a rewrite of it. Sorry for that. But
> the
> changes are commented in the file and I think you will understand why I
> changed things):
> http://rafb.net/p/f5PGTy80.html
> 
> amavis.conf do this:
> 
> Add a forward method on port 10025:
> $forward_method = 'smtp:[127.0.0.1]:10025';  # where to forward checked
> mail
> 
> Add notify method on port 10026 (we will use it in DSPAM as well for
> delivery of certain stuff):
> $notify_method = 'smtp:[127.0.0.1]:10026';  # where to submit
> notifications
> 
> Remove DSPAM access from Amavis (it's better to run DSPAM outside
> amavisd-new and use other ways then amavisd-new for tagging mails. Amavis
> just runs under one single user and this is limiting the possibilities of
> DSPAM):
> #$dspam  = 'dspam';
> 
> 
> In dspam.conf:
> 
> Your trusted and untrusted agent should probably be the sendmail binary
> (Postfix edition but the ebuild is already taken care of this):
> TrustedDeliveryAgent "/usr/sbin/sendmail"
> UntrustedDeliveryAgent "/usr/sbin/sendmail"
> 
> 
> Switch the delivery to SMTP (remember the port 10026 above for
> amavisd-new?
> Well... we are going to reuse that port for DSPAM delivery):
> DeliveryHost127.0.0.1
> DeliveryPort10026
> DeliveryIdent   localhost
> DeliveryProto   SMTP
> 
> 
> Change the DSPAM server to use auto mode:
> ServerQueueSize   32
> ServerMode   auto
> 
> 
> Add config to identify the DSPAM agent and daemon (as ident I used kw1 for
> kraftwerk1):
> ServerPass.kw1 "9252173122311528111"
> ServerParameters"--deliver=innocent"
> ServerIdent "kw1.dspam.server"
> ServerDomainSocketPath  /var/run/dspam/dspam.sock
> ClientHost  /var/run/ds

AW: [dspam-users] mysql fetch row error

Why you think the encoding comes from the dovecot?
It isnt envoled yet i think, isnt it?

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Im Auftrag von Steve
Gesendet: Samstag, 15. November 2008 15:32
An: dspam-users@lists.nuclearelephant.com
Betreff: AW: [dspam-users] mysql fetch row error


 Original-Nachricht 
> Datum: Sat, 15 Nov 2008 15:28:06 +0100
> Von: "Imposit.com - Webmaster" <[EMAIL PROTECTED]>
> An: dspam-users@lists.nuclearelephant.com
> Betreff: AW: [dspam-users] mysql fetch row error

> Maybe ife another idea.
> 
> I dont know the Gentoo Version but maybe this encoding comes from the
> Database.
> 
No. It can not come from the DB backend as it is the dovecot plugin
executing the command even without contacting the DB backend.


> Please Post your my.cnf from the Mysql DB and also which Charset your
> system
> is using.
> Also we have to know which charset u use in the mysql tables and which one
> fort he database.
> General ist a good idea to use for everything UTF-8. 
> 
> 
> PS: i hope ill have this weekend more time fort he dev list and the forum.
> 
I could add a forum and a dev mailing list in 10 minutes if you want me to
do that for the DSPAM community.


> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Im Auftrag von Steve
> Gesendet: Samstag, 15. November 2008 14:09
> An: dspam-users@lists.nuclearelephant.com
> Betreff: Re: [dspam-users] mysql fetch row error
> 
>  Original-Nachricht 
> > Datum: Sat, 15 Nov 2008 12:10:04 +0100
> > Von: Marko Weber <[EMAIL PROTECTED]>
> > An: "dspam-users@lists.nuclearelephant.com"
> 
> > Betreff: Re: [dspam-users] mysql fetch row error
> 
> > Hi Steve,
> > nice to hear you are the ebuilder great job.
> > 
> Not only the ebuild. There is a bunch of patches/fixes in Gentoo for
> DSPAM.
> Some of them are already in the CVS edition of DSPAM.
> 
> 
> 
> > amvisd.conf = http://rafb.net/p/fkrpk553.html
> > main.cf = http://rafb.net/p/9nhKMt93.html
> > master.cf  = http://rafb.net/p/QDiAPu11.html
> > 
> > hope you can find anything that i can get work proper.
> > thank you at this time for all the effort
> > 
> Phuu... I would rewrite much of it. Anway... I try to keep the changes as
> small as possible. So I will not post whole config files. Is that okay
> with
> you? If you want, I could. Just let me know. I see you use Postfix.Admin.
> Right? You could speed up a lot of things by using proxy maps and other
> stuff. But there is no point for me to rewrite the config if you don't
> want/need.
> 
> 
> Anyway lets do the config stuff.
> 
> In main.cf remove the content_filter part:
> content_filter = amavis:[127.0.0.1]:10024
> 
> master.cf use this one here (I did a rewrite of it. Sorry for that. But
> the
> changes are commented in the file and I think you will understand why I
> changed things):
> http://rafb.net/p/f5PGTy80.html
> 
> amavis.conf do this:
> 
> Add a forward method on port 10025:
> $forward_method = 'smtp:[127.0.0.1]:10025';  # where to forward checked
> mail
> 
> Add notify method on port 10026 (we will use it in DSPAM as well for
> delivery of certain stuff):
> $notify_method = 'smtp:[127.0.0.1]:10026';  # where to submit
> notifications
> 
> Remove DSPAM access from Amavis (it's better to run DSPAM outside
> amavisd-new and use other ways then amavisd-new for tagging mails. Amavis
> just runs under one single user and this is limiting the possibilities of
> DSPAM):
> #$dspam  = 'dspam';
> 
> 
> In dspam.conf:
> 
> Your trusted and untrusted agent should probably be the sendmail binary
> (Postfix edition but the ebuild is already taken care of this):
> TrustedDeliveryAgent "/usr/sbin/sendmail"
> UntrustedDeliveryAgent "/usr/sbin/sendmail"
> 
> 
> Switch the delivery to SMTP (remember the port 10026 above for
> amavisd-new?
> Well... we are going to reuse that port for DSPAM delivery):
> DeliveryHost127.0.0.1
> DeliveryPort10026
> DeliveryIdent   localhost
> DeliveryProto   SMTP
> 
> 
> Change the DSPAM server to use auto mode:
> ServerQueueSize   32
> ServerMode   auto
> 
> 
> Add config to identify the DSPAM agent and daemon (as ident I used kw1 for
> kraftwerk1):
> ServerPass.kw1 "9252173122311528111"
> ServerParameters"--deliver=innocent"
> ServerIdent "kw1.dspam.server"
> ServerDomainSocketPath  /var/run/dspam/dspam.sock
> ClientHost  /var/r

AW: [dspam-users] mysql fetch row error

Ill make a Forum with an ListGateway. Also it should be secure and Fast and
and and.. :-)

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Im Auftrag von Steve
Gesendet: Samstag, 15. November 2008 15:32
An: dspam-users@lists.nuclearelephant.com
Betreff: AW: [dspam-users] mysql fetch row error


 Original-Nachricht 
> Datum: Sat, 15 Nov 2008 15:28:06 +0100
> Von: "Imposit.com - Webmaster" <[EMAIL PROTECTED]>
> An: dspam-users@lists.nuclearelephant.com
> Betreff: AW: [dspam-users] mysql fetch row error

> Maybe ife another idea.
> 
> I dont know the Gentoo Version but maybe this encoding comes from the
> Database.
> 
No. It can not come from the DB backend as it is the dovecot plugin
executing the command even without contacting the DB backend.


> Please Post your my.cnf from the Mysql DB and also which Charset your
> system
> is using.
> Also we have to know which charset u use in the mysql tables and which one
> fort he database.
> General ist a good idea to use for everything UTF-8. 
> 
> 
> PS: i hope ill have this weekend more time fort he dev list and the forum.
> 
I could add a forum and a dev mailing list in 10 minutes if you want me to
do that for the DSPAM community.


> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Im Auftrag von Steve
> Gesendet: Samstag, 15. November 2008 14:09
> An: dspam-users@lists.nuclearelephant.com
> Betreff: Re: [dspam-users] mysql fetch row error
> 
>  Original-Nachricht 
> > Datum: Sat, 15 Nov 2008 12:10:04 +0100
> > Von: Marko Weber <[EMAIL PROTECTED]>
> > An: "dspam-users@lists.nuclearelephant.com"
> 
> > Betreff: Re: [dspam-users] mysql fetch row error
> 
> > Hi Steve,
> > nice to hear you are the ebuilder great job.
> > 
> Not only the ebuild. There is a bunch of patches/fixes in Gentoo for
> DSPAM.
> Some of them are already in the CVS edition of DSPAM.
> 
> 
> 
> > amvisd.conf = http://rafb.net/p/fkrpk553.html
> > main.cf = http://rafb.net/p/9nhKMt93.html
> > master.cf  = http://rafb.net/p/QDiAPu11.html
> > 
> > hope you can find anything that i can get work proper.
> > thank you at this time for all the effort
> > 
> Phuu... I would rewrite much of it. Anway... I try to keep the changes as
> small as possible. So I will not post whole config files. Is that okay
> with
> you? If you want, I could. Just let me know. I see you use Postfix.Admin.
> Right? You could speed up a lot of things by using proxy maps and other
> stuff. But there is no point for me to rewrite the config if you don't
> want/need.
> 
> 
> Anyway lets do the config stuff.
> 
> In main.cf remove the content_filter part:
> content_filter = amavis:[127.0.0.1]:10024
> 
> master.cf use this one here (I did a rewrite of it. Sorry for that. But
> the
> changes are commented in the file and I think you will understand why I
> changed things):
> http://rafb.net/p/f5PGTy80.html
> 
> amavis.conf do this:
> 
> Add a forward method on port 10025:
> $forward_method = 'smtp:[127.0.0.1]:10025';  # where to forward checked
> mail
> 
> Add notify method on port 10026 (we will use it in DSPAM as well for
> delivery of certain stuff):
> $notify_method = 'smtp:[127.0.0.1]:10026';  # where to submit
> notifications
> 
> Remove DSPAM access from Amavis (it's better to run DSPAM outside
> amavisd-new and use other ways then amavisd-new for tagging mails. Amavis
> just runs under one single user and this is limiting the possibilities of
> DSPAM):
> #$dspam  = 'dspam';
> 
> 
> In dspam.conf:
> 
> Your trusted and untrusted agent should probably be the sendmail binary
> (Postfix edition but the ebuild is already taken care of this):
> TrustedDeliveryAgent "/usr/sbin/sendmail"
> UntrustedDeliveryAgent "/usr/sbin/sendmail"
> 
> 
> Switch the delivery to SMTP (remember the port 10026 above for
> amavisd-new?
> Well... we are going to reuse that port for DSPAM delivery):
> DeliveryHost127.0.0.1
> DeliveryPort10026
> DeliveryIdent   localhost
> DeliveryProto   SMTP
> 
> 
> Change the DSPAM server to use auto mode:
> ServerQueueSize   32
> ServerMode   auto
> 
> 
> Add config to identify the DSPAM agent and daemon (as ident I used kw1 for
> kraftwerk1):
> ServerPass.kw1 "9252173122311528111"
> ServerParameters"--deliver=innocent"
> ServerIdent "kw1.dspam.server"
> ServerDomainSocketPath  /var/run/dspam/dspam.sock
> ClientHost  /var/r

AW: [dspam-users] mysql fetch row error


 Original-Nachricht 
> Datum: Sat, 15 Nov 2008 15:28:06 +0100
> Von: "Imposit.com - Webmaster" <[EMAIL PROTECTED]>
> An: dspam-users@lists.nuclearelephant.com
> Betreff: AW: [dspam-users] mysql fetch row error

> Maybe ife another idea.
> 
> I dont know the Gentoo Version but maybe this encoding comes from the
> Database.
> 
No. It can not come from the DB backend as it is the dovecot plugin executing 
the command even without contacting the DB backend.


> Please Post your my.cnf from the Mysql DB and also which Charset your
> system
> is using.
> Also we have to know which charset u use in the mysql tables and which one
> fort he database.
> General ist a good idea to use for everything UTF-8. 
> 
> 
> PS: i hope ill have this weekend more time fort he dev list and the forum.
> 
I could add a forum and a dev mailing list in 10 minutes if you want me to do 
that for the DSPAM community.


> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Im Auftrag von Steve
> Gesendet: Samstag, 15. November 2008 14:09
> An: dspam-users@lists.nuclearelephant.com
> Betreff: Re: [dspam-users] mysql fetch row error
> 
>  Original-Nachricht 
> > Datum: Sat, 15 Nov 2008 12:10:04 +0100
> > Von: Marko Weber <[EMAIL PROTECTED]>
> > An: "dspam-users@lists.nuclearelephant.com"
> 
> > Betreff: Re: [dspam-users] mysql fetch row error
> 
> > Hi Steve,
> > nice to hear you are the ebuilder great job.
> > 
> Not only the ebuild. There is a bunch of patches/fixes in Gentoo for
> DSPAM.
> Some of them are already in the CVS edition of DSPAM.
> 
> 
> 
> > amvisd.conf = http://rafb.net/p/fkrpk553.html
> > main.cf = http://rafb.net/p/9nhKMt93.html
> > master.cf  = http://rafb.net/p/QDiAPu11.html
> > 
> > hope you can find anything that i can get work proper.
> > thank you at this time for all the effort
> > 
> Phuu... I would rewrite much of it. Anway... I try to keep the changes as
> small as possible. So I will not post whole config files. Is that okay
> with
> you? If you want, I could. Just let me know. I see you use Postfix.Admin.
> Right? You could speed up a lot of things by using proxy maps and other
> stuff. But there is no point for me to rewrite the config if you don't
> want/need.
> 
> 
> Anyway lets do the config stuff.
> 
> In main.cf remove the content_filter part:
> content_filter = amavis:[127.0.0.1]:10024
> 
> master.cf use this one here (I did a rewrite of it. Sorry for that. But
> the
> changes are commented in the file and I think you will understand why I
> changed things):
> http://rafb.net/p/f5PGTy80.html
> 
> amavis.conf do this:
> 
> Add a forward method on port 10025:
> $forward_method = 'smtp:[127.0.0.1]:10025';  # where to forward checked
> mail
> 
> Add notify method on port 10026 (we will use it in DSPAM as well for
> delivery of certain stuff):
> $notify_method = 'smtp:[127.0.0.1]:10026';  # where to submit
> notifications
> 
> Remove DSPAM access from Amavis (it's better to run DSPAM outside
> amavisd-new and use other ways then amavisd-new for tagging mails. Amavis
> just runs under one single user and this is limiting the possibilities of
> DSPAM):
> #$dspam  = 'dspam';
> 
> 
> In dspam.conf:
> 
> Your trusted and untrusted agent should probably be the sendmail binary
> (Postfix edition but the ebuild is already taken care of this):
> TrustedDeliveryAgent "/usr/sbin/sendmail"
> UntrustedDeliveryAgent "/usr/sbin/sendmail"
> 
> 
> Switch the delivery to SMTP (remember the port 10026 above for
> amavisd-new?
> Well... we are going to reuse that port for DSPAM delivery):
> DeliveryHost127.0.0.1
> DeliveryPort10026
> DeliveryIdent   localhost
> DeliveryProto   SMTP
> 
> 
> Change the DSPAM server to use auto mode:
> ServerQueueSize   32
> ServerMode   auto
> 
> 
> Add config to identify the DSPAM agent and daemon (as ident I used kw1 for
> kraftwerk1):
> ServerPass.kw1 "9252173122311528111"
> ServerParameters"--deliver=innocent"
> ServerIdent "kw1.dspam.server"
> ServerDomainSocketPath  /var/run/dspam/dspam.sock
> ClientHost  /var/run/dspam/dspam.sock
> ClientIdent "[EMAIL PROTECTED]"
> 
> 
> 
> In the Gentoo forum you will find much more configuration tips and
> tricks..
> Just search for the user "SteveB" and for the keyword dspam or postfix or
> amavis. I run DSPAM for a long time and have probably a

AW: [dspam-users] mysql fetch row error

Maybe ife another idea.

I dont know the Gentoo Version but maybe this encoding comes from the
Database.

Please Post your my.cnf from the Mysql DB and also which Charset your system
is using.
Also we have to know which charset u use in the mysql tables and which one
fort he database.
General ist a good idea to use for everything UTF-8. 


PS: i hope ill have this weekend more time fort he dev list and the forum.

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Im Auftrag von Steve
Gesendet: Samstag, 15. November 2008 14:09
An: dspam-users@lists.nuclearelephant.com
Betreff: Re: [dspam-users] mysql fetch row error

 Original-Nachricht 
> Datum: Sat, 15 Nov 2008 12:10:04 +0100
> Von: Marko Weber <[EMAIL PROTECTED]>
> An: "dspam-users@lists.nuclearelephant.com"

> Betreff: Re: [dspam-users] mysql fetch row error

> Hi Steve,
> nice to hear you are the ebuilder great job.
> 
Not only the ebuild. There is a bunch of patches/fixes in Gentoo for DSPAM.
Some of them are already in the CVS edition of DSPAM.



> amvisd.conf = http://rafb.net/p/fkrpk553.html
> main.cf = http://rafb.net/p/9nhKMt93.html
> master.cf  = http://rafb.net/p/QDiAPu11.html
> 
> hope you can find anything that i can get work proper.
> thank you at this time for all the effort
> 
Phuu... I would rewrite much of it. Anway... I try to keep the changes as
small as possible. So I will not post whole config files. Is that okay with
you? If you want, I could. Just let me know. I see you use Postfix.Admin.
Right? You could speed up a lot of things by using proxy maps and other
stuff. But there is no point for me to rewrite the config if you don't
want/need.


Anyway lets do the config stuff.

In main.cf remove the content_filter part:
content_filter = amavis:[127.0.0.1]:10024

master.cf use this one here (I did a rewrite of it. Sorry for that. But the
changes are commented in the file and I think you will understand why I
changed things):
http://rafb.net/p/f5PGTy80.html

amavis.conf do this:

Add a forward method on port 10025:
$forward_method = 'smtp:[127.0.0.1]:10025';  # where to forward checked mail

Add notify method on port 10026 (we will use it in DSPAM as well for
delivery of certain stuff):
$notify_method = 'smtp:[127.0.0.1]:10026';  # where to submit notifications

Remove DSPAM access from Amavis (it's better to run DSPAM outside
amavisd-new and use other ways then amavisd-new for tagging mails. Amavis
just runs under one single user and this is limiting the possibilities of
DSPAM):
#$dspam  = 'dspam';


In dspam.conf:

Your trusted and untrusted agent should probably be the sendmail binary
(Postfix edition but the ebuild is already taken care of this):
TrustedDeliveryAgent "/usr/sbin/sendmail"
UntrustedDeliveryAgent "/usr/sbin/sendmail"


Switch the delivery to SMTP (remember the port 10026 above for amavisd-new?
Well... we are going to reuse that port for DSPAM delivery):
DeliveryHost127.0.0.1
DeliveryPort10026
DeliveryIdent   localhost
DeliveryProto   SMTP


Change the DSPAM server to use auto mode:
ServerQueueSize 32
ServerMode   auto


Add config to identify the DSPAM agent and daemon (as ident I used kw1 for
kraftwerk1):
ServerPass.kw1 "9252173122311528111"
ServerParameters"--deliver=innocent"
ServerIdent "kw1.dspam.server"
ServerDomainSocketPath  /var/run/dspam/dspam.sock
ClientHost  /var/run/dspam/dspam.sock
ClientIdent "[EMAIL PROTECTED]"



In the Gentoo forum you will find much more configuration tips and tricks..
Just search for the user "SteveB" and for the keyword dspam or postfix or
amavis. I run DSPAM for a long time and have probably a different viewpoint
on DSPAM then you. This does not mean that "my way" is better then other
configurations. I just got used of doing it a certain way. I as well have
patched my DSPAM with about 20 own made patches. Some of them add new
functions and some of them fix memory leaks and others do speed up things (I
speeded up the MySQL part significantly on my setup). I do the training as
well much different then probably most users here. I use TONE (train on or
near error) and I use a own made patch to do that as well with whitelisted
DSPAM results (if the whitelisted message would result in spam if no
whitelisting would be active). The result looks something like that here:
Nov 15 02:46:03 mail postfix/lmtp[30960]: 9229E15B3E49: to=,
relay=127.0.0.1[127.0.0.1]:10024, delay=7.4, delays=7/0.02/0.01/0.4,
dsn=2.0.0, status=sent (250 2.0.0 Ok, id=29240-17, from
MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as 2962C15B3E4F)
Nov 15 02:46:08 mail dspam[24389]: forcing learning of auto-whitelisted SPAM
message as INNOCENT
Nov 15 02:46:08 mail dspam[24389]: innocent message from 211.115.216.226

Re: [dspam-users] mysql fetch row error

 Original-Nachricht 
> Datum: Sat, 15 Nov 2008 12:10:04 +0100
> Von: Marko Weber <[EMAIL PROTECTED]>
> An: "dspam-users@lists.nuclearelephant.com" 
> 
> Betreff: Re: [dspam-users] mysql fetch row error

> Hi Steve,
> nice to hear you are the ebuilder great job.
> 
Not only the ebuild. There is a bunch of patches/fixes in Gentoo for DSPAM. 
Some of them are already in the CVS edition of DSPAM.



> amvisd.conf = http://rafb.net/p/fkrpk553.html
> main.cf = http://rafb.net/p/9nhKMt93.html
> master.cf  = http://rafb.net/p/QDiAPu11.html
> 
> hope you can find anything that i can get work proper.
> thank you at this time for all the effort
> 
Phuu... I would rewrite much of it. Anway... I try to keep the changes as small 
as possible. So I will not post whole config files. Is that okay with you? If 
you want, I could. Just let me know. I see you use Postfix.Admin. Right? You 
could speed up a lot of things by using proxy maps and other stuff. But there 
is no point for me to rewrite the config if you don't want/need.


Anyway lets do the config stuff.

In main.cf remove the content_filter part:
content_filter = amavis:[127.0.0.1]:10024

master.cf use this one here (I did a rewrite of it. Sorry for that. But the 
changes are commented in the file and I think you will understand why I changed 
things):
http://rafb.net/p/f5PGTy80.html

amavis.conf do this:

Add a forward method on port 10025:
$forward_method = 'smtp:[127.0.0.1]:10025';  # where to forward checked mail

Add notify method on port 10026 (we will use it in DSPAM as well for delivery 
of certain stuff):
$notify_method = 'smtp:[127.0.0.1]:10026';  # where to submit notifications

Remove DSPAM access from Amavis (it's better to run DSPAM outside amavisd-new 
and use other ways then amavisd-new for tagging mails. Amavis just runs under 
one single user and this is limiting the possibilities of DSPAM):
#$dspam  = 'dspam';


In dspam.conf:

Your trusted and untrusted agent should probably be the sendmail binary 
(Postfix edition but the ebuild is already taken care of this):
TrustedDeliveryAgent "/usr/sbin/sendmail"
UntrustedDeliveryAgent "/usr/sbin/sendmail"


Switch the delivery to SMTP (remember the port 10026 above for amavisd-new? 
Well... we are going to reuse that port for DSPAM delivery):
DeliveryHost127.0.0.1
DeliveryPort10026
DeliveryIdent   localhost
DeliveryProto   SMTP


Change the DSPAM server to use auto mode:
ServerQueueSize 32
ServerMode   auto


Add config to identify the DSPAM agent and daemon (as ident I used kw1 for 
kraftwerk1):
ServerPass.kw1 "9252173122311528111"
ServerParameters"--deliver=innocent"
ServerIdent "kw1.dspam.server"
ServerDomainSocketPath  /var/run/dspam/dspam.sock
ClientHost  /var/run/dspam/dspam.sock
ClientIdent "[EMAIL PROTECTED]"



In the Gentoo forum you will find much more configuration tips and tricks.. 
Just search for the user "SteveB" and for the keyword dspam or postfix or 
amavis. I run DSPAM for a long time and have probably a different viewpoint on 
DSPAM then you. This does not mean that "my way" is better then other 
configurations. I just got used of doing it a certain way. I as well have 
patched my DSPAM with about 20 own made patches. Some of them add new functions 
and some of them fix memory leaks and others do speed up things (I speeded up 
the MySQL part significantly on my setup). I do the training as well much 
different then probably most users here. I use TONE (train on or near error) 
and I use a own made patch to do that as well with whitelisted DSPAM results 
(if the whitelisted message would result in spam if no whitelisting would be 
active). The result looks something like that here:
Nov 15 02:46:03 mail postfix/lmtp[30960]: 9229E15B3E49: to=, 
relay=127.0.0.1[127.0.0.1]:10024, delay=7.4, delays=7/0.02/0.01/0.4, dsn=2.0.0, 
status=sent (250 2.0.0 Ok, id=29240-17, from MTA([127.0.0.1]:10025): 250 2.0.0 
Ok: queued as 2962C15B3E4F)
Nov 15 02:46:08 mail dspam[24389]: forcing learning of auto-whitelisted SPAM 
message as INNOCENT
Nov 15 02:46:08 mail dspam[24389]: innocent message from 211.115.216.226

I like DSPAM much and it does tag spam messages very well but the most problem 
I have is that ham messages don't get so well recognized as spam. So I had to 
take care of this and that's the reason why I added that functionality into 
DSPAM.

Anyway... this has nothing to do with your problem. I just tried to explain why 
I have changed things in master.cf and why I would change things in main.cf and 
especially in dspam.conf.


> marko
> 
Steve


> 
> 
> Steve schrieb:
> > ---- Original-Nachricht 
> >   
> >> Datum: Sat, 15 Nov 2008 11

Re: [dspam-users] mysql fetch row error


Hi Steve,
nice to hear you are the ebuilder great job.

amvisd.conf = http://rafb.net/p/fkrpk553.html
main.cf = http://rafb.net/p/9nhKMt93.html
master.cf  = http://rafb.net/p/QDiAPu11.html

hope you can find anything that i can get work proper.
thank you at this time for all the effort

marko



Steve schrieb:

 Original-Nachricht 
  

Datum: Sat, 15 Nov 2008 11:23:24 +0100
Von: Marko Weber <[EMAIL PROTECTED]>
An: "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"
    


    

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-use

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" 
> 
> 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"
> 
> >> 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]>;

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" 

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"





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

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" 
> 
> 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"
> 
> >> 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
> >>>> 
> >>>> 
> >>>   
> >>>   
> >

Re: [dspam-users] mysql fetch row error