[Dovecot] Vacation via database
We are moving our inbound mail to use dovecot LMTP in the near future and we are looking for suggestions on how to implement a mysql based vacation system. If anyone has experience with this, good or bad please let us know.
- list@airstreamcomm.net list@airstreamcomm.net:
We are moving our inbound mail to use dovecot LMTP in the near future and we are looking for suggestions on how to implement a mysql based vacation system. If anyone has experience with this, good or bad please let us know.
Why not use sieve?
-- Ralf Hildebrandt Geschäftsbereich IT | Abteilung Netzwerk Charité - Universitätsmedizin Berlin Campus Benjamin Franklin Hindenburgdamm 30 | D-12203 Berlin Tel. +49 30 450 570 155 | Fax: +49 30 450 570 962 ralf.hildebrandt@charite.de | http://www.charite.de
On 02/03/2012 10:27 AM, Ralf Hildebrandt wrote:
- list@airstreamcomm.netlist@airstreamcomm.net:
We are moving our inbound mail to use dovecot LMTP in the near future and we are looking for suggestions on how to implement a mysql based vacation system. If anyone has experience with this, good or bad please let us know. Why not use sieve?
I am facing a similar issue. It looks like sieve can't fetch data from a database, and dovecot can't fetch sieve scripts from a database. It would be useful to have, perhaps, only a global sieve script be able to query a DB, and it would be very useful to allow dovecot to fetch sieve scripts (actual scripts, not a file path) from a database. Any way to do this?
Am 03.02.2012 17:41, schrieb Gedalya:
On 02/03/2012 10:27 AM, Ralf Hildebrandt wrote:
- list@airstreamcomm.netlist@airstreamcomm.net:
We are moving our inbound mail to use dovecot LMTP in the near future and we are looking for suggestions on how to implement a mysql based vacation system. If anyone has experience with this, good or bad please let us know. Why not use sieve?
I am facing a similar issue. It looks like sieve can't fetch data from a database, and dovecot can't fetch sieve scripts from a database. It would be useful to have, perhaps, only a global sieve script be able to query a DB, and it would be very useful to allow dovecot to fetch sieve scripts (actual scripts, not a file path) from a database. Any way to do this?
sieve with database is on roadmap,as it was discussed before ,as far i remember
info
http://wiki.dovecot.org/ManageSieve http://pigeonhole.dovecot.org/
anyway it seems there is a lot to do left http://hg.rename-it.nl/dovecot-2.1-pigeonhole/raw-file/tip/TODO so sql support might have to wait
but snip
## MAKE A FOURTH MAIN RELEASE (0.4.x) ##
Implement extlists extension as a plugin
Enotify extension: detect use of variable values extracted from the message that are used in the method argument. RFC reports this as a security issue.
Make the sieve storage a base class with (possibly) various implementations, just like mail-storage. This aims to provide support for alternate types of script storage like LDAP or SQL database.
looks its on the way
Best Regards
MfG Robert Schetterer
Germany/Munich/Bavaria
Am 03.02.2012 19:32, schrieb Robert Schetterer:
Am 03.02.2012 17:41, schrieb Gedalya:
On 02/03/2012 10:27 AM, Ralf Hildebrandt wrote:
- list@airstreamcomm.netlist@airstreamcomm.net:
We are moving our inbound mail to use dovecot LMTP in the near future and we are looking for suggestions on how to implement a mysql based vacation system. If anyone has experience with this, good or bad please let us know. Why not use sieve?
I am facing a similar issue. It looks like sieve can't fetch data from a database, and dovecot can't fetch sieve scripts from a database. It would be useful to have, perhaps, only a global sieve script be able to query a DB, and it would be very useful to allow dovecot to fetch sieve scripts (actual scripts, not a file path) from a database. Any way to do this?
sieve with database is on roadmap,as it was discussed before ,as far i remember
info
http://wiki.dovecot.org/ManageSieve http://pigeonhole.dovecot.org/
anyway it seems there is a lot to do left http://hg.rename-it.nl/dovecot-2.1-pigeonhole/raw-file/tip/TODO so sql support might have to wait
but snip
## MAKE A FOURTH MAIN RELEASE (0.4.x) ##
Implement extlists extension as a plugin
Enotify extension: detect use of variable values extracted from the message that are used in the method argument. RFC reports this as a security issue.
Make the sieve storage a base class with (possibly) various implementations, just like mail-storage. This aims to provide support for alternate types of script storage like LDAP or SQL database.
looks its on the way
by the way you can use some sql vacation script method like implemented in postfixadmin , and has support for horde webmail,squirrelmail,roundcube
-- Best Regards
MfG Robert Schetterer
Germany/Munich/Bavaria
On 02/03/2012 01:34 PM, Robert Schetterer wrote:
Am 03.02.2012 17:41, schrieb Gedalya:
On 02/03/2012 10:27 AM, Ralf Hildebrandt wrote:
- list@airstreamcomm.netlist@airstreamcomm.net:
We are moving our inbound mail to use dovecot LMTP in the near future and we are looking for suggestions on how to implement a mysql based vacation system. If anyone has experience with this, good or bad please let us know. Why not use sieve?
I am facing a similar issue. It looks like sieve can't fetch data from a database, and dovecot can't fetch sieve scripts from a database. It would be useful to have, perhaps, only a global sieve script be able to query a DB, and it would be very useful to allow dovecot to fetch sieve scripts (actual scripts, not a file path) from a database. Any way to do this?
sieve with database is on roadmap,as it was discussed before ,as far i remember
info
http://wiki.dovecot.org/ManageSieve http://pigeonhole.dovecot.org/
anyway it seems there is a lot to do left http://hg.rename-it.nl/dovecot-2.1-pigeonhole/raw-file/tip/TODO so sql support might have to wait
but snip
## MAKE A FOURTH MAIN RELEASE (0.4.x) ##
Implement extlists extension as a plugin
Enotify extension: detect use of variable values extracted from the message that are used in the method argument. RFC reports this as a security issue.
Make the sieve storage a base class with (possibly) various implementations, just like mail-storage. This aims to provide support for alternate types of script storage like LDAP or SQL database.
looks its on the way by the way you can use some sql vacation script method
Am 03.02.2012 19:32, schrieb Robert Schetterer: like implemented in postfixadmin , and has support for horde webmail,squirrelmail,roundcube
Yeap, for now, in this case, it looks like I'll be hand-coding something into exim and adapt an existing roundcube plugin to my situation. In general, it's looking like I'll be using one, global, static sieve script which will follow instructions in the form of X-Something: Action headers, which I'll be conditionally inserting per user preference on the MX end (exim lmtp transport). Since this is clumsy, I'll try to do as much as possible within the MX, and leave to sieve only things that must happen there (e.g. not necessarily vacation).
On 2/3/2012 5:41 PM, Gedalya wrote:
On 02/03/2012 10:27 AM, Ralf Hildebrandt wrote:
- list@airstreamcomm.netlist@airstreamcomm.net:
We are moving our inbound mail to use dovecot LMTP in the near future and we are looking for suggestions on how to implement a mysql based vacation system. If anyone has experience with this, good or bad please let us know. Why not use sieve?
I am facing a similar issue. It looks like sieve can't fetch data from a database, and dovecot can't fetch sieve scripts from a database. It would be useful to have, perhaps, only a global sieve script be able to query a DB, and it would be very useful to allow dovecot to fetch sieve scripts (actual scripts, not a file path) from a database. Any way to do this?
Retrieving whole scripts from a DB is nice, but not strictly necessary for your application. Indeed, only fetching data from a DB is sufficient. Unfortunately, there is no standard Sieve feature that allows fetching string data from external sources. However, Pigeonhole has a few custom features:
Assuming you're using SQL, there is an experimental plugin for retrieval of external string data from a Dovecot dict lookup (there is no LDAP dict afaik):
http://wiki2.dovecot.org/Pigeonhole/Sieve/Plugins/Extdata
You can give that a look. Should also compile against Dovecot v2.1 and Pigeonhole v0.3.
If you were using Dovecot v2.1 and Pigeonhole v0.3 (from hg) you could also tinker something with the new extprograms plugin (using the execute command):
http://hg.rename-it.nl/pigeonhole-0.3-sieve-extprograms/
For more info read: http://hg.rename-it.nl/pigeonhole-0.3-sieve-extprograms/file/tip/README
http://hg.rename-it.nl/pigeonhole-0.3-sieve-extprograms/file/tip/doc/rfc/spe...
And, as you suggested, Pigeonhole v0.3 for Dovecot v2.1 can also restrict the use of these plugins to global scripts.
Regards,
Stephan.
participants (5)
-
Gedalya
-
list＠airstreamcomm.net
-
Ralf Hildebrandt
-
Robert Schetterer
-
Stephan Bosch