last_login plugin with MySQL

[Gedalya]

On 10/18/2014 10:48 AM, Gedalya wrote:
>>
>> If I chmod 777 /var/run/dovecot/dict the error disappears but I get 
>> this:
>>
>> dovecot: imap-login: Login: user=<username>, method=PLAIN, 
>> rip=127.0.0.1,
>> lip=127.0.0.1, mpid=497913, secured, session=<6R0mYbMFFwB/AAAB>
>> dovecot: dict: Error: sql dict set: Invalid/unmapped key:
>> shared/last-login/username
> Ok, what were you thinking when you defined this pattern = 
> /shared/last-login/$user ?
> I personally don't understand this part of the dovecot config at all..
>
> Let's look into this.. 
OK I suspect that"

pattern = shared/{dictionary name}/$user

So:

pattern = shared/lastlogin/$user

As per:

dict {
   lastlogin = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext
   mode = 0660
   user = 501
}