last_login plugin with MySQL

[Luigi Rosa]

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 = </etc/xxxxx/xxxxxx.luigirosa.com.crt
ssl_dh_parameters_length = 2048
ssl_key = </etc/xxxxx/xxxxx.luigirosa.com.key
ssl_parameters_regenerate = 202 hours
ssl_protocols = !SSLv2 !SSLv3
syslog_facility = local5
userdb {
   args = /etc/dovecot/dovecot-sql.conf.ext
   driver = sql
}
verbose_proctitle = yes
protocol lmtp {
   mail_plugins = sieve
}
protocol imap {
   imap_client_workarounds = tb-extra-mailbox-sep
   mail_plugins = " stats imap_stats last_login"
}
protocol pop3 {
   pop3_client_workarounds = outlook-no-nuls
   pop3_uidl_format = %08Xu%08Xv
}




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

Microsoft launches site to help those with H1N1. No help for those
with Windows 7
     --fark.com