I've been trying to use SpamAssassin's ability to store user preferences in a SQL database. My goal is to allow users to create and modify a whitelist and blacklist from a external web interface until Zimbra supports this feature natively. I know it's on the todo list (bug #6953) but I'm not sure how long it will be until this feature is added.
I've done this before on a Ensim server it works great. You just have to create the necessary database and table and then add the following code to the site-wide local.cf or individual user_prefs file:
This doesn't seem to work with Zimbra, though. I added this code (with the right values) to /opt/zimbra/conf/salocal.cf.in and /opt/zimbra/conf/spamassassin/local.cf but I never saw Zimbra connecting to my database box.
Perhaps this feature only works with spamd/spamc? If so, does anyone have any thoughts on how I can accomplish this in another way?