Dovecot last_login plugin and Mysql

[Aki Tuomi]

> On April 29, 2017 at 12:29 AM David Mehler <dave.mehler at gmail.com> wrote:
> 
> 
> Hello,
> 
> Trying to implement lastlogin via mysql. I'm getting an unknown column
> username which I don't get. Here's the log:
> 
> Apr 28 17:18:15 ohio dovecot: imap-login: Login:
> user=<user at example.com>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1,
> mpid=16257, secured, session=<KxiSnEBOwUx/AAAB>
> 
> Apr 28 17:18:15 ohio dovecot: dict(17099): Error: sql dict: commit
> failed: Unknown column 'username' in 'field list'
> 
> Apr 28 17:18:15 ohio dovecot: imap(user at example.com): Error:
> dict-client: server returned failure: 1493414295 (reply took 0.026
> secs)
> 
> Apr 28 17:18:15 ohio dovecot: imap(user at example.com): Error:
> last_login_dict: Failed to write value for user user at example.com
> 
> 
> 

You can configure all this in dovecot-dict-sql.conf, which you have not provided. The actual column names are defined there.

Aki