From owner-freebsd-isp@FreeBSD.ORG Mon May 5 09:05:11 2003 Return-Path: Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 78C5637B401 for ; Mon, 5 May 2003 09:05:11 -0700 (PDT) Received: from accounts.amigo.net (smtp.amigo.net [209.94.64.30]) by mx1.FreeBSD.org (Postfix) with ESMTP id 80B4843F93 for ; Mon, 5 May 2003 09:05:10 -0700 (PDT) (envelope-from randys@amigo.net) Received: from stalker.amigo.net ([209.94.67.250]) by accounts.amigo.net with esmtp; Mon, 05 May 2003 10:05:09 -0600 Date: Mon, 5 May 2003 10:06:28 -0600 (MDT) From: Randy Smith X-X-Sender: randy@stalker.amigo.net To: Wolfpaw - Dale Corse In-Reply-To: Message-ID: <20030505095552.Q1406-100000@stalker.amigo.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit cc: "freebsd-isp@freebsd.org" Subject: RE: SpamAssassin Rulesets X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 05 May 2003 16:05:11 -0000 On Fri, 2 May 2003, Wolfpaw - Dale Corse wrote: > Date: Fri, 2 May 2003 09:14:05 -0600 > From: Wolfpaw - Dale Corse > To: Randy Smith > Cc: "freebsd-isp@freebsd.org" > Subject: RE: SpamAssassin Rulesets > > Hi Randy, > > User config from a webpage.. very nice. Could you perhaps > expand more on how to do that? I see what appears to be defaults > in your config there.. but how does spamassassin know what the > user selects? I store the results in a MySQL db as described in http://www.spamassassin.org/dist/sql/README. The user_scores_* settings in the config that I posted tell SA where the settings are. The username column is set to the user's email address. SA keys of that column to find the user's settings. > > Doing it via a webpage would be nice and smooth, If you wouldn't > mind dropping a few hints I would appreciate it :) Actually, I provide two interfaces. The first is based on php-sa which is listed in the README above. This code is ugly but works. The second interface is a plugin to SquirrelMail called SpamAssassin+SQL (sasql). It's a much nicer interface and a lot easier to add new supported settings to the interface. (In the intrests of full disclosure, I should mention here that I wrote sasql.) > > Regards, > Dale. > -------------------------------- > Dale Corse > System Administrator > Wolfpaw Services Inc. > http://www.wolfpaw.net > (780) 474-4095 > > > -----Original Message----- > > From: owner-freebsd-isp@freebsd.org > > [mailto:owner-freebsd-isp@freebsd.org]On Behalf Of Randy Smith > > Sent: Friday, May 02, 2003 8:33 AM > > To: Chris Cook > > Cc: > > Subject: Re: SpamAssassin Rulesets > > > > > > On Thu, 1 May 2003, Chris Cook wrote: > > > > > Date: Thu, 01 May 2003 12:56:02 -0500 > > > From: Chris Cook > > > To: "freebsd-isp@freebsd.org" > > > Subject: SpamAssassin Rulesets > > > > > > Does anyone have a really good local.cf for their > > SpamAssassin installs > > > that they use in a real-world ISP environment? I figured > > this would be > > > a good place to ask if people were willing to share their > > "tweaked" > > > config to help the spam fighters. Of course being in the ISP > > > environment the config would have to be somewhat forgiving. > > > > > > Thanks for any feedback. > > > > > > > Below is what I use. I allow users to set their own > > settings stored in a > > mysql db. Note: the 'defang_mime' and 'report_header' went > > away with SA > > 2.50-ish. (I just haven't pulled them from my config yet.) > > > > ----- > > > > use_dcc 0 > > spam_level_stars 0 > > skip_rbl_checks 0 > > dcc_add_header 1 > > allow_user_rules 0 > > all_spam_to postmaster@amigo.net abuse@amigo.net > > > > # User configurable via web page. > > rewrite_subject 0 > > report_header 1 > > defang_mime 0 > > use_terse_report 0 > > > > user_scores_dsn DBI:mysql:Accounts:10.1.1.1 > > user_scores_sql_username > > user_scores_sql_password > > user_scores_sql_table SA_userprefs > > > > > > > > -- > > Randy Smith > > Amigo.Net Systems Administrator > > 1-719-589-6100 x 4185 > > http://www.amigo.net/ > > > > _______________________________________________ > > freebsd-isp@freebsd.org mailing list > > http://lists.freebsd.org/mailman/listinfo/freebsd-isp > > To unsubscribe, send any mail to > > "freebsd-isp-unsubscribe@freebsd.org" > > > > -- Randy Smith Amigo.Net Systems Administrator 1-719-589-6100 x 4185 http://www.amigo.net/