From: Bill Pitz (billsvn.net)
Date: Wed Oct 01 2003 - 18:35:56 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]