Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

spamassassin, user prefs and SQL

Posted on 2014-09-17
4
Medium Priority
?
236 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 100

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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

One-stop solution for Exchange Administrators to address all MS Exchange Server issues, which is known by the name of Stellar Exchange Toolkit.
Steps to fix error: “Couldn’t mount the database that you specified. Specified database: HU-DB; Error code: An Active Manager operation fail”
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Suggested Courses

580 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