Hello all,
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]).
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
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
My config is with postfix, dspam and dovecot. My dspam is 3.9.0.
Any help please?
Cheers,
Claudio Prono.
--
--------------------------------------------------------------------------------
Claudio Prono OPST
System Developer
Gsm: +39-349-54.33.258
@PSS Srl Tel: +39-011-32.72.100
Via San Bernardino, 17 Fax: +39-011-32.46.497
10141 Torino - ITALY http://atpss.net/disclaimer
--------------------------------------------------------------------------------
PGP Key - http://keys.atpss.net/c_prono.asc
------------------------------------------------------------------------------
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
