> -----Original Message----- > From: Mark Martinec [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 21, 2007 9:10 PM > To: users@spamassassin.apache.org > Subject: Re: patches for FREEBSD sa-update > >
Ps, as an aside, thanks for an incredibly flexible engine (amavisd). I found a quandary with 'automatic whitelist' (AWL, as in 'almost whitelist') which I was using if a user wanted to release someone from quarantine, I let them click a 'whitelist sender' button. I didn't want to create a FULL user and try to select a default policy (which could change) Long story short, was able to replace the stock: $sql_select_policy = 'SELECT *,users.id'. ' FROM users LEFT JOIN policy ON users.policy_id=policy.id'. ' WHERE users.email IN (%k) ORDER BY users.priority DESC'; With $sql_select_policy = 'SELECT *,users.id'. ' FROM users LEFT JOIN policy ON users.policy_id=policy.id'. ' WHERE users.email IN (%k) and users.policy_id ORDER BY users.priority DESC'; Just by editing amavisd.conf. (I autocreated a user with policy_id=NULL, this allowed me to add a 'phantom' user so that I could attach a wblist to.) This also allows me to populate mail.users with postfix users without assiging a policy, and use myqsl lookups in postfix instead of db4, without needing a different or separate table. (still with it acted upon the From Header, rather then envelope sender, for VERP reasons..... > I consulted one, a FreeBSD maintainer from the office next door :) > > After reading our thread, his answer was a > clear and decisive: /var/db/spamassasin And I don't think it will hurt ANYTHING to move it, since the data is reproduced. I might submit it, or I might want to wait for 3.2....... Nothing earth shattering in the minor patches I am accumulating so far, and /var/lib doesn't break anything but estetics. > /usr/local/lib/spamassassin is not a good place. > Comparing rules (in a textual config files syntax) to > libraries is far-fetched. And remember, /usr could be > read-only. Files under /usr/local/lib are definitely not Then /usr/local/etc/mail/spamassassin isn't a good place for .local.cf and SARES rules either .), but should be backed up. > intended to be frequently updated. So, /var/db it is, for later release. --------------------------------------------------------------------------- This email has been scanned and certified safe by SpammerTrap(tm) For Information please see http://www.spammertrap.com ---------------------------------------------------------------------------
