I only know of three widely-used server-side email sorting
technologies.

If you were to switch to Cyrus, it includes Sieve. Cyrus requires
that you also change your mailbox format. I don't know if Cyrus
supports getting virtual user info direct from PostgreSQL. Sieve has
the advantage that it was designed to be offered as a service for
virtual users; the language itself is designed to avoid including
the ability for users to run arbitrary commands on the server.

If you were to switch to maildrop, you can stay with Maildirs.
Again, I don't know if maildrop supports PostgreSQL. If you went
with maildrop, you'd be wanting to provide some controlled mechanism
for configuring the mail filtering rules; maildrop is too expressive
to allow virtual users to edit directly --- it can run arbitrary
programs. You could write users' mailfilters for them (if you don't
have too many, or you only want to offer a few options), or you can
set up some translator from a simple, safe language --- e.g. Sieve
--- and let them edit that.

The third server-side mail filtering tool I know of is procmail; I
don't know how you'd do virtual users with procmail. I don't know of
any reason to prefer procmail over maildrop for this application,
and maildrop does have native virtual user support.

Re the PostgreSQL support, if the solution you like doesn't support
it, it's not hard to add a periodic dump of the needed info from
PostgreSQL into whatever format is supported.

-Bennett

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE964AoHZWg9mCTffwRAow4AJ4uztk5WdB2bOfaC+/ZEkr6Czx/YwCfX6Wr
kLzIHVlWMfmh8eb+MObD0Ew=
=bV8u
-----END PGP SIGNATURE-----

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