[Dovecot] userdb missing driver
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
Am 20.09.2012 17:24, schrieb Surreal:
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
doveconf: Fatal: Error in configuration file /usr/local/etc/dovecot/dovecot.conf: userdb is missing driver
connect = host=127.0.0.1 port=3306 user=daemonuser password=password dbname=postfix driver = mysql
no idea about BSD but on linux systems these are typically seperated packages
dovecot-2.1.10-4.fc17.20120919.rh.x86_64 dovecot-mysql-2.1.10-4.fc17.20120919.rh.x86_64
On 09/20/2012 05:43 PM, Reindl Harald wrote:
Am 20.09.2012 17:24, schrieb Surreal:
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
doveconf: Fatal: Error in configuration file /usr/local/etc/dovecot/dovecot.conf: userdb is missing driver
connect = host=127.0.0.1 port=3306 user=daemonuser password=password dbname=postfix driver = mysql no idea about BSD but on linux systems these are typically seperated packages
dovecot-2.1.10-4.fc17.20120919.rh.x86_64 dovecot-mysql-2.1.10-4.fc17.20120919.rh.x86_64
if you install from FreeBSD ports you need to enable the MYSQL backend during configuration ( make config )
On Thu, 20 Sep 2012 17:57:17 +0200 Frank Bonnet articulated:
if you install from FreeBSD ports you need to enable the MYSQL backend during configuration ( make config )
If you don't install Dovecot via the FreeBSD ports system, you are just asking for problems. As previously stated, do run "make config" and perhaps "make config-recursive" prior to actually attempting to build the port.
-- Jerry ♔
Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header.
On 9/21/2012 12:12 AM, Jerry wrote:
On Thu, 20 Sep 2012 17:57:17 +0200 Frank Bonnet articulated:
if you install from FreeBSD ports you need to enable the MYSQL backend during configuration ( make config ) If you don't install Dovecot via the FreeBSD ports system, you are just asking for problems. As previously stated, do run "make config" and perhaps "make config-recursive" prior to actually attempting to build the port.
I did, MySQL is ticked when i build dovecot2 from /usr/ports/mail/dovecot2/
On 12-09-20 12:35 PM, Surreal wrote:
On 9/21/2012 12:12 AM, Jerry wrote:
On Thu, 20 Sep 2012 17:57:17 +0200 Frank Bonnet articulated:
if you install from FreeBSD ports you need to enable the MYSQL backend during configuration ( make config ) If you don't install Dovecot via the FreeBSD ports system, you are just asking for problems. As previously stated, do run "make config" and perhaps "make config-recursive" prior to actually attempting to build the port.
I did, MySQL is ticked when i build dovecot2 from /usr/ports/mail/dovecot2/ If you do dovecot --build-options, does it list mysql?
root@mail:~# dovecot --build-options Build options: ioloop=kqueue notify=kqueue ipv6 openssl io_block_size=8192 Mail storages: shared mdbox sdbox maildir mbox cydir imapc pop3c raw SQL drivers: mysql Passdb: checkpassword pam passwd passwd-file sql Userdb: checkpassword nss passwd prefetch passwd-file sql
-- Daryl Richards Isle Technical Services Inc.
On 9/21/2012 2:42 AM, Daryl Richards wrote:
On 12-09-20 12:35 PM, Surreal wrote:
On 9/21/2012 12:12 AM, Jerry wrote:
On Thu, 20 Sep 2012 17:57:17 +0200 Frank Bonnet articulated:
if you install from FreeBSD ports you need to enable the MYSQL backend during configuration ( make config ) If you don't install Dovecot via the FreeBSD ports system, you are just asking for problems. As previously stated, do run "make config" and perhaps "make config-recursive" prior to actually attempting to build the port.
I did, MySQL is ticked when i build dovecot2 from /usr/ports/mail/dovecot2/ If you do dovecot --build-options, does it list mysql?
root@mail:~# dovecot --build-options Build options: ioloop=kqueue notify=kqueue ipv6 openssl io_block_size=8192 Mail storages: shared mdbox sdbox maildir mbox cydir imapc pop3c raw SQL drivers: mysql Passdb: checkpassword pam passwd passwd-file sql Userdb: checkpassword nss passwd prefetch passwd-file sql
At first i have noticed that i dont have mysql when i did --build-options, so i tried to deinstall and reinstall dovecot2 port and now i have this also:
hostname# dovecot --build-options Build options: ioloop=kqueue notify=kqueue ipv6 openssl io_block_size=8192 Mail storages: shared mdbox sdbox maildir mbox cydir imapc pop3c raw SQL drivers: mysql Passdb: checkpassword pam passwd passwd-file sql Userdb: checkpassword nss passwd prefetch passwd-file sql
But i still keep getting the same error
hostname# service dovecot start doveconf: Error: userdb is missing driver doveconf: Fatal: Error in configuration file /usr/local/etc/dovecot/dovecot.conf: userdb is missing driver doveconf: Error: userdb is missing driver doveconf: Fatal: Error in configuration file /usr/local/etc/dovecot/dovecot.conf: userdb is missing driver Starting dovecot. doveconf: Fatal: Error in configuration file /usr/local/etc/dovecot/dovecot.conf: userdb is missing driver /usr/local/etc/rc.d/dovecot: WARNING: failed to start dovecot
Still the same output for doveconf -n
hostname# doveconf -n # 2.1.8: /usr/local/etc/dovecot/dovecot.conf # OS: FreeBSD 9.0-STABLE i386 auth_default_realm = ren.wf auth_mechanisms = plain login auth_realms = ren.wf graphics.re 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 } doveconf: Error: userdb is missing driver 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
participants (5)
-
Daryl Richards
-
Frank Bonnet
-
Jerry
-
Reindl Harald
-
Surreal