[Dovecot] sieve in sql or reporting

[Stephan Bosch]

On 12/24/2011 5:26 AM, Stephan Bosch wrote:
> On 12/24/2011 3:28 AM, Bradley Giesbrecht wrote:
>> With dovecot2 and pigeonhole sieve/managesieve is it currently 
>> possible to store sieve rules in an sql database?
> Unfortunately, not yet. It is listed somewhere on the TODO list, but 
> it does not have high priority so far.
>
>> If not is there a way to query all accounts; looking for things like 
>> active vacation rules?
>
> I'm working on an evolution of the sieve_pipe plugin called the 
> sieve_extprograms plugin. One of the things it adds is a new action 
> command called "execute", which may suit your needs. It will only be 
> available for Dovecot v2.1 though. You can read the latest version of 
> the specification here (example 4 should match your application):
>
> http://hg.rename-it.nl/pigeonhole-0.3-sieve-extprograms/raw-file/tip/doc/rfc/spec-bosch-sieve-extprograms.txt 
>

Oh btw, if you are looking for a way to disable vacation rules after 
some period of time, you can use the date extension 
(http://tools.ietf.org/html/rfc5260#section-4). For example:

require ["date", "relational", "vacation"];

if currentdate :value "le" "date" "2011-12-09" {
        vacation "I'm out of office this week. I'll be back on Saturday 
10th to reply to your e-mails.";
}

Regards,

Stephan.