Thanks for the feedback. My amavis sql lookup query must not be correct to provide that flexibility. I'm going to have to re-evaluate my config again.
My query currently is: 50-user:$sql_select_white_black_list = 'SELECT wb FROM wblist,mailaddr WHERE (wblist.rid=?) AND (wblist.sid=mailaddr.id) AND (mailaddr.email IN (%k)) ORDER BY mailaddr.priority DESC;'; My goal is to have all blacklisted entries in my sql tables for amavisd apply to my real account "r...@mydomain.com" AND all my postfix mail aliases that point to that account... without creating an association for that sender to each and every mail alias address every time I add a blacklist entry. For example, I have "r...@mydomain.com" and "junkad...@mydomain.com", "junkad...@mydomain.com ", "junkad...@mydomain.com", vehic...@mydomain.com, anotheral...@mydomain.com ... I want to assign @spamdomain.com as a blacklist item for both the real address/account and all the email aliases associated with it. I suppose I could write a php front end to the amavisd tables that allowed me to choose from a pick list of recipients each time I add a blacklist and generate the associations in bulk. Hadn't thought of that before. Maybe moving my postfix conf into mysql would help facilitate that. Mike On Sep 7, 2009, at 7:27 AM, Michael Scheidell wrote: > WagnerOne wrote: >> I understand amavisd-new scans emails differently than spamassassin >> itself does. When I was running SA on it's own, my "real" account ./ >> spamassassin/user_prefs white/blacklist items applied to my "real" >> account and all my mail aliases on the host. >> >> I recently switched my lookups in amavisd-new to sql, so I can have >> per-recipient spam threshold values and white/blacklist entries. >> >> >> > amavis will apply a blacklist per site (match @.) or per domain > (match @domain.com) or per user. > > if your subset is per domain, you can create an '@domain.com' record > (local = 'Y'), and use that user id as the rid. > > or, what does it matter, since wblist and mailaddr are normalized, > just create additional wblist entries where rid == your subset. > > > -- > Michael Scheidell, CTO > Phone: 561-999-5000, x 1259 > > | SECNAP Network Security Corporation > • Certified SNORT Integrator > • 2008-9 Hot Company Award Winner, World Executive Alliance > • Five-Star Partner Program 2009, VARBusiness > • Best Anti-Spam Product 2008, Network Products Guide > • King of Spam Filters, SC Magazine 2008 > > This email has been scanned and certified safe by SpammerTrap®. > For Information please see http://www.secnap.com/products/spammertrap/ > > -- wag...@wagnerone.com "If you have any trouble sounding condescending, find a Unix user to show you how it's done."-Scott Adams ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
