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-le...@dovecot.org
