[Mimedefang] SpamAssassin and SQL user preferences

[Zach Lowry]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Did anyone see my post here? Can anyone on this list help me out?

Zach

> -----Original Message-----
> From: mimedefang-admin at lists.roaringpenguin.com
> [mailto:mimedefang-admin at lists.roaringpenguin.com]On Behalf Of Zach
> Lowry
> Sent: Thursday, August 29, 2002 2:22 PM
> To: mimedefang at lists.roaringpenguin.com
> Subject: RE: [Mimedefang] SpamAssassin and SQL user preferences
> 
> 
>  
> 
> *** PGP Signature Status: good
> *** Signer: Zach Lowry <zach at zachlowry.net>
> *** Signed: 8/29/2002 2:16:33 PM
> *** Verified: 8/30/2002 10:44:15 PM
> *** BEGIN PGP VERIFIED MESSAGE ***
> 
> > On Sun, 18 Aug 2002 09:20:01 -0500
> > "Zach Lowry" <zach at zachlowry.net> wrote:
> > 
> > > I'm running MIME Defang with Sendmail 8.12, Cyrus, Amavisd, and
> > > Spamassassin 2.31. I used Spamass-milter previously, but it had
> > > a a condition of creating many different spamd processes, and
> > > bogged down the server. MIMEDefang works great, but I need to
> > > use my SQL
> > > preferences I have set up for SA. It doesn't seem to be getting
> > > those by itself, even though I added the DBD entries into the
> > > sa-mimedefang.cf file. Anybody have an idea?
> > 
> > In general, it's problematic to have per-user preferences in a
> > milter because a message might be for more than one user.  If you
> > use
> > stream_by_recipient (see the mimedefang-filter man page), you can
> > do it.  But you still have to tell SA to use the SQL preferences,
> > and you'd have to read the SpamAssassin Perl module man pages and
> > probably the mimedefang.pl source to figure out how to do that.
> > 
> 
> Ok, I believe that I have it configured to stream_by_recipient. But
> I'm not sure what to add to the mimedefang.pl source to have it
> call the SQL database to query for the user preferences. I'm not an
> avid Perl programmer, so I will probably ask mostly dumb questions.
> 
> I replaced this:
> 
>         $SASpamTester = Mail::SpamAssassin->new({
>             local_tests_only   => $SALocalTestsOnly,
>             dont_copy_prefs    => 1,
>             userprefs_filename => $config});
> 
> with this:
> 
> 	$SASpamTester = Mail::SpamAssassin->load_scoreonly_sql
> (@Recipients);
> 
> But that didn't seem to work. I'm guessing because @Recipients is
> an array, and it's looking for a string. 
> 
> Am I on the right track here?
> 
> Thanks!
> 
> Zach Lowry
> 
> 
> *** END PGP VERIFIED MESSAGE ***
> 
> _______________________________________________
> MIMEDefang mailing list
> MIMEDefang at lists.roaringpenguin.com
> http://lists.roaringpenguin.com/mailman/listinfo/mimedefang

-----BEGIN PGP SIGNATURE-----
Version: PGP 7.0.4

iQA/AwUBPXWIsYHWQmQc5olOEQKPqQCfcPZ2Tk4f02dePPsmfU0dt8HmlQYAnjYQ
I8afGJLlhLIi3uZ/VqP8I5Nj
=JS9e
-----END PGP SIGNATURE-----