On Fri, 2016-02-12 at 08:39 -0500, Alex wrote: > Is it possible for spamassassin to query a database directly? > Yes, with a plugin.
I've been doing the opposite for some years now: I archive all my outgoing mail and most of my non-spam incoming mail in a Postgres database and use this as a whitelist: incoming mail from anybody that I've sent mail to gets whitelisted. I use a plugin to query the database via a view: the view is there to present the list of addresses to which I've sent mail to the plugin's SQL query: its needed for performance reasons because the database uses a many-to-many structure to associate addresses with the messages they send or receive. It should be simple enough to change my plugin's query to work with your database, particularly if you already have a table containing the addresses you'd like to blacklist. Likewise, its probably fairly simple to extend it to deal with the URLs and IPs from message bodies. If you'd like a copy of the plugin plus the associated .cf file[*], contact me offlist. Martin [*] this loads and configures the plugin with database login details and defines the rule that whitelists hits.
