[Dovecot] Sieve plugin - install help - filters ignored

[Brent Hostetler]

> -----Original Message-----
> From: Timo Sirainen [mailto:tss at iki.fi]
> Sent: Wednesday, March 14, 2007 5:36 AM
> To: Brent Hostetler
> Cc: dovecot at dovecot.org
> Subject: Re: [Dovecot] Sieve plugin - install help - filters ignored
> 
> On Wed, 2007-03-14 at 05:30 -0700, Brent Hostetler wrote:
> > Trying to get sieve support and unable to get this going. First step
> > is simulating home directories.
> ..
> > Added the following to a users maildir: .dovecot.sieve
> 
> You didn't mention if you added: "mail_plugins = cmusieve" inside
> protocol lda?
> 
> Also mail_debug=yes can be helpful in figuring out what goes wrong.

mail_plugins = cmusieve was in my config file..

I added mail_debug=yes and found the problem. My sql query was setting the
users
Home incorrectly.

I changed:
 user_query = SELECT maildir, 5000 AS uid, 5000 AS gid, @home := maildir AS
home FROM mailbox WHERE username = '%u'
To:
user_query = SELECT maildir, 5000 AS uid, 5000 AS gid,
CONCAT('/usr/local/vmail/', @home := maildir) AS home FROM mailbox WHERE
username = '%u'

And the plugin loads and the mail is filtered!!

One problem with the CONCAT method is that there is an extra '/' in the
users home path. However, the filter still works
As expected. Should I be concerned?

deliver(brent at hostetler.ws): Mar 14 09:32:23 Info: cmusieve: Using sieve
path: /usr/local/vmail/hostetler.ws/brent//.dovecot.sieve

                                     ^
                                     |___ extra '/'

Thanks!

Brent.