Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- mailserver [17.10.2024 09:08] – [Spamassassin] thooge
+++ mailserver [12.03.2026 11:47] (aktuell) – [Virtuelle Mailboxen] thooge
@@ Zeile 8: / Zeile 8: @@
   * [[Dovecot]]
   * [[Sieve]]
+===== Virtuelle Mailboxen =====
+WIP
+Erforderliche Pakete
+  postfix-mysql dovecot-mysql
+Für die Verwaltung wird [[Postfixadmin]] verwendet. Die Daten liegen
+in einer MariaDB Datenbank ''postfix''.
+Um auf die Datenbank zuzugreifen werden spezielle Datenbankbenutzer für Postfix und Dovecot benötigt:<code sql>
+CREATE USER 'postfix'@'localhost' IDENTIFIED BY 'POSTFIXPASS';
+GRANT SELECT ON 'postfix'.* TO 'postfix'@'localhost';
+CREATE USER 'dovecot'@'localhost' IDENTIFIED BY 'DOVECOTPASS';
+GRANT SELECT ON postfix.mailbox TO 'dovecot'@'localhost';
+GRANT SELECT,INSERT,UPDATE,DELETE ON postfix.quota2 TO 'dovecot'@'localhost';
+</code>
+  * Benutzer ''vmail''
+  * Basisverzeichnis ''/var/mail/vmail''
+==== Postfix ====
+Datenbankzugang einstellen
+<code>
+mysql-virtual-alias-maps.cf
+mysql-virtual-mailbox-domains.cf
+mysql-virtual-mailbox-maps.cf
+</code>
+<file main.cf>
+# use proxy because of chroot
+virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf
+virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual-mailbox-maps.cf
+virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual-alias-maps.cf
+</file>
+==== Dovecot ====
+<code>
+password_query = \
+  SELECT username, domain, password \
+  FROM mailbox WHERE username = '%u' AND active = 1
+user_query = \
+  SELECT username AS user, \
+         'vmail' AS uid, \
+         'vmail' AS gid, \
+         '/var/mail/vmail/%u' AS home, \
+         CONCAT('*:bytes=', CAST(quota AS CHAR)) AS quota_rule \
+  FROM mailbox WHERE username = '%u' AND active = 1
+</code>
 ===== OpenDKIM =====