[Dovecot] sieve in sql or reporting

[Stephan Bosch]

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

Regards,

Stephan.