Date: Mon, 5 May 2003 10:06:28 -0600 (MDT) From: Randy Smith <randys@amigo.net> To: Wolfpaw - Dale Corse <admin-lists@wolfpaw.net> Cc: "freebsd-isp@freebsd.org" <freebsd-isp@freebsd.org> Subject: RE: SpamAssassin Rulesets Message-ID: <20030505095552.Q1406-100000@stalker.amigo.net> In-Reply-To: <AJENJFOLCLAHHIIGCCHNAEAOGFAA.admin-lists@wolfpaw.net>
next in thread | previous in thread | raw e-mail | index | archive | help
On Fri, 2 May 2003, Wolfpaw - Dale Corse wrote: > Date: Fri, 2 May 2003 09:14:05 -0600 > From: Wolfpaw - Dale Corse <admin-lists@wolfpaw.net> > To: Randy Smith <randys@amigo.net> > Cc: "freebsd-isp@freebsd.org" <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 <ccook@tcworks.net> > > > To: "freebsd-isp@freebsd.org" <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> > > user_scores_sql_password <pass> > > 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/
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030505095552.Q1406-100000>