Hi, greetings

Do sing out please if this is the wrong place or style for this mailing list, please - and there's a community somewhere isn't there?

spent days not succeeding with these configs. I'm a new install on Trixie and Dovecot 2.4.1 and going round in many circles with

nano /etc/dovecot/dovecot.conf nano /etc/dovecot/conf.d/10-auth.conf nano /etc/dovecot/conf.d/auth-sql.conf.ext nano /etc/dovecot/conf.d/10-master.conf

MariaDB

having tried one million variations of this, so this is just one, being the latest suggestion

Declare named instances of passdb/userdb using the SQL driver

passdb sql { } userdb sql { }

Passdb (authentication) SQL settings

passdb_sql_driver = mysql # MariaDB uses "mysql" passdb_sql_host = 127.0.0.1 # or: /run/mysqld/mysqld.sock passdb_sql_port = 3306 passdb_sql_dbname = maildb passdb_sql_user = dovecot passdb_sql_password = CHANGEME

Choose the scheme to match your DB:

- MD5-CRYPT for $1$... hashes or {MD5-CRYPT} prefix

- PLAIN-MD5 for 32-hex unsalted MD5

passdb_sql_default_pass_scheme = MD5-CRYPT

passdb_sql_password_query =
SELECT username AS user, password
FROM users
WHERE username = '%u' (thought this is now changed)

Userdb (user lookup) SQL settings

userdb_sql_driver = mysql userdb_sql_host = 127.0.0.1 userdb_sql_port = 3306 userdb_sql_dbname = maildb userdb_sql_user = dovecot userdb_sql_password = CHANGEME

Must return at least uid, gid and home or mail

userdb_sql_user_query =
SELECT
5000 AS uid, 5000 AS gid,
home,
CONCAT('maildir:', maildir) AS mail
FROM users
WHERE username = '%u' (thought this is now changed)

I have never used Dovecot before this install ten days ago - any example files that work will be forever gratefully appreciated to give me a basic starting point. Very frustratingly at one 3am morning I did get it working and the lost it.

a t b Anthony

dovecot mailing list -- dovecot@dovecot.org To unsubscribe send an email to dovecot-leave@dovecot.org