last_login plugin with MySQL

[Gedalya]

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.