From owner-freebsd-questions@FreeBSD.ORG  Wed Nov  5 15:04:18 2003
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id A942E16A4CE
	for <freebsd-questions@freebsd.org>;
	Wed,  5 Nov 2003 15:04:18 -0800 (PST)
Received: from ns1.valuedj.com (adsl-216-100-130-21.dsl.snfc21.pacbell.net
	[216.100.130.21])
	by mx1.FreeBSD.org (Postfix) with ESMTP id EF25143FBD
	for <freebsd-questions@freebsd.org>;
	Wed,  5 Nov 2003 15:04:17 -0800 (PST)
	(envelope-from whizkid@ValueDJ.com)
Received: by ns1.valuedj.com (Postfix, from userid 80)
	id 1C98E60EA; Wed,  5 Nov 2003 15:04:07 -0800 (PST)
Received: from 208.253.246.93 (proxying for unknown)
        (SquirrelMail authenticated user whizkid)
        by ns1.valuedj.com with HTTP;
        Wed, 5 Nov 2003 15:04:07 -0800 (PST)
Message-ID: <15160.208.253.246.93.1068073447.squirrel@ns1.valuedj.com>
Date: Wed, 5 Nov 2003 15:04:07 -0800 (PST)
From: whizkid@ValueDJ.com
To: freebsd-questions@freebsd.org
User-Agent: SquirrelMail/1.4.2
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority: 3
Importance: Normal
Subject: FreeBSD+Spamassassin+MySQL
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 05 Nov 2003 23:04:18 -0000

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.