PostfixAdmin – Set Up A Mail Server with PostfixAdmin on Ubuntu | Debian – Part 3 – Configure Dovecot with MySQL/MariaDB
✳️ Some Important Information from Part 1 🔸 Domain: totatca.xyz 🔸 FQDN/Fullname: mail.totatca.xyz 🔸 User and Group: totatca with ID 5000 🔸 Email storage: /var/virtual_mail_box 🔸 Database name: postfixadmin_db 🔸 Database user: postfixadmin_user 🔸 Database password: postfixadmin_PWD ✅ Replace the highlighted portion in orange with your information. ✅ If you make any changes, ensure to update the corresponding details in the following steps. ✳️ Code in this video: 📌 10-mail.conf mail_location = maildir:/var/virtual_mail_box/%d/%n mail_privileged_group = totatca mail_uid = totatca mail_gid = totatca first_valid_uid = 5000 last_valid_uid = 5000 📌 /etc/dovecot/dovecot-sql.conf.ext driver = mysql connect = host=localhost dbname=postfixadmin_db user=postfixadmin_user password=postfixadmin_PWD default_pass_scheme = MD5-CRYPT password_query = SELECT username as user, password, '/var/virtual_mail_box/%d/%n' as userdb_home, 'maildir:/var/virtual_mail_box/%d/%n' as userdb_mail, 5000 as userdb_uid, 8 as userdb_gid FROM mailbox WHERE username = '%u' AND active = '1' user_query = SELECT '/var/virtual_mail_box/%d/%u' as home, 'maildir:/var/virtual_mail_box/%d/%u' as mail, 5000 AS uid, 8 AS gid, concat('dirsize:storage=', quota) AS quota FROM mailbox WHERE username = '%u' AND active = '1' 📌 10-master.conf ✳️ LMTP section unix_listener /var/spool/postfix/private/dovecot-lmtp { mode = 0600 user = postfix group = postfix } ✳️ AUTH service unix_listener /var/spool/postfix/private/auth { mode = 0666 user = postfix group = postfix } unix_listener auth-userdb { mode = 0600 user = totatca } user = dovecot ✳️ AUTH-WORKER section user = totatca Thank You !!!