FreeBSD+Spamassassin+MySQL
    whizkid at ValueDJ.com 
    whizkid at ValueDJ.com
       
    Wed Nov  5 15:04:18 PST 2003
    
    
  
I cannot seem to get SpamAssassin working with MySQL 4....  I have setup
the MySQL database, have given a saconfig user full access to this
database.  But SA does not seem to Query the SQL database.  I have a
SquirrelMail plugin that connects to the DataBase just fine, and writes
data to it, but SA doesn't seem to grab the data.  I have setup a local.cf
file with the following:
user_scores_dsn			DBI:mysql:sa_config:localhost
user_scores_sql_username	saconfig
user_scores_sql_password	password
user_scores_sql_table           userpref
but when I run SPAMD -D and Cat out a sample spam file, I see no SQL
lookup info, nor do I see any errors.  I searched on Spamassassins website
(the archives) have seen alot of people with this error, but not any
fixes.  I can only assume that it is with the DBI connector or the
Mysql-Mysql perl module.  I have verified that both are installed.
p5-DBD-mysql-2.9002 MySQL driver for the Perl5 Database Interface (DBI)
p5-DBI-1.38         The perl5 Database Interface.  Required for DBD::*
modules
mysql-client-4.0.16 Multithreaded SQL database (client)
mysql-server-4.0.16 Multithreaded SQL database (server)
looking at the above do I need to set the user_scores_dsn to use DBD or is
DBI correct?  Do I need to install the p5-DBIWrapper from the ports?
I am currently running FreeBSD 5.1 Current.  Thanks for any help you can
provide.
    
    
More information about the freebsd-questions
mailing list