Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- centos:mail_c7:pfadmin_1 [23.10.2015 21:02. ] – [vorbereitende Konfiguration] django
+++ centos:mail_c7:pfadmin_1 [20.04.2018 07:51. ] – Postfixadmin zur Verwaltung der Maildomains und der Nutzerkonten des Dovecot-IMAP-Servers unter CentOS 7.x django
@@ Zeile 1153: / Zeile 1153: @@
 {{ :centos:mail_c7:postfixadmin_05.png?direct&850 |Bild: Postfixadmin - Admin-Zugang}}
+===== Postfix Konfiguration ====
+==== virtual_alias files in Verbindung mit postfixadmin ====
+Damit unser Postfix-Mailserver auch Kenntnis von den Domänen und Konten in der MariaDB erhält müssen wir unsere Postfix-Konfigurationsdatei //**/etc/postfix/main.cf**// um folgenden Block erweitern.
+<code># Django : 2014-10-15 - virtuelle Mail-Domains und Mailboxen mit Anbindung an
+#          das mySQL-Datenbankbackend (Verwaltung mit Hilfe von postfixadmin)
+# default: virtual_mailbox_domains = $virtual_mailbox_maps
+#          virtual_alias_maps = $virtual_maps
+#          virtual_mailbox_maps =
+virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql_virtual_domains_maps.cf
+virtual_alias_maps =      proxy:mysql:/etc/postfix/mysql_virtual_alias_maps.cf
+                          proxy:mysql:/etc/postfix/mysql_virtual_alias_domain_maps.cf
+                          proxy:mysql:/etc/postfix/mysql_virtual_alias_domain_catchall_maps.cf
+virtual_mailbox_maps =    proxy:mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
+                          proxy:mysql:/etc/postfix/mysql_virtual_alias_domain_mailbox_maps.cf</code>
+Die zugehörigen Dateien, haben dann folgende Inhalte.
+=== mysql_virtual_domains_maps.cf ===
+   # vim /etc/postfix/mysql_virtual_domains_maps.cf
+<file bash /etc/postfix/mysql_virtual_domains_maps.cf># Django : 2013-02-07
+# Definition der Datenbankanbindung zur Abfrage der virtuellen Domaenen
+#
+user = postfix_user
+password = rbgsDK39DeM2b2btx9iMHfzd
+hosts = mariadb.dmz.nausch.org
+dbname = postfix
+query = SELECT domain FROM domain WHERE domain='%s' AND active = '1'
+</file>
+=== mysql_virtual_alias_maps.cf ===
+   # vim /etc/postfix/mysql_virtual_alias_maps.cf
+<file bash /etc/postfix/mysql_virtual_alias_maps.cf># Django : 2012-02-07
+# Definition der Datenbankanbindung zur Abfrage der virtual Alias Maps
+#
+user = postfix_user
+password = rbgsDK39DeM2b2btx9iMHfzd
+hosts = mariadb.dmz.nausch.org
+dbname = postfix
+query = SELECT goto FROM alias WHERE address='%s' AND active = '1'
+</file>
+=== mysql_virtual_alias_domain_maps.cf ===
+   # vim /etc/postfix/mysql_virtual_alias_domain_maps.cf
+<file bash /etc/postfix/mysql_virtual_alias_domain_maps.cf># Django : 2013-02-07
+# Definition der Datenbankanbindung zur Abfrage der virtual Alias Domain Maps
+#
+user = postfix_user
+password = rbgsDK39DeM2b2btx9iMHfzd
+hosts = mariadb.dmz.nausch.org
+dbname = postfix
+query = SELECT goto FROM alias,alias_domain WHERE alias_domain.alias_domain = '%d' AND
+           alias.address = CONCAT('%u', '@', alias_domain.target_domain) AND alias.active = 1
+           AND alias_domain.active='1'
+</file>
+=== mysql_virtual_alias_domain_catchall_maps.cf ===
+   # vim /etc/postfix/mysql_virtual_alias_domain_catchall_maps.cf
+<file bash /etc/postfix/mysql_virtual_alias_domain_catchall_maps.cf># Django : 2013-02-07
+# Definition der Datenbankanbindung zur Abfrage der virtual Alias Domain Catchall Maps
+#
+user = postfix_user
+password = rbgsDK39DeM2b2btx9iMHfzd
+hosts = mariadb.dmz.nausch.org
+dbname = postfix
+query = SELECT goto FROM alias,alias_domain WHERE alias_domain.alias_domain = '%d' AND
+           alias.address = CONCAT('@', alias_domain.target_domain) AND alias.active = 1
+           AND alias_domain.active='1'
+</file>
+=== mysql_virtual_mailbox_maps.cf ===
+   # vim /etc/postfix/mysql_virtual_mailbox_maps.cf
+<file bash /etc/postfix/mysql_virtual_mailbox_maps.cf># Django : 2013-02-07
+# Definition der Datenbankanbindung zur Abfrage der virtual Mailbox Maps
+#
+user = postfix_user
+password = rbgsDK39DeM2b2btx9iMHfzd
+hosts = mariadb.dmz.nausch.org
+dbname = postfix
+query = SELECT maildir FROM mailbox WHERE username='%s' AND active = '1'
+</file>
+=== mysql_virtual_alias_domain_mailbox_maps.cf ===
+   # vim /etc/postfix/mysql_virtual_alias_domain_mailbox_maps.cf
+<file bash /etc/postfix/mysql_virtual_alias_domain_mailbox_maps.cf># Django : 2012-10-09
+# Definition der Datenbankanbindung zur Abfrage der virtual Alias Domain Mailbox Maps
+#
+user = postfix_user
+password = rbgsDK39DeM2b2btx9iMHfzd
+hosts = mariadb.dmz.nausch.org
+dbname = postfix
+query = SELECT maildir FROM mailbox,alias_domain WHERE alias_domain.alias_domain = '%d'
+           AND mailbox.username = CONCAT('%u', '@', alias_domain.target_domain) AND
+           mailbox.active = 1 AND alias_domain.active='1'
+</file>
 ====== Links ======
@@ Zeile 1159: / Zeile 1256: @@
   * **[[http://dokuwiki.nausch.org/doku.php/|Zurück zur Startseite]]**
-~~DISCUSSION~~
+~~AUTOTWEET:~~