?
Solved

spamassassin, user prefs and SQL

Posted on 2014-09-17
4
Medium Priority
?
226 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 97

Expert Comment

by:Experienced Member
ID: 40329476
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
ID: 40329545
Hello John,

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

Author Comment

by:camstutz
ID: 40334341
closing this forum
0
 

Author Closing Comment

by:camstutz
ID: 40343517
I figured out my own problem.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is my first article on Expert Exchange on the Manual Method of Exporting Office 365 Mailboxes to PST format by using the eDiscovery mechanism of Office. Hope you will enjoy the article.
Pop culture is prime bait for hackers seeking to infect user’s computers and mobile devices with malicious malware. Hackers know exactly what the latest trends are online and know how to use them to their advantage.
This Micro Tutorial will demonstrate the easy use of Gmail embedding images in your email so the recipient of your email can view them in context.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Suggested Courses

770 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