On Tue, 12 Aug 2003, Greg Earle wrote:

> Date: Tue, 12 Aug 2003 20:25:18 -0700
> From: Greg Earle <[EMAIL PROTECTED]>
> To: "[EMAIL PROTECTED]"
>     <[EMAIL PROTECTED]>
> Subject: [courier-users] OT: Integrating SpamAssassin,
>      MySQL and Courier 0.42.2 + virtual users
>
> This isn't strictly Courier-related, so I'll keep it brief:
>
> I'm using Courier 0.42.2 and am trying to use SpamAssassin 2.60 with it,
> keeping user prefs in a MySQL 4.0.14 database.
>
> Because I'm using virtual users with Courier, I can't find any code to
> do what I want to do that groks doing authentication against the Courier
> userdb (unlike, say, IMP/Horde, which works perfectly with Courier and
> a virtual userdb).  The only code I can find on the SpamAssassin site
> to interface to the MySQL stuff assumes you're going to authenticate
> against the "passwd" file (it wants to talk to "pwauth" on the Web
> server end - something taken from an Apache module, I gather).
>
> If anyone's done this successfully somehow, please contact me privately.

You can use a global maildrop rule to do it. This is what I use. (User's
config is stored in a MySQL DB.

import RECIPIENT
import HOME

xfilter "/usr/local/bin/spamc -u $RECIPIENT"
if (/^X-Spam-Status: Yes/:h)
{
        to "./Maildir/.Spam/."
}


>
> We love the virtual domain/user concept in Courier, but need to provide
> a way for people to be able to manipulate their SpamAssassin preferences
> and settings somehow, without being able to log on (since they can't).

I have a SquirrelMail plugin that lets users change settings stored
in MySQL. It's on the SquirrlMail site.

>
> Thanks,
>
>       - Greg
>
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
> _______________________________________________
> courier-users mailing list
> [EMAIL PROTECTED]
> Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
>

-- 
Randy Smith
Amigo.Net Systems Administrator
1-719-589-6100 x 4185
http://www.amigo.net/


-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
courier-users mailing list
[EMAIL PROTECTED]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users

Reply via email to