[Dovecot] userdb missing driver
Surreal
surreal at bsdmail.com
Thu Sep 20 18:24:16 EEST 2012
Good Day,
I'm using dovecot 2.1.8 and this is my dovecot -n output:
# 2.1.8: dovecot.conf
# OS: FreeBSD 9.0-STABLE i386
auth_default_realm = domain.xxx
auth_mechanisms = plain login
auth_realms = domainone.xxx domaintwo.xxx
disable_plaintext_auth = no
first_valid_gid = 5000
first_valid_uid = 5000
lda_mailbox_autocreate = yes
mail_gid = 5000
mail_location = maildir:~/
mail_plugins = quota expire mail_log notify
mail_temp_dir = /var/tmp
mail_uid = 5000
namespace inbox {
inbox = yes
location =
mailbox Drafts {
special_use = \Drafts
}
mailbox Junk {
special_use = \Junk
}
mailbox Sent {
special_use = \Sent
}
mailbox "Sent Messages" {
special_use = \Sent
}
mailbox Trash {
special_use = \Trash
}
prefix =
}
passdb {
args = /etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
plugin {
expire = Trash
mail_log_events = delete undelete expunge copy mailbox_delete
mailbox_rename
mail_log_fields = uid box msgid size
quota = maildir:User quota
quota2_rule = *:storage=3G
quota_rule = *:storage=3G
quota_rule2 = Trash:storage=+30%%
quota_rule3 = Sent:storage=+30%%
quota_warning = storage=95%% quota-warning 95 %u
quota_warning2 = storage=75%% quota-warning 75 %u
}
sendmail_path = /usr/local/sbin/sendmail
service auth {
unix_listener /var/spool/postfix/private/auth {
group = postfix
mode = 0660
user = postfix
}
unix_listener auth-userdb {
group = vmail
mode = 0600
user = vmail
}
}
service quota-warning {
executable = script /usr/local/bin/quota-warning.sh
unix_listener quota-warning {
user = vmail
}
user = vmail
}
ssl = no
userdb {
args = /etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
protocol imap {
mail_max_userip_connections = 3
mail_plugins = quota expire mail_log notify imap_quota imap_zlib
}
protocol pop3 {
mail_max_userip_connections = 2
}
doveconf: Fatal: Error in configuration file
/usr/local/etc/dovecot/dovecot.conf: userdb is missing driver
----------------------------
This is my dovecot-sql.conf.ext
connect = host=127.0.0.1 port=3306 user=daemonuser password=password
dbname=postfix
driver = mysql
default_pass_scheme = MD5-CRYPT
password_query = SELECT password,CONCAT('/mail/', maildir) AS userdb_home,\
'5000' AS userdb_uid, '5000' AS userdb_gid, allow_nets,\
concat('*:bytes=', quota) AS userdb_quota_rule\
FROM mailbox WHERE username='%u' AND domain='%d' AND active=1
user_query = SELECT CONCAT('/mail/', maildir) AS home, 'maildir:~/' as
mail, '5000' AS uid, '5000' AS gid,\
concat('*:bytes=', quota) AS quota_rule\
FROM mailbox WHERE username='%u' AND domain='%d' AND active=1
#iterate_query = SELECT username AS user FROM mailbox
------------------------------
I'm sure i granted all privileges to daemonuser to postfix db.
This is my first on dovecot so my knowledge is very minimal, all help
possible is very much appreciated. Thanks
More information about the dovecot
mailing list