dovecot-sql.conf.ext
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

dovecot-sql.conf.ext
View Options

	# -------------------------------------------------------------
	# Dovecot configuration
	# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
	# Project: Nasqueron
	# License: Trivial work, not eligible to copyright
	# Source file: roles/mailserver/dovecot/files/dovecot-sql.conf.ext
	# -------------------------------------------------------------
	#
	# <auto-generated>
	# This file is managed by our rOPS SaltStack repository.
	#
	# Changes to this file may cause incorrect behavior
	# and will be lost if the state is redeployed.
	# </auto-generated>

	driver = pgsql

	connect = \
	host={{ db.hostname }} \
	dbname={{ db.name }} \
	user={{ db.user }} \
	password={{ db.password }}

	default_pass_scheme = CRYPT

	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 )

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