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