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!
-----Original Message----- From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] 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. 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 <foo...@dot.com> Subject: this is a test Rules would match as follows: | headername | headervalue | match? ---+--------------+--------------------------+------- | from | foo...@dot.com | no | from | Foo Bar <foo...@dot.com> | yes | from | %foo...@dot.com% | 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/i...@nfg.nl/+31.85.877.99.97 ________________________________________________________________ _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
