[GH-ISSUE #430] Postfix map files need update #413

New issue

Closed

opened 2026-02-27 11:11:38 +03:00 by kerem · 4 comments

kerem commented

2026-02-27 11:11:38 +03:00

Owner

Originally created by @tonioo on GitHub (Dec 4, 2013).
Original GitHub issue: https://github.com/modoboa/modoboa/issues/430

Originally assigned to: @tonioo on GitHub.

Originally created by Antoine Nguyen on 2013-07-16T07:47:57Z

The map files generated by modoboa-admin.py are outdated. The email2email query is useless and the aliases query doesn't include all elements (aliases for example).

Originally created by @tonioo on GitHub (Dec 4, 2013). Original GitHub issue: https://github.com/modoboa/modoboa/issues/430 Originally assigned to: @tonioo on GitHub. **Originally created by Antoine Nguyen on 2013-07-16T07:47:57Z** The map files generated by modoboa-admin.py are outdated. The email2email query is useless and the aliases query doesn't include all elements (aliases for example).

kerem

2026-02-27 11:11:38 +03:00

closed this issue
added the
bug
label

kerem commented

2026-02-27 11:11:39 +03:00

Author

Owner

@tonioo commented on GitHub (Dec 4, 2013):

Posted by Anonymous on 2013-07-20T07:58:40Z

Applied in changeset commit:f8de2e7994bdcc6ac4c0e94c0e49c6bea15ed96e.

@tonioo commented on GitHub (Dec 4, 2013): **Posted by Anonymous on 2013-07-20T07:58:40Z** Applied in changeset commit:f8de2e7994bdcc6ac4c0e94c0e49c6bea15ed96e.

kerem commented

2026-02-27 11:11:39 +03:00

Author

Owner

@tonioo commented on GitHub (Dec 4, 2013):

Posted by Antoine Nguyen on 2013-08-16T12:54:17Z

It seems there is also an issue with domain aliases recipients...

@tonioo commented on GitHub (Dec 4, 2013): **Posted by Antoine Nguyen on 2013-08-16T12:54:17Z** It seems there is also an issue with domain aliases recipients...

kerem commented

2026-02-27 11:11:39 +03:00

Author

Owner

@tonioo commented on GitHub (Dec 4, 2013):

Posted by Antoine Nguyen on 2013-08-16T12:56:16Z

Something like this should fix it (postgres):

(SELECT mb.address || '@' || dom.name FROM admin_domainalias domal INNER JOIN admin_domain dom ON domal.target_id=dom.id INNER JOIN admin_mailbox mb ON mb.domain_id=dom.id WHERE domal.name='%d' AND dom.enabled AND mb.address='%u') UNION (SELECT al.address || '@' || dom.name FROM admin_domainalias domal INNER JOIN admin_domain dom ON domal.target_id=dom.id INNER JOIN admin_alias al ON al.domain_id=dom.id WHERE domal.name='%d' AND dom.enabled AND al.address='%u')

@tonioo commented on GitHub (Dec 4, 2013): **Posted by Antoine Nguyen on 2013-08-16T12:56:16Z** Something like this should fix it (postgres): <pre> (SELECT mb.address || '@' || dom.name FROM admin_domainalias domal INNER JOIN admin_domain dom ON domal.target_id=dom.id INNER JOIN admin_mailbox mb ON mb.domain_id=dom.id WHERE domal.name='%d' AND dom.enabled AND mb.address='%u') UNION (SELECT al.address || '@' || dom.name FROM admin_domainalias domal INNER JOIN admin_domain dom ON domal.target_id=dom.id INNER JOIN admin_alias al ON al.domain_id=dom.id WHERE domal.name='%d' AND dom.enabled AND al.address='%u') </pre>

kerem commented

2026-02-27 11:11:39 +03:00

Author

Owner

@tonioo commented on GitHub (Dec 4, 2013):

Posted by Antoine Nguyen on 2013-08-27T07:09:29Z

Applied in changeset commit:6fac43655da676dde619e41780d1175e65329e2f.

@tonioo commented on GitHub (Dec 4, 2013): **Posted by Antoine Nguyen on 2013-08-27T07:09:29Z** Applied in changeset commit:6fac43655da676dde619e41780d1175e65329e2f.

kerem referenced this issue

2026-02-27 11:20:26 +03:00

[PR #697] [MERGED] fixed #413 email checking for to/cc/cci in webmail #1983