Hello,
Here is the requested file:
driver = mysql connect = host=/tmp/mysql.sock dbname=mail user=mail_admin password=MainBoard55
# Last Login map { pattern = shared/last-login/$user table = virtual_users username_field = user value_field = lastlogin fields { user = $user } }
Thanks. Dave.
On 4/28/17, Aki Tuomi aki.tuomi@dovecot.fi wrote:
On April 29, 2017 at 12:29 AM David Mehler dave.mehler@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@example.com, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=16257, secured, session=
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@example.com): Error: dict-client: server returned failure: 1493414295 (reply took 0.026 secs)
Apr 28 17:18:15 ohio dovecot: imap(user@example.com): Error: last_login_dict: Failed to write value for user user@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