Solved

spamassassin, user prefs and SQL

Posted on 2014-09-17
4
212 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 93

Expert Comment

by:John Hurst
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

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