SpamAssassin SQL user preferences

Posted on 2009-04-24
Last Modified: 2013-12-02
Experts Please help.

I have configured a qmail server integrated with Spam assassin. Everytihing is working fine. Spamassassin scans mails globally. But there was requirement from my client stating that individual users of a domain should have the option of white listing , blacklisting the incoming mails rather than the global spam control. I referred "Loading SpamAssassin User Preferences From An SQL Database" from "" and have done everthing. Now the problem is that the individual user preference is not loaded and again the emails are scanned on the domain basis and not based on user settings .

Question by:nptmurali
    LVL 11

    Expert Comment

    You might consider instead using SOA, which is a spam assassin plugin for outlook type clients.


    Author Comment

    Thanks for the link. But 40 % of the my users use webmail and i need the filtereing at the server level
    LVL 11

    Expert Comment

    Can you pass me the please?


    K Black

    Accepted Solution

    I got the solution. I just added the following line in file

    Score            USER_IN_BLACKLIST           10 and now the user based settings are working fine.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL ( several years ago, it seemed like now was a good time to updat…
    The purpose of this article is to demonstrate how we can use conditional statements using Python.
    In this video we show how to create an Address List in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Organization >> Ad…
    Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now