Code in this video_PostfixAdmin – Set Up A Mail Server with PostfixAdmin on Ubuntu | Debian – Part 3

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 !!!