last_login plugin with MySQL

18 Oct 2014


      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 read http://wiki2.dovecot.org/Plugins/LastLogin and I addes this to my
configuration
plugin {
last_login_dict = sql:/etc/dovecot/dovecot-sql.conf.ext
}
mail_plugins = $mail_plugins stats
protocol imap {
mail_plugins = $mail_plugins imap_stats last_login
}
When I log in with IMAP I get this error:
Error: last_login_dict: dict_init(sql:/etc/dovecot/dovecot-sql.conf.ext) failed:
Unknown dict module: sql
/etc/dovecot/dovecot-sql.conf.ext is the file taht contains the SQL configuration.
If I put mysql instead of sql the result is the same:
Error: last_login_dict: dict_init(mysql:/etc/dovecot/dovecot-sql.conf.ext)
failed: Unknown dict module: mysql
The output of doveconf -n follows.
Do you have any idea on how to use MySQL for last_login?
Ciao,
luigi
# 2.2.14: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.32-431.29.2.el6.x86_64 x86_64 CentOS release 6.5 (Final)
auth_cache_negative_ttl = 0
auth_cache_size = 100 k
auth_cache_ttl = 8 hours
auth_mechanisms = plain login digest-md5 cram-md5
auth_verbose = yes
base_dir = /var/run/dovecot/
listen = 127.0.0.1, 10.19.67.253
login_greeting = Ready.
login_trusted_networks = 10.xx.xx.0/24, 2001:xxxx:xxxx:xxxx::/64
mail_plugins = " stats"
mailbox_list_index = yes
maildir_stat_dirs = yes
passdb {
args = /etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
plugin {
last_login_dict = mysql:/etc/dovecot/dovecot-sql.conf.ext
sieve = ~/.dovecot.sieve
sieve_dir = ~/sieve
stats_refresh = 10s
stats_track_cmds = yes
}
protocols = imap
service auth {
unix_listener /var/spool/postfix/private/auth {
group = postfix
mode = 0660
user = postfix
}
}
service imap-login {
inet_listener imap {
port = 143
}
inet_listener imaps {
port = 993
ssl = yes
}
}
service managesieve-login {
inet_listener sieve {
port = 4190
}
}
service pop3-login {
inet_listener pop3 {
port = 110
}
inet_listener pop3s {
port = 995
ssl = yes
}
}
service stats {
fifo_listener stats-mail {
mode = 0666
}
}
ssl_cert = 
--
/
+--[Luigi Rosa]--
\
Microsoft launches site to help those with H1N1. No help for those
with Windows 7
--fark.com