Skip site navigation (1)Skip section navigation (2)
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>