Unknown setting error with dovecot-sql.conf.ext

[Andy Woolley]

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>