last_login plugin with MySQL

[Luigi Rosa]

-----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




Ciao,
luigi

- -- 
/
+--[Luigi Rosa]--
\

Every program has (at least) two purposes: the one for which it was written
and another for which it wasn't.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBAgAGBQJUQmwfAAoJEO5WT/qgw4yKgV0P/iGjH7Tcy/tfCf9fVjECO187
fa07fBXwG+BR9CqDejmNeT0qGC8Vx3YebWl3Sc61N8z6CMXzwQUo4gAsLnw3bW/3
VTioxcZKULbE8bNE8goN/yrNur1N4yMcrQTSb+Lno4D5adXfWdXC2j8nwRrAnjXf
om4XvWP+S/PX7oblqymNCHWtJhmOwPkCPKqKqpXxdZ4SXQHCb+96NI4Mkbp1WVEr
1npH8+p1ut8s1wjwGo56tE+EplJKNp4oMhQch4nHQp6uWnAH3IF6P8T23iLnog7p
wuG0e2Mo1vDoMWaf7J+6lIUB45OizgA1qAHho5jpASCGQE5D/XqolRzTTvJJ2Ykh
Jgll8Gc+/JqMeHX5XlsUsVdPGEFIvwTGyKjZB90qA5UPOJf6hgRQbcVam3iUDBRW
v+KRrtPuTeExDj9nfxL1QZAwoFW6QY+mUNvS+jgb1vGmQlCK12lUgBzVPi1d72sN
boHmpmGfLnl97cg+FjrAtU8N0aBeoOkIqECmLSmnQwdwz+PkoyrgKvAVt4IgI0aX
WVNBSy1cir+/I2c9EY+FTYyRczSaRglTMBwLMM1O910NMRvsZmqniTCvfBnhv4Xv
95GhLhisAp/TBUSD8Jnk+K76Un/xfNSAex1t6NeyVdEKSOiqVlSMYo8o5wHBzaXV
A6ztvItzmTnfOux5C03q
=6gvz
-----END PGP SIGNATURE-----