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 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=x, 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
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 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
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 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
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 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
