RE: Unknown setting error with dovecot-sql.conf.ext

20 Feb 2020

      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@open-xchange.com]
Sent: 20 February 2020 11:26
To: Andy Woolley andy@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 = 
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] *On Behalf Of *Aki
Tuomi
*Sent:* 20 February 2020 10:11
*To:* Andy Woolley mailto:andy@milonic.com>;
dovecot@dovecot.org mailto: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.

Im 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.

Im 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