From owner-freebsd-questions@FreeBSD.ORG Sat Jun 9 06:35:07 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 94CEB16A468 for ; Sat, 9 Jun 2007 06:35:07 +0000 (UTC) (envelope-from bounces@nabble.com) Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by mx1.freebsd.org (Postfix) with ESMTP id 75D1013C457 for ; Sat, 9 Jun 2007 06:35:07 +0000 (UTC) (envelope-from bounces@nabble.com) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1HwuXS-0006Vg-Vn for freebsd-questions@freebsd.org; Fri, 08 Jun 2007 23:35:06 -0700 Message-ID: <11037822.post@talk.nabble.com> Date: Fri, 8 Jun 2007 23:35:06 -0700 (PDT) From: Peter Pluta To: freebsd-questions@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: peter@placidpublishing.net Subject: Spamassassin Bayes/mySQL + Amavisd-new X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 09 Jun 2007 06:35:07 -0000 I've been getting some nasty spam and need to setup bayes. I'm running amavisd-new with spamassassin. I haven't been able to find any guides... so it's kind of hard. The only one I have been able to find is this one. http://www.maiamailguard.com/maia/wiki/SpamAssassin3SQLBayes but it pertains to maia-mailguard more then amavisd-new. This is my local.cf config: # Enable the Bayes system use_bayes 1 bayes_store_module Mail::SpamAssassin::BayesStore::SQL bayes_sql_dsn DBI:mysql:bayes:localhost bayes_sql_username bayes bayes_sql_password bayes and I added the SQL that I found on that link; however, it doesn't seem to be connecting. It tried to connect as root, not sure why. Also, is bayasian per user or sitewide? I'm kind of confused as to where I should even start with this because of the lack of guides. I found this: http://wiki.apache.org/spamassassin/BetterDocumentation/SqlReadmeBayes but it's pretty broad too so i'm not sure. Has anyone done it with amavisd-new? -- View this message in context: http://www.nabble.com/Spamassassin-Bayes-mySQL-%2B-Amavisd-new-tf3893449.html#a11037822 Sent from the freebsd-questions mailing list archive at Nabble.com.