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 -------------- next part -------------- An HTML attachment was scrubbed... URL: <https://dovecot.org/pipermail/dovecot/attachments/20200220/1f3dac4a/attachment.html>
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 -------------- next part -------------- An HTML attachment was scrubbed... URL: <https://dovecot.org/pipermail/dovecot/attachments/20200220/5d5233cb/attachment.html>
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 = </etc/letsencrypt/live/intelliset.co.uk/fullchain.pem
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 at dovecot.org>
mailto:dovecot-bounces at dovecot.org] On Behalf Of Aki Tuomi
Sent: 20 February 2020 10:11
To: Andy Woolley < <mailto:andy at milonic.com> andy at
milonic.com>;
<mailto:dovecot at dovecot.org> dovecot at 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 at dovecot.org] On Behalf Of Aki Tuomi
Sent: 20 February 2020 10:11
To: Andy Woolley <andy at milonic.com>; dovecot at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<https://dovecot.org/pipermail/dovecot/attachments/20200220/d96d9919/attachment-0001.html>
OMG, that was it, so sorry to have wasted your time. The text editor I am using (Ultraedit) is adding a BOM (Byte Order Marker) to the beginning of the file. I have disabled this in settings but it keeps doing it. Thank you so much for pointing me in the right direction. After removing the 3 invisible characters from the dovecot-sql.conf.ext file it magically worked. Andy -----Original Message----- From: Aki Tuomi [mailto:aki.tuomi at open-xchange.com] Sent: 20 February 2020 11:26 To: Andy Woolley <andy at milonic.com> Subject: Re: Unknown setting error with dovecot-sql.conf.ext I am unable to reproduce the issue here, can you send me the file itself? Maybe it has some strange thing in it? On 20.2.2020 12.23, Andy Woolley wrote:> > 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 = </etc/letsencrypt/live/intelliset.co.uk/fullchain.pem > > 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 at dovecot.org] *On Behalf Of *Aki > Tuomi > *Sent:* 20 February 2020 10:11 > *To:* Andy Woolley <andy at milonic.com <mailto:andy at milonic.com>>; > dovecot at dovecot.org <mailto:dovecot at 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 at dovecot.org] *On Behalf Of *Aki > Tuomi > *Sent:* 20 February 2020 10:11 > *To:* Andy Woolley <andy at milonic.com>; dovecot at 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 >