There is some ambiguity in the setting names, however:
In the "upper" authentication config file (possibly conf.d/auth-sql.conf.ext) you define which "internal" driver the authentication system will use. These are...more of a top-level engine selection if you will - perhaps not what you'd consider a "true" driver.
In the "lower" authentication config file (like dovecot-sql.conf.ext), which is referenced by the 'args' setting in the userdb & passdb sections of the "upper" file, is where you explicitly specific the "true" driver, the actual database, and any field mappings.
If you're just getting things setup I suggest you check out:
http://postfixadmin.sourceforge.net/
Very clean & simple admin GUI for mail services. It includes documentation for setting up Dovecot.
Daniel
On 11/8/2019 11:12 PM, Aki Tuomi via dovecot wrote:
On 09/11/2019 05:44 Ken Wright via dovecot <dovecot@dovecot.org> wrote:
On 11/8/19 3:40 PM, Alexander Dalloz via dovecot wrote:
Am 08.11.2019 um 21:23 schrieb Ken Wright via dovecot:
On 11/8/19 3:14 PM, @lbutlr via dovecot wrote:
On 08 Nov 2019, at 11:56, Ken Wright <wizard@bnnorth.net> wrote:
Nov 8 13:28:53 grace dovecot: auth: Fatal: Unknown passdb driver ‘ You do not have Dovecot compiled with support for mysql'
But the dovecot-mysql package is installed! Why can't it see that?
The driver is called "sql". See
https://doc.dovecot.org/configuration_manual/authentication/sql/
Alexander
Are you sure? I looked at that page, and it says there are different drivers for MySQL and PostgreSQL: mysql and pgsql respectively. I also checked dovecot.conf, and there the driver is called "sql."
Ken
SQL is the **authentication** database, which has mysql **driver**. So in dovecot.conf you use sql, and in the config file for the sql authentication, you specify the driver. See https://github.com/dovecot/core/blob/master/doc/example-config/dovecot-sql.c...
Aki