> On April 29, 2017 at 12:29 AM David Mehler <dave.meh...@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=<u...@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(u...@example.com): Error: > dict-client: server returned failure: 1493414295 (reply took 0.026 > secs) > > Apr 28 17:18:15 ohio dovecot: imap(u...@example.com): Error: > last_login_dict: Failed to write value for user u...@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