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