Page MenuHomePhorge
Files F117759120

No OneTemporary
Actions

Authored By
Unknown
Size
752 B
Referenced Files
None
Subscribers
None

View Options

diff --git a/docker/postfix/rootfs/etc/postfix/sql/local_recipient_maps.cf b/docker/postfix/rootfs/etc/postfix/sql/local_recipient_maps.cf
index 61ffeb32..99c5663c 100644
--- a/docker/postfix/rootfs/etc/postfix/sql/local_recipient_maps.cf
+++ b/docker/postfix/rootfs/etc/postfix/sql/local_recipient_maps.cf
@@ -1,5 +1,5 @@
hosts = DB_HOST
user = DB_USERNAME
password = DB_PASSWORD
dbname = DB_DATABASE
-query = SELECT email FROM users WHERE email = '%u@%d' AND status & 2 AND NOT status & 4 AND NOT status & 8
+query = SELECT users.email FROM users left join user_aliases ON users.id = user_aliases.user_id WHERE (users.email = '%u@%d' OR user_aliases.alias = '%u@%d') AND users.status & 2 AND NOT users.status & 4 AND NOT users.status & 8 LIMIT 1

File Metadata

Mime Type
text/x-diff
Expires
Apr 4 2026, 10:07 AM (4 w, 3 d ago)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
18773115
Default Alt Text
(752 B)

Event Timeline