[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