From 9e79e040799cd36b6d30029ca6761665bbf3116e Mon Sep 17 00:00:00 2001
From: mhoellein <mario@hoellein.online>
Date: Sat, 27 Apr 2019 06:25:14 +0200
Subject: [PATCH] daily autocommit

---
 .etckeeper                      |  1 +
 myssl/dh2048.pem                | 12 ++++++------
 postfix/main.cf                 |  1 +
 postfix/sql/sender_canonical.cf |  5 +++++
 4 files changed, 13 insertions(+), 6 deletions(-)
 create mode 100644 postfix/sql/sender_canonical.cf

diff --git a/.etckeeper b/.etckeeper
index 782a6dcce..bc0c52dec 100755
--- a/.etckeeper
+++ b/.etckeeper
@@ -2142,6 +2142,7 @@ maybe chmod 0640 'postfix/sql/aliases.cf'
 maybe chmod 0640 'postfix/sql/domains.cf'
 maybe chmod 0640 'postfix/sql/recipient-access.cf'
 maybe chmod 0640 'postfix/sql/sender-login-maps.cf'
+maybe chmod 0644 'postfix/sql/sender_canonical.cf'
 maybe chmod 0640 'postfix/sql/tls-policy.cf'
 maybe chmod 0644 'postfix/submission_header_cleanup'
 maybe chmod 0644 'postfix/without_ptr'
diff --git a/myssl/dh2048.pem b/myssl/dh2048.pem
index ff9e2814e..e42b10e5b 100644
--- a/myssl/dh2048.pem
+++ b/myssl/dh2048.pem
@@ -1,8 +1,8 @@
 -----BEGIN DH PARAMETERS-----
-MIIBCAKCAQEAlP1OuC41ZI/wCIfKX8knkxPvtKfqB/DFebn5tG5C7rvutmWqWCD7
-K6C30yXCBBM0i7hp2lSSSOsOBOzCP0c8wgJYpMjijfNWtjAQVG3ZAp7nQip9jufr
-5b7Q4USafrdMiaWDEGNEHwdWYF2sXrhmTB0WPk8Z8Mb44tVbMVq72v+IlPnBZhLN
-aanh5kyRCfakeAWBGav73l1Y/UnfkMwIQcv0/ModHqmnhAUDFD5DQdyvzBBVTKDT
-r10ISyG3uREhEzroGmTaUR2Ndb5liP+/qCHae3M7g5B0jBvDT8KaftPog3GMCNV4
-MLaBzQYbluG+dmVrVOdTJ7Qm/BiiryMp4wIBAg==
+MIIBCAKCAQEAgT6JUxOYaW6XT10bjhN2/r1XfYu++XOQlK+RtquilekEaTuQQEXt
+PMvOu3kB1qcYb182T/7DelX6fwAcWhRW7Y/lmtpn3QUITmHg653pe6ufdgjTTYte
+PX85MacMHO6eeZ47xKZruhm/yKdNLH61kgz0TskuWVI06WzacWcMvgXjXLoF0hg/
+n+YoUz1r4eDNvjrYPh1kIwkdNdKl4XTfIlgOhl/zDFZk+TT1B8GE6VewqirOhL2Z
+Y2bwrKbDaz4qitcdpQKn+vhRnb2sixhJ6h+5Pb3HN9H7oO6sPd7eEzzHBtz6Ufny
+qengha+/H4zCiaHomQ4iboTv23IUOQXS6wIBAg==
 -----END DH PARAMETERS-----
diff --git a/postfix/main.cf b/postfix/main.cf
index beef437ae..37a18d340 100644
--- a/postfix/main.cf
+++ b/postfix/main.cf
@@ -134,6 +134,7 @@ postscreen_dnsbl_action = drop
 virtual_alias_maps = mysql:/etc/postfix/sql/aliases.cf
 virtual_mailbox_maps = mysql:/etc/postfix/sql/accounts.cf
 virtual_mailbox_domains = mysql:/etc/postfix/sql/domains.cf
+sender_canonical_maps = mysql:/etc/postfix/sql/sender_canonical.cf
 local_recipient_maps = $virtual_mailbox_maps
 
 
diff --git a/postfix/sql/sender_canonical.cf b/postfix/sql/sender_canonical.cf
new file mode 100644
index 000000000..5bfa7d826
--- /dev/null
+++ b/postfix/sql/sender_canonical.cf
@@ -0,0 +1,5 @@
+user = vmail
+password = 5te902D733ZlK$q"D
+hosts = 127.0.0.1
+dbname = vmail
+query= SELECT destination FROM sender_canonical WHERE email LIKE '%s' limit 1; 
-- 
2.43.0