Solved

spamassassin, user prefs and SQL

Posted on 2014-09-17
4
203 Views
Last Modified: 2014-09-25
Hello,

I am trying to store user prefs in the SQL userpref table. I want to be able to take score adjustments in local.cf and store them in the users sql database. The end goal is to have user1 be able to have a score of 1.5 for x rule and user2 to have a score of 2.0 for the same rule. From what I am reading, this should be possible.

 I understand the difference between @GLOBAL,$GLOBAL and <username>. The problem I seem to have is that scores like HTML message do not seem to work if you put it in the sql database.

Unless I misunderstand the rule, this seems to be a local rule. Whenever I add it there (the SQL DB), when matching, it has a score of 0.0. I'm wondering, and basing this conjecture off of an article, if only certain rules can be stored and used in the userpref sql database.  I

I have read this in the spamassassin forums located here: http://www.gossamer-threads.com/lists/spamassassin/users/1940?search_string=sql%20prefs%20user%20scores;

I've also googled around, but not finding much (other than the above link)

I do some some parse errors in the spamd log, this might have something to do with it, but having trouble finding an answer for solving it.

Any help would be appreciated.
0
Comment
Question by:camstutz
  • 3
4 Comments
 
LVL 90

Expert Comment

by:John Hurst
Comment Utility
I am a Spamassassin user and not a Spamassassin expert - sorry.

My user.prefs file is unique to me. There is (I think) a global prefs file or other type file that does the basic work. But I add my rules, whitelists and blacklists in my own Spamassassin prefs file. I don't think there is any need for you to control it.
I do not see Spamassassin as a user friendly tool, however, and newer spam systems use the concept of quarantines that can be released if necessary, thus whitelisting that address.
0
 

Accepted Solution

by:
camstutz earned 0 total points
Comment Utility
Hello John,

Thanks for posting, but I just now figured out my own problem :)
0
 

Author Comment

by:camstutz
Comment Utility
closing this forum
0
 

Author Closing Comment

by:camstutz
Comment Utility
I figured out my own problem.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Ransomware continues to be a growing problem for both personal and business users alike and Antivirus companies are still struggling to find a reliable way to protect you from this dangerous threat.
Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
The purpose of this video is to demonstrate how to set up a Mailchimp Template which will let the user create a uniform look for all of their campaigns. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mail…
This Micro Tutorial demonstrates  how Internet marketers work with competitive analysis data, and a common task in data preparation is creating separate column for domains. You will then extract from a list of URLs.

772 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