last_login plugin with MySQL

[Gedalya]

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.