Our installation is somewhat simple. We have a global .procmailrc file that pipes everything through spamc (we have a running spamd process) to flag incoming spam. It worked wonderfully.
In the /etc/mai/spamassassin/local.cf, I have: user_scores_dsn DBI:mysql:Email:localhost user_scores_sql_username mydbuser user_scores_sql_password mydbpasswd
Now, when I run spamd in the foreground with the -D option, and I run something through the spamc process, I never see it match the email against what exists in the whitelist entries in the database.
The database looks like the following: mysql> show fields from userpref; +------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+----------------+ | username | varchar(100) | | MUL | | | | preference | varchar(30) | | | | | | value | varchar(100) | | | | | | prefid | int(11) | | PRI | NULL | auto_increment | +------------+--------------+------+-----+---------+----------------+
Now, on startup, it does mention that it was successful in getting a DB connection, but, aside from that, I have not seen any other activity relating to the database... Is there something that I have missed here?
In the debug tests I have run with a clean message from an address in my whitelist (stored in the database), I see:
debug: bayes: Database connection established
debug: bayes: found bayes db version 3
debug: bayes: Using userid: 2
debug: Score set 3 chosen.
But, it's like it is not using the database at all....
Any ideas as to where I can begin to look? -Rich
