User Management Spam Score not working

[Barry Bourdage]

You must reload MailWatch, or wait for the timeout of the reload,
typically 15 minutes or so.

Barry 

-----Original Message-----
From: mailscanner-bounces at lists.mailscanner.info
[mailto:mailscanner-bounces at lists.mailscanner.info] On Behalf Of Jeff
Ramsey
Sent: Saturday, July 15, 2006 10:00 PM
To: mailscanner at lists.mailscanner.info
Subject: User Management Spam Score not working

Hi All,

	First post to the list. I just got MailScanner and MailWatch up
and running yesterday. I'm very impressed. Every issue that I ran into,
was just a search away. Every issue except one...

	If I change the Spam Score or High Spam Score on the User
Management page of the MailWatch, it does update the database record for
that user, but MailScanner does not use this score. For instance, if I
set the SPAM SCORE for my user account to 4 instead of my default 5,
when I receive an email, it is evaluated with 5 being the required
number of hits for the message to be labeled Spam.

	Prior to running MailWatch/MailScanner, I was using Spamassassin
3.0.3 with Sendmail and Spamass-milter, and I created a spamassassin
MySQL database with a userprefs table that had a per user spam score
column, and I had to set the spam score in the local.cf file to the
following:

user_scores_dsn                  DBI:mysql:spamassassin:localhost:3306
user_scores_sql_password         password
user_scores_sql_username         username
user_scores_sql_custom_query     SELECT preference, value FROM  
_TABLE_ WHERE username = _USERNAME_ OR username = '$GLOBAL' OR username
= CONCAT('%',_DOMAIN_) ORDER BY username ASC

Do I just need to set the same or similar variables in /etc/
MailScanner/spam.assassin.prefs.conf, or is there something in the
Installation instructions that I overlooked?

Thanks,

Jeff Ramsey
jefframsey at tubafor.com