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