On Thu, 19 Jul 2007 at 15:14 -0400, [EMAIL PROTECTED] confabulated:

After further testing, it most definitely has to do with a message hacing 
multiple recipients (I've tried changing around my custom SQL query to no 
avail). qmail-queue.log log entry w/ debug on:

Thu, 19 Jul 2007 15:10:20 EDT:16677: g_e_h: return-path is "[EMAIL PROTECTED]", recips is 
"[EMAIL PROTECTED],[EMAIL PROTECTED]"
Thu, 19 Jul 2007 15:10:20 EDT:16677: from="Matthew Yette" <[EMAIL PROTECTED]>,subj=test 
( mailto:[EMAIL PROTECTED]> ), x-qmail-scanner-message-id=<[EMAIL PROTECTED]> via SMTP from 
64.9.116.126
Thu, 19 Jul 2007 15:10:20 EDT:16677: ini_sc: start scanning
Thu, 19 Jul 2007 15:10:20 EDT:16677: ini_sc: recursively scan the directory 
/var/spool/qmailscan/tmp/mail.integrityhosting.org118487221972216677/
Thu, 19 Jul 2007 15:10:20 EDT:16677: scanloop: starting scan of directory 
"/var/spool/qmailscan/tmp/mail.integrityhosting.org118487221972216677"...
Thu, 19 Jul 2007 15:10:20 EDT:16677: scanloop: 
scanner=spamassassin,plain_text_msg=0
Thu, 19 Jul 2007 15:10:20 EDT:16677: SA: REPORT hits = -2.6/4.0
-2.6 BAYES_00               BODY: Bayesian spam probability is 0 to 1%
                            [score: 0.0000]
 0.0 HTML_MESSAGE           BODY: HTML included in message
Thu, 19 Jul 2007 15:10:20 EDT:16677: SA: required_hits 4.0 / sa_quarantine +0 / 
sa_delete +0.9
Thu, 19 Jul 2007 15:10:20 EDT:16677: SA: finished scan of dir 
"/var/spool/qmailscan/tmp/mail.integrityhosting.org118487221972216677" in 0.715 
secs - hits=-2.6/4.0

As you can see, recips is "[EMAIL PROTECTED],[EMAIL PROTECTED]" and 
USER_IN_WHITELIST does NOT fire, even though it's in my SQL database as username = 
mattyette.com, preference is whitelist_from and value is [EMAIL PROTECTED]

This has to be something that's cropped up before, I'm hoping it's a quick and 
easy solution. :)

I don't know that SA has a way for running messages through for each individual recipient. I don't believe you can specify multiple username paramenters using spamc and/or spamassassin.

Here we use Postfix and I instruct Postfix to send the message through SA for each recipient. It works like a charm. Perhaps whatever you are using in qmail can do the same.

-------
  _|_
 (_| |

Reply via email to