[Dovecot] sieve in sql or reporting
With dovecot2 and pigeonhole sieve/managesieve is it currently possible to store sieve rules in an sql database?
If not is there a way to query all accounts; looking for things like active vacation rules?
Regards, Bradley Giesbrecht
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...
Regards,
Stephan.
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...
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.
On Sat, 24 Dec 2011 05:35:59 +0100 Stephan Bosch articulated:
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...
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."; }
I know this isn't strictly part of this topic; however, I was wondering if sieve had acquired the ability to "forward as attachment" a received email? I know it did not have that ability previously. It is something that I could really use.
-- Jerry ♔
Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header.
On 12/24/2011 11:53 AM, Jerry wrote:
I know this isn't strictly part of this topic; however, I was wondering if sieve had acquired the ability to "forward as attachment" a received email? I know it did not have that ability previously. It is something that I could really use.
In the standard Sieve language this is still not possible. It is possible to "enclose" an e-mail, but it is explicitly not allowed to redirect something like that; it can only be stored. I still don't know why. Also, the enclose extension is not implemented for Pigeonhole so far.
If you need it for a very specific task, you can try the sieve_pipe plugin for Dovecot v2.0:
http://wiki2.dovecot.org/Pigeonhole/Sieve/Plugins/Pipe
You can then write your own script that does the forward-as-attachment action. As I indicated earlier, I'm working on a more intricate plugin for Dovecot v2.1.
Regards,
Stephan
On Sat, 24 Dec 2011 12:30:00 +0100 Stephan Bosch articulated:
On 12/24/2011 11:53 AM, Jerry wrote:
I know this isn't strictly part of this topic; however, I was wondering if sieve had acquired the ability to "forward as attachment" a received email? I know it did not have that ability previously. It is something that I could really use.
In the standard Sieve language this is still not possible. It is possible to "enclose" an e-mail, but it is explicitly not allowed to redirect something like that; it can only be stored. I still don't know why. Also, the enclose extension is not implemented for Pigeonhole so far.
If you need it for a very specific task, you can try the sieve_pipe plugin for Dovecot v2.0:
http://wiki2.dovecot.org/Pigeonhole/Sieve/Plugins/Pipe
You can then write your own script that does the forward-as-attachment action. As I indicated earlier, I'm working on a more intricate plugin for Dovecot v2.1.
Thank you very much for your extremely rapid response.
-- Jerry ♔
Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header.
Am 24.12.2011 12:30, schrieb Stephan Bosch:
On 12/24/2011 11:53 AM, Jerry wrote:
I know this isn't strictly part of this topic; however, I was wondering if sieve had acquired the ability to "forward as attachment" a received email? I know it did not have that ability previously. It is something that I could really use.
In the standard Sieve language this is still not possible. It is possible to "enclose" an e-mail, but it is explicitly not allowed to redirect something like that; it can only be stored. I still don't know why. Also, the enclose extension is not implemented for Pigeonhole so far.
If you need it for a very specific task, you can try the sieve_pipe plugin for Dovecot v2.0:
http://wiki2.dovecot.org/Pigeonhole/Sieve/Plugins/Pipe
You can then write your own script that does the forward-as-attachment action. As I indicated earlier, I'm working on a more intricate plugin for Dovecot v2.1.
Regards,
Stephan
many people would like to see "forward as attachment" in sieve but i guess there must be good tec reasons why it was not done since yet
i thought about it as an advanced notify action ? that should be possible
Merry X-Mas !
Best Regards
MfG Robert Schetterer
Germany/Munich/Bavaria
On Dec 23, 2011, at 8:35 PM, Stephan Bosch wrote:
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...
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."; }
Stephan, thank you for both responses.
My idea was to add sieve rules to a report so I could look up an email address and explain to the user why things happen.
I can read in the users sieve scripts from the file system, or put them into sql myself for that matter. If a managesieve query command already existed I would use that.
Regards, Bradley Geisbrecht
participants (4)
-
Bradley Giesbrecht
-
Jerry
-
Robert Schetterer
-
Stephan Bosch