We're running dbmail 2.2 and I don't see that table in our schema or the referenced doc in the source I built from, but the native filtering sounds ideal for our use (doesn't need to be all powerful). I guess it might be time to look at migrating to a new version. Thanks for that info!
From: firstname.lastname@example.org [mailto:email@example.com] On Behalf Of Paul J Stevens
Sent: Tuesday, March 27, 2012 11:19 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] exim lmtp delivery to named folder with dbmail?
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.
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.
If a message's headers look like:
From: Foo Bar <firstname.lastname@example.org>
Subject: this is a test
Rules would match as follows: | headername | headervalue | match?
---+--------------+--------------------------+------- | from | email@example.com | no
| from | Foo Bar <firstname.lastname@example.org> | yes
| from | %email@example.com% | yes
| subject | test | no
| subject | test% | yes
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin
* Premium Hosting Services and Web Application Consultancy *
DBmail mailing list
DBmail mailing list