Solved

spamassassin, user prefs and SQL

Posted on 2014-09-17
4
221 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 95

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

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

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

We are happy to announce a brand new addition to our line of acclaimed email signature management products – CodeTwo Email Signatures for Office 365.
As cyber crime continues to grow in both numbers and sophistication, a troubling trend of optimization has emerged over the last year.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

707 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