Unknown setting error with dovecot-sql.conf.ext

[Andy Woolley]

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
>