Hello. I integrated DSpam into my Postfix + Courier IMAP + MySQL
virtual email user setup this evening. All went rather smoothly and
DSpam is happily filtering spam via the Postfix content filter
mechanism. I am currently able to train the filter using the CGI
without any issues and everything seems to be in good working order.
Except that I have tried to setup global spam and notspam filters. I
created a new MySQL virtual alias that pipes mails back into DSpam:
"|/usr/local/bin/dspam --user root --debug --class=spam --source=error"
I created a 'root' user in the virtual users table and have tried
using my fully qualified email address as well with the same result.
When mail is forwarded in, DSpam reports that it is unable to find
the signature and exits. The message is the following:
Jan 12 03:45:06 mara dspam[21024]: Unable to find a valid signature.
Aborting.
Jan 12 03:45:06 mara dspam[21024]: process_message returned error
-5. dropping message.
With verbose debugging enabled, it appears that the signature itself
is actually looked up, but a subsequent query fails. DSpam is
configured to embed the MySQL virtual UID in the message. I have
verified that the postfix and nobody accounts can execute the
binaries and the logs contain a successful lookup message with the
signature found in the spam message.
Does anybody have any ideas? I'd really like to get the aliases
functioning as its easier on my users and the nice Junk button in
Mail.app can forward the message right into dspam for training.
Sample Logs
Postfix Log
Jan 12 03:45:06 mara postfix/smtpd[21022]: sqlLog called.
Jan 12 03:45:06 mara postfix/smtpd[21022]: returning 0 .
Jan 12 03:45:06 mara postfix/smtpd[21022]: returning 0.
Jan 12 03:45:06 mara postfix/smtpd[21022]: 2C03A7D45E0:
client=cpe-069-134-240-138.nc.res.rr.com[69.134.240.138],
sasl_method=PLAIN, [EMAIL PROTECTED]
Jan 12 03:45:06 mara postfix/cleanup[21020]: 2C03A7D45E0: message-
id=<[EMAIL PROTECTED]>
Jan 12 03:45:06 mara postfix/qmgr[20950]: 2C03A7D45E0:
from=<[EMAIL PROTECTED]>, size=21509, nrcpt=1 (queue active)
Jan 12 03:45:06 mara dspam[21024]: Unable to find a valid signature.
Aborting.
Jan 12 03:45:06 mara dspam[21024]: process_message returned error
-5. dropping message.
Jan 12 03:45:06 mara postfix/lmtp[21023]: 2C03A7D45E0: to=<|/usr/
local/bin/dspam --user root --debug --class=spam --
[EMAIL PROTECTED]>, orig_to=<[EMAIL PROTECTED]>,
relay=/tmp/dspam.sock[/tmp/dspam.sock], delay=0, status=sent (250
2.6.0 <"|/usr/local/bin/dspam --user root --debug --class=spam --
source=error"@mara.near-time.net> Message accepted for delivery)
Jan 12 03:45:06 mara postfix/qmgr[20950]: 2C03A7D45E0: removed
DSpam Log
14537: [01/12/2007 01:12:38] decoding message block from encoding type 2
14537: [01/12/2007 01:12:38] found signature '2,45a6fd9019851147395168'
14537: [01/12/2007 01:12:38] scanning component 3 for a DSPAM signature
14537: [01/12/2007 01:12:38] : Encoding : 254
14537: [01/12/2007 01:12:38] : Media Type : 0
14537: [01/12/2007 01:12:38] : Media Subtype: 0
14537: [01/12/2007 01:12:38] : Headers:
14537: [01/12/2007 01:12:38] _ds_get_signature: unable to
_mysql_drv_getpwnam(near-time.com)
14537: [01/12/2007 01:12:38] _mysql_drv_get_spamtotals: unable to
_mysql_drv_getpwnam(near-time.com)
14537: [01/12/2007 01:12:38] DSPAM Instance Shutdown. Exit Code: 0
Cheers,
Blake
!DSPAM:42,45a750d4216086020663843!
