8 messages in net.sourceforge.lists.courier-maildrop[maildropl] How to get extra info fro...
FromSent OnAttachments
Dan HorneSep 28, 2005 2:28 pm 
Jay LeeSep 28, 2005 2:47 pm 
Jay LeeSep 28, 2005 2:49 pm 
Dan HorneSep 29, 2005 6:44 am 
Dan HorneSep 29, 2005 6:45 am 
Jay LeeSep 29, 2005 7:10 am 
Dan HorneSep 29, 2005 7:14 am 
Jay LeeSep 29, 2005 7:17 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:[maildropl] How to get extra info from MySQL db into filtersActions...
From:Dan Horne (da@taisweb.net)
Date:Sep 28, 2005 2:28:36 pm
List:net.sourceforge.lists.courier-maildrop

I am setting up a new mail server using postfix and maildrop connected to a MySQL db. I am calling Spamassassin via maildrop using the following in /usr/local/etc/maildroprc:

if ( $SIZE < 26144 ) { exception { xfilter "/usr/bin/spamassassin --prefspath=$HOME/$DEFAULT/.spamassassin/user_prefs " } }

My goal is to somehow be able to check the value of a field in the database to determine WHETHER to call spamassassin. In other words, some of my users don't want spam filtering, and I need to figure out how to "turn it off" for them. My idea is a boolean field in the user db. Is there any way for this to work? I can't find any information on the maildrop/mysql integration, specifically the maildropmysql.config file syntax. I had to comb through multiple HOWTOs to get a working one. Is there a way to query for extra fields in that file? Alternatively does anyone know how to perform a query on a mysql db and make the results available to the maildrop filters?

I hope I am being clear enough. TIA.