doveconf -n
# 2.3.9.2 (cf2918cac): /etc/dovecot/dovecot.conf
# OS: Linux 5.4.19-200.fc31.x86_64 x86_64 Fedora release 31 (Thirty One)
# Hostname: data.tia3.com
auth_mechanisms = plain login
mail_location = /home/vmail/%d/%n
mail_privileged_group = mail
mbox_write_locks = fcntl
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 {
driver = pam
}
passdb {
args = /etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
service auth-worker {
user = vmail
}
service auth {
unix_listener /var/spool/postfix/private/auth {
group = postfix
mode = 0660
user = postfix}
unix_listener auth-userdb {
mode = 0600
user = vmail}
user = dovecot
}
service imap-login {
inet_listener imap {
port = 143}
inet_listener imaps {
port = 993
ssl = yes}
}
service lmtp {
unix_listener lmtp {
group = postfix
mode = 0600
user = postfix}
}
service pop3-login {
inet_listener pop3 {
port = 110}
inet_listener pop3s {
port = 995
ssl = yes}
}
ssl = required
ssl_cert =
ssl_cipher_list = PROFILE=SYSTEM
ssl_key = # hidden, use -P to show it
userdb {
driver = passwd
}
userdb {
args = /etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
dovecot-sql.conf.ext:
driver = mysql
connect = host=127.0.0.1 dbname=mail user=foo password=bar
default_pass_scheme = SHA512-CRYPT
password_query = SELECT email as user, password FROM users WHERE email='%u';
Many thanks,
Andy
From: dovecot [ mailto:dovecot-bounces@dovecot.org mailto:dovecot-bounces@dovecot.org] On Behalf Of Aki Tuomi Sent: 20 February 2020 10:11 To: Andy Woolley < mailto:andy@milonic.com andy@milonic.com>; mailto:dovecot@dovecot.org dovecot@dovecot.org Subject: Re: Unknown setting error with dovecot-sql.conf.ext
On 20.2.2020 12.06, Andy Woolley wrote:
Hi All,
I am trying to install Dovecot connecting to MySQL and all seems to be working until I try to send/receive.
I'm getting a "Unknown setting" error for anything that is inside dovecot-sql.conf.ext
dovecot-sql.conf.ext is inside /etc/dovecot and is referenced from /etc/dovecot/conf.d/auth-sql.conf.ext
The error I get is:
auth: Fatal: sql /etc/dovecot/dovecot-sql.conf.ext: Error in configuration file /etc/dovecot/dovecot-sql.conf.ext line 1: Unknown setting: driver
Can anybody help me?
Andy
Post 'doveconf -n' please and the contents of the sql.conf.ext file. Mind passwords.
Aki
From: dovecot [mailto:dovecot-bounces@dovecot.org] On Behalf Of Aki Tuomi Sent: 20 February 2020 10:11 To: Andy Woolley andy@milonic.com; dovecot@dovecot.org Subject: Re: Unknown setting error with dovecot-sql.conf.ext
On 20.2.2020 12.06, Andy Woolley wrote:
Hi All,
I am trying to install Dovecot connecting to MySQL and all seems to be working until I try to send/receive.
I'm getting a "Unknown setting" error for anything that is inside dovecot-sql.conf.ext
dovecot-sql.conf.ext is inside /etc/dovecot and is referenced from /etc/dovecot/conf.d/auth-sql.conf.ext
The error I get is:
auth: Fatal: sql /etc/dovecot/dovecot-sql.conf.ext: Error in configuration file /etc/dovecot/dovecot-sql.conf.ext line 1: Unknown setting: driver
Can anybody help me?
Andy
Post 'doveconf -n' please and the contents of the sql.conf.ext file. Mind passwords.
Aki