OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: filtering and MySQL virtual users

From: Chris Masters (rotis23yahoo.com)
Date: Thu Oct 02 2003 - 07:10:55 CDT

I've got this working with postfix maildrop and
courier-imap.

use maildropmysql.config to tell maildrop where the
users virtual mailbox resides on the filesystem.

I have had to patch the code to create maildir and
sub-maildirs on-the-fly and to use a virtual mailbox
base.

You can filter into sub-maildirs based on headers
(such as X-Spam-Status) using a global maildroprc
filter file in /etc/maildroprc.

Check out man for maildrop and maildropfilter for
filter rules.

Check out maildrop mailing list for patches.

Good luck.

--- Bill Pitz <billsvn.net> wrote:
> I'm trying to set up a system that's based entirely
> on "virtual" users whose
> information lives in a MySQL database. I haven't
> had any problem doing that
> so far, but now I'm getting into the more
> complicated issues. My goal is to
> have virus scanning, spam filtering, and a sort of
> "graymail" system where
> users can sift through the spam for a week or two in
> case something
> important gets flagged as spam.
>
> So far, I have the following things set up and they
> seem to be working
> without a hitch:
> - Postfix
> - Courier IMAP
> - Amavisd-new (using Sophie for virus scanning and
> SpamAssassin for
> spam filtering)
>
> I've managed to get amavisd-new to read user
> filtering preferences out of
> the MySQL database, but I now want to take that one
> step further by
> having an additional option to save the spam in a
> separate IMAP folder
> (i.e. INBOX.graymail) where the users can access it
> via IMAP.
>
> I looked at maildir as a possibility, but it looks
> like it wants to have
> all of the filters set up as files in the user's
> directory (which is
> actually just their mail directory, in this case).
> I'd prefer to have
> something that will read all of the options from a
> MySQL database.
>
> Are there any solutions to this situation out there
> that anyone's
> aware of?
>
> Thanks in advance,
>
> -Bill

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com