On Thu, 16 Jun 2011 10:14:49 +0200 Claudio Prono <[email protected]> wrote:
> Hello Stevan, > Hello Claudio, > Tnx for the reply. > > Il 15/06/2011 21.23, Stevan Bajić ha scritto: > > On Wed, 15 Jun 2011 13:21:19 +0200 > > Claudio Prono <[email protected]> wrote: > > > >> Hello all, > >> > > Hello Claudio, > > > > > >> After a recent migration of a mailserver i have some problems with the > >> training of dspam: when i send a mail for retraining, i have this on logs: > >> > >> Jun 15 12:50:55 mail2 dspam[27718]: Signature retrieval for > >> '2,4df84600159243584 > >> 817994' failed > >> Jun 15 12:50:55 mail2 dspam[27718]: Unable to find a valid signature. > >> Aborting. > >> Jun 15 12:50:55 mail2 dspam[27718]: process_message returned error -5. > >> dropping > >> message. > >> > >> I have checked, the signature is present into the database, but the > >> query of dspam is wrong (i have activate the mysql debug): > >> > >> 33 Connect dspam@localhost on dspam > >> 33 Query SELECT uid FROM dspam_virtual_uids WHERE > >> username='spam' > >> 33 Query SHOW VARIABLES WHERE > >> variable_name='max_allowed_packet' > >> 33 Query SHOW VARIABLES WHERE > >> variable_name='max_allowed_packet' > >> 33 Query SELECT uid FROM dspam_virtual_uids WHERE > >> username='spam' > >> 33 Query SELECT uid FROM dspam_virtual_uids WHERE > >> username='spam' > >> > >> The username is always wrong, is not spam but the username of the sender > >> e-mail (like [email protected]). > >> > > this depends on how you have implemented that retraining. > > > > > >> Here is my relevant config on postfix: > >> > >> in master.cf: > >> > >> dspam unix - n n - 10 pipe > >> flags=u user=nobody argv=/usr/sbin/dspam --deliver=innocent > >> --feature=noise --user ${recipient} > >> spam unix - n n - - pipe > >> flags=u user=nobody argv=/usr/sbin/dspam --class=spam --source=error > >> --user spam > >> nospam unix - n n - - pipe > >> flags=u user=nobody argv=/usr/sbin/dspam --class=innocent > >> --source=error --user spam > >> > > Aha. See that "--user spam" in the process "spam" and "nonspam"? > > > > > Yes, i have noticed that, but with the config "ChangeUserOnParse full", > the user is changed with the rcpt to of the mail, according with the > documentation: > yes, but you have to follow specific naming of the alias for the retraining to have that mechanism working. > # ChangeUserOnParse: Automatically change the username to match that > specified > # in the To: header. For example, [email protected] will set the > username > # to bob, ignoring any --user passed in. This may not always be > desirable if > # you are using virtual email addresses as usernames. Options: > # on or user take the portion before the @ sign only > # full take everything after the initial {spam,notspam}-. > > Is right? > Yes. It's right. But do you see the note on 'full'? The spam/ham alias would in your case then be "[email protected]" and "[email protected]". > >> And my dspam.config of mysql: > >> > >> MySQLServer /var/run/mysql/mysql.sock > >> MySQLPort > >> MySQLUser dspam > >> MySQLPass [pass] > >> MySQLDb dspam > >> MySQLCompress true > >> MySQLVirtualTable dspam_virtual_uids > >> MySQLVirtualUIDField uid > >> MySQLVirtualUsernameField username > >> MySQLUIDInSignature on > >> > > This is all fine and dandy but the real relevant config is how you have > > setup DSPAM to parse the user. Have you set "ParseToHeaders", > > "ChangeModeOnParse" and/or "ChangeUserOnParse"? > > > here is my settings: > > ParseToHeaders on > ChangeModeOnParse on > ChangeUserOnParse full > > The thing i don't understand is: if i change this values (like > ChangeUSerOnParse on), the mysql query is always done with the user > spam..... > Because you don't follow the proper naming convention needed to have the parsing working. > The last thing i have tryied also is add the option "Broken > lineStripping", but nothing has changed.... > > What i can try ? > First of all you should post ALL your config here. Not just bits. It's frustrating to try to help and with every response getting answers back from you where you show more configuration and that additional new info changes the whole picture. Please post whole dspam.conf and post the whole config how you have implemented the retraining in Postfix. How and when do you pipe to that spam/nonspam transport in Postfix, etc... Posting whole master.cf and main.cf (or just postconf -n) is a good thing too. > Cordially, > > Claudio. > -- Kind Regards from Switzerland, Stevan Bajić ------------------------------------------------------------------------------ EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ Dspam-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspam-user
