On 10/18/2014 10:05 AM, Gedalya wrote:
On 10/18/2014 09:33 AM, Luigi Rosa wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Luigi Rosa wrote on 18/10/2014 11:29:
Hi, I have a Dovecot test installation with MySQL userbase and authentication where I am trying to setup last_login plugin with SQL dictionary I figured out I have to use dovecot-dict-sql.conf.ext instead of dovecot-sql.conf.ext
I configured dovecot-dict-sql.conf.ext this way:
driver= mysql connect = {the connect string that works for user lookup} map { pattern = last-login table = mailbox username_field = username }
And I defined the plugin this way:
plugin { last_login_dict = sql:/etc/dovecot/dovecot-dict-sql.conf.ext last_login_key = last-login/%u # default }
But I still get the same error:
Error: last_login_dict: dict_init(sql:/etc/dovecot/dovecot-dict-sql.conf.ext) failed: Unknown dict module: sql
It's been said here before, and I'll echo it again -- better documentation for dict would be helpful, a step-by-step guide to its principles of operation, rather than just the anecdotal examples we have, out of which we're supposed to extrapolate.
"The above SQL example uses dictionary proxy process (see below), because SQL libraries aren't linked to all Dovecot binaries. The file and Redis examples use direct access. "
http://wiki2.dovecot.org/Quota/Dict
I guess you have to use the proxy.
So maybe something like
plugin { last_login_dict = proxy::lastlogin }
dict { lastlogin = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext }
I'll try it later myself, thanks for taking it thus far :-) I've been meaning to try this out but was rather perplexed.