MariaDB database for users and passwords?

[Daniel Miller]

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 at 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 at 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.conf.ext#L32
> 
> Aki
>