I'm using SpamAssassin via MimeDefang and trying to load user preferences in from a mySQL database. I've tried adding the user_scores_sql_* config items in the config file, but these seem to be ignored by everything except spamd -q. I've more or less given up on making that work [but if someone can clue me in that would be great] so I've written my own bit of code into mimedefang-filter to pull the preferences out of the database and then appending them with post_config_text.

However, it appears that none of these preferences are being applied other than required_hits. For example, the preferences pulled for a test user are:

   required_hits 7
   report_safe 0
   rewrite_header Subject [SPAM]
   score BANG_OPRAH 3.0
   required_hits 8
   required_hits 9

Where required_hits is set to 5 in the config file, 7 is in the global settings in DB, 8 in domain in DB, and 9 in the user's settings in DB. A test message <https://gist.github.com/Sammitch/9084301> I've devised triggers the message to be tagged, and the report shows a required score of 9, but the subject is not modified, and the BANG_OPRAH rule is not listed as matching.

Can someone enlighten me on the proper way to specify per-user settings pulled from a database when SpamAssassin is invoked via perl?

--
Wade Rossmann
Systems Administrator
rossmann.w...@realestatewebmasters.com

Reply via email to