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