From: Harold Paulson (haroldpsierraweb.com)
Date: Mon Oct 06 2003 - 16:59:09 CDT

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

Bill,

I have set up a system like this using postfix and courier. Managing
per-user SpamAssassin configs out of MySQL is fairly easy to do. SA
has options for this, and there is a decent SquirrelMail plugin to
allow users to manage their own configs: whitelists, blacklists, spam
score threshold, etc.

I use Courier's Maildrop as my LDA, and started with a global
Maildrop "recipe" that saved spam to a user's ~/Spam Maildir.

Maildrop is analogous in use to Procmail, but with a very different
scripting language. I like it quite a bit. I have recently rebuilt
our mail system so that the MySQL virtual users have their own
individual home directories, with their Maildirs below that. This
allows me to set up per-user Maildrop dot-files. I use them to allow
users to set up .vacation and .forward like behavior through another
custom SquirrelMail plugin.

Note: no, users do NOT get direct access to edit their dot-files, for
security reasons. Let me know if you'd like more info.

        - H

>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?

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