On 03/27/2012 08:06 PM, Reindl Harald wrote:
>
>
> Am 27.03.2012 19:33, schrieb Kris Oye:
>> I operate a system with nearly a ~1M user accounts. Currently our exim
>> servers deliver via pipe to dbmail-smtp,
>> but I recently found out about the LMTP protocol/dbmail_lmtpd. It sounds
>> like it has a number of benefits, but I
>> need to be able to deliver to alternate folders besides the default inbox.
>> Is there a mechanism within the
>> protocol for accomplishing this? Or an Exim-specific way? I am combing
>> through search results but not finding
>> much useful information (do I HAVE to use sieve?)
>
> Sieve -> http://en.wikipedia.org/wiki/Sieve_%28mail_filtering_language%29
There is also native filtering. Not as powerfull as sieve for most
use-cases, but it has global filters, which sieve doesn't have.
doc/README.filters
DBMail support simple SQL bases filter rules. These can be assigned
per user, or globally by assigning them to the 'anyone' user.
The dbmail_filters table contains the following fields:
id BIGINT NOT NULL AUTO_INCREMENT
user_id BIGINT NOT NULL
headername varchar(128) NOT NULL
headervalue varchar(255) NOT NULL
mailbox varchar(100) NOT NULL
Headernames in this table must be lower-cased since they are joined
on the dbmail_headernames table which only contains lower-cased values.
Headervalues are matched as case-insensitive LIKE. They may contain
LIKE-style match expressions.
So:
If a message's headers look like:
From: Foo Bar <[email protected]>
Subject: this is a test
Rules would match as follows:
| headername | headervalue | match?
---+--------------+--------------------------+-------
| from | [email protected] | no
| from | Foo Bar <[email protected]> | yes
| from | %[email protected]% | yes
| subject | test | no
| subject | test% | yes
---+--------------+--------------------------+-------
--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin
* Premium Hosting Services and Web Application Consultancy *
www.nfg.nl/[email protected]/+31.85.877.99.97
________________________________________________________________
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
