From 19fa573959ad8bc37019654c8d02243ab9cdf042 Mon Sep 17 00:00:00 2001 From: Jean-Marc Pigeon Date: Sat, 15 Nov 2025 20:36:41 -0500 Subject: [PATCH] Fixing dovecot conf.d configuration file --- dovecot/conf.d/70-mailleur-mysql.conf | 4 ++-- dovecot/conf.d/70-mailleur-pgsql.conf | 4 ++-- dovecot/conf.d/80-mailleur-usesql.conf | 11 +++++------ 3 files changed, 9 insertions(+), 10 deletions(-) diff --git a/dovecot/conf.d/70-mailleur-mysql.conf b/dovecot/conf.d/70-mailleur-mysql.conf index 716f1ba..7895daa 100644 --- a/dovecot/conf.d/70-mailleur-mysql.conf +++ b/dovecot/conf.d/70-mailleur-mysql.conf @@ -6,6 +6,6 @@ sql_driver = mysql mysql remote { host = localhost.localdomain - user = clement - dbname = clement + user = mailleur + dbname = mailleur } diff --git a/dovecot/conf.d/70-mailleur-pgsql.conf b/dovecot/conf.d/70-mailleur-pgsql.conf index 1a68e38..ca34767 100644 --- a/dovecot/conf.d/70-mailleur-pgsql.conf +++ b/dovecot/conf.d/70-mailleur-pgsql.conf @@ -7,7 +7,7 @@ sql_driver = pgsql pgsql remote { parameters { host = localhost.localdomain - user = clement - dbname = clement + user = mailleur + dbname = mailleur } } diff --git a/dovecot/conf.d/80-mailleur-usesql.conf b/dovecot/conf.d/80-mailleur-usesql.conf index 472be09..918823d 100644 --- a/dovecot/conf.d/80-mailleur-usesql.conf +++ b/dovecot/conf.d/80-mailleur-usesql.conf @@ -5,7 +5,7 @@ # --- Passdb : authentication via SQL --- passdb sql { default_password_scheme = SHA512-CRYPT - query = SELECT password FROM users WHERE username='%{user}'; + query = SELECT password FROM emails WHERE username='%{user}'; } # --- Userdb : user data(home, uid, gid) via SQL --- @@ -14,11 +14,10 @@ passdb sql { # userdb sql { - query = SELECT 'clement' AS uid,'mail' AS gid, \ - '/var/spool/clement/mails/%{user | domain}/%{user | username}' \ - AS home, \ - 'maildir:~/dovecot' AS mail, \ - '*:storage='||mxmgbytes||'M' AS quota_rule FROM userprofile WHERE prfid=(SELECT prfid FROM users WHERE username='%{user}') + query = SELECT 'mailleur' AS uid,'mail' AS gid, \ + '/var/spool/mailleur/mails/%{user | domain}/%{user | username}' \ + AS home,'maildir:~/dovecot' AS mail, \ + FROM emails WHERE email='%{user}') } -- 2.47.3