Maniphest T1931

Dovecot Provisioning
Open, Needs TriagePublic
Actions

Assigned To

Authored By

	DorianWinty
	Dec 18 2023, 20:46

Description

In this task we will install and configure dovecot

Revisions and Commits

rOPS Nasqueron Operations
	Needs Review		D3364 Provisioning Dovecot Config
		D3375	rOPSfc0d46d845df Configure pg_HBA for dovecot user
		D3365	rOPS8919c2cb98b1 Create PostgreSQL credentials for Dovecot

Related Objects
Search...

Status	Assigned	Task
Wontfix	dereckson	T4 Setup fauve services
Open	None	T1476 Host @wolfplex.be mail
Open	DorianWinty	T1475 Provision a mail server
Open	DorianWinty	T1931 Dovecot Provisioning
Open	DorianWinty	T1987 Dovecot Metrics

Event Timeline

DorianWinty created this task.Dec 18 2023, 20:46

DorianWinty moved this task from Backlog - On hold pending T1475 to Working on on the Mail board.Dec 18 2023, 21:07

Adapted from https://gist.github.com/barryo/8918488:

dovecot-sql.conf.ext SQL queries

PostgreSQL query for password:

password_query = SELECT username as user, password as password, \
        homedir AS userdb_home, maildir AS userdb_mail, \
        concat('*:bytes=', quota) as userdb_quota_rule, uid AS userdb_uid, gid AS userdb_gid \
    FROM mailbox \
    WHERE username = '%Lu' AND active = '1' \
          AND ( access_restriction = 'ALL' OR POSITION( '%Us' IN access_restriction ) > 0 )

The MySQL user query can be used as is:

user_query = SELECT homedir AS home, maildir AS mail, \
        concat('*:bytes=', quota) as quota_rule, uid, gid \
    FROM mailbox WHERE username = '%u'