Bug 4615 - mysql connection - user prefs - Windows System
Summary: mysql connection - user prefs - Windows System
Status: RESOLVED INVALID
Alias: None
Product: Spamassassin
Classification: Unclassified
Component: Libraries (show other bugs)
Version: unspecified
Hardware: Other other
: P5 normal
Target Milestone: Undefined
Assignee: SpamAssassin Developer Mailing List
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-10-03 12:44 UTC by Michael Geidobler
Modified: 2005-10-03 04:53 UTC (History)
1 user (show)


Attachment Type Modified Status Actions Submitter/CLA Status
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Geidobler 2005-10-03 12:44:27 UTC 
I run spamassassian on Windows Server 2003, Exchange 2003 with the Event-Sink 
from Christopher Lewis (http://www.christopherlewis.com/). 
I have a problem with mysql user preferences. The awl, bayes and all another 
functions work fine. But the user preferences in table "userpref" were 
completely ignored. I tested the spamassassian with a XP Machine and there is 
the same problem. I read, that i must add "-q -x" to spamassassian 
commandline, but with spamassassian.bat, it's impossible.

Maybe it is a bug..?

local.cf:


auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList
user_awl_dsn                DBI:mysql:spamdb:localhost:3306
user_awl_sql_username       -------
user_awl_sql_password       -------
user_awl_sql_table          awl

bayes_store_module     Mail::SpamAssassin::BayesStore::SQL
bayes_sql_dsn	          DBI:mysql:spamdb:localhost:3306
bayes_sql_username          -------
bayes_sql_password	    -------

user_scores_dsn DBI:mysql:spamdb:localhost:3306
user_scores_sql_username	-------
user_scores_sql_password	-------
#user_scores_sql_custom_query  SELECT preference, value FROM userpref
Comment 1 Michael Parker 2005-10-03 12:53:11 UTC 
SQL user prefs only work with spamd.