[Dovecot] Performing an action on mail receipt

[Andrew Beverley]

On Wed, 2014-05-14 at 11:41 +0200, Jiri Bourek wrote:
> > By user, I'd like to retrieve from a SQL database firstly which Sieve
> > script to run (if applicable) and secondly the parameters for that
> > particular user, in this case the external email address to notify.
> 
> AFAIK PigeonHole can read scripts only from file. Being able to use SQL 
> database as data source would sure be nice and I recall there was some 
> short discussion about it, but - again, AFAIK - it was never added as a 
> feature.

Okay, I managed to get this working without too much of a problem. I've
updated the wiki:

http://wiki2.dovecot.org/Pigeonhole/Sieve/Configuration/Dict

> > As I understand it, I'll need to use the Extdata plugin to retrieve data
> > values per-user. I've successfully compiled and installed this plugin,
> > but I'm not sure how to connect it to a dict.
> 
> Tried that too for optional spamassassin test and failed, see 
> https://www.mail-archive.com/dovecot@dovecot.org/msg57539.html . IMO 
> documentation for this map and dict thing is a nightmare to say the 
> least (or if there is something, Google doesn't know about it.)
> 
> Anyway, this is what I came up with:

[...]

Thanks for that. I've just about got it working, and have also updated
the wiki:

http://wiki2.dovecot.org/Pigeonhole/Sieve/Plugins/Extdata

I have run into one problem though:

extdata is looking for the dict proxy at the locate "/dict" (in the root
directory). I've had to create a symlink to the actual location
in /var/run/dovecot. I'm guessing that maybe I've missed a config option
when compiling. Anybody know what I'm doing wrong?

Also, are there any plans to formally release the extdata plugin as part
of Sieve?

Thanks,

Andy