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. :)
Thanks again,
Matt
>>> "Matthew Yette" <[EMAIL PROTECTED]> 7/19/2007 2:24 PM >>>
>>> "Matthew Yette" <[EMAIL PROTECTED]> 7/19/2007 2:13 PM >>>
I am using SA 3.2.0 using SQL backend userprefs. There is a sending address
that is whitelisted for an entire domain, as well as specific users on that
domain. However, on the messages that come in from this whitelisted address for
multiple recipients (in this case 2), the USER_IN_WHITELIST rule does not fire,
and the message gets hit as spam. Is there something special that needs to be
done to have it apply to multiple-recipient messages? This is my custom SQL
userprefs query:
SELECT preference, value FROM _TABLE_ WHERE username = _USERNAME_ OR username =
'@GLOBAL' OR username = _DOMAIN_ ORDER BY username ASC
Thanks!
Matt Yette
-------------------------------
One other point - in my SQL prefs database, I am only using "domain.com" as the
username for domain-wide preferences, and not "%domain.com" and SELECT
preference, value FROM _TABLE_ WHERE username = _USERNAME_ OR username =
'@GLOBAL' OR username = CONCAT('%',_DOMAIN_) ORDER BY username ASC as Dallas
calls for in his SQL docs. Would this have a negative impact in terms of
applying rules on multiple-recipient mail?
( mailto:[EMAIL PROTECTED] )
CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for
the sole use of the intended recipients(s) and may contain confidential and
privileged information. Any unauthorized review, use, disclosure, or
distribution is prohibited. If you are not the intended recipient(s), please
contact the sender by return e-mail and destroy all copies of the original
message. Thank you.
CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for
the sole use of the intended recipients(s) and may contain confidential and
privileged information. Any unauthorized review, use, disclosure, or
distribution is prohibited. If you are not the intended recipient(s), please
contact the sender by return e-mail and destroy all copies of the original
message. Thank you.
<ยค#/srv/gw/mvndom/wptemp/43ccc243.qm8
