On Samstag, 16. Dezember 2006 10:31 Aaron Stone wrote: > I would like to be able to support the configuration that you're > suggesting below. Everyone interested should please continue > discussion so that we get some good ideas and issues out on the > table! :-)
Advantage: - List of domains easy to retrieve for postfix: query = SELECT domain FROM zmi_domains WHERE domain='%s' - Easy to find the root of the aliased domains for postfix: query = SELECT concat( '@', pridomain ) FROM zmi_domains WHERE concat( '@', pridomain )='%s' AND pridomain IS NOT NULL - I showed before that it's easy to find from an alias the final recipient user - by using the already prepared "client_idnr" (which really should be called customer_id, because client makes me think of an e-mail client and it's IP address), one can assign aliases, users and domains together, making it easier for support departments, because even within a company you can use it for separating departments - It helps stop backscatter easily, because you don't accept e-mail for aliases that don't exist, even in alias domains. - It's easier to see which domains are just aliases. Disadvantage: - DB schema change necessary - at least one more table - maybe it could be a problem if you want to define: [EMAIL PROTECTED] -> [EMAIL PROTECTED] @domaina -> [EMAIL PROTECTED] I mean, having domaina be an alias for domainb, except address [EMAIL PROTECTED], which should go somewhere else. That should be thought of at implementation time. a bit OT: Also, I love the idea of a postmaster@ generic user alias, that would be great, because only that domains that really want it themselves should define it then, the rest goes to our support department. mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0676/846914666 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi3.asc | gpg --import" // Fingerprint: 44A3 C1EC B71E C71A B4C2 9AA6 C818 847C 55CB A4EE // Keyserver: www.keyserver.net Key-ID: 0x55CBA4EE
pgpjeXy0P4DN8.pgp
Description: PGP signature
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
