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"? > 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"? > > My config is with postfix, dspam and dovecot. My dspam is 3.9.0. > > Any help please? > > Cheers, > > Claudio Prono. > > -- -- 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
