So what do we do with this:
>
> dbmail_users (id, user):
>     1    foo at server
>     2    foonew at server
>
> dbmail_aliases (alias, deliver-to):
>     foo at server       2
>
> That is to say, we're trying to get all mail to 'foo at server ' to land in
> the INBOX of 'foonew at server '. What happens:
>
> Currently:
>     Mail for 'foo at server ' goes to user 1.
>
> Aaron's Proposal:
>     Mail for 'foo at server ' goes to user 2.
>
> Thomas' Proposal:
>     Mail for 'foo at server ' goes to user 2 and user 1.

Suggested correction to "what happens in this scenario" with Aaron's proposal:

Mail for 'foo at server' goes to user 2 and user 1 - because the admin makes an explicit alias for any user who should receive mail addressed to 'foo at server':

dbmail_aliases (alias, deliver-to):
    foo at server       2
    foo at server       1

Just as I believed when I set up my dbmail 2.x server months ago - that I would need an alias for every user. So Aaron's proposal relieves me of having an alias for each user - which of course I could avail myself of right now - since the new dbmail doesn't actually require an alias anymore... but I would definitely have no problem with the the concept that if I am going to use ANY alias for user 1 ... I
must ALSO add an alias explicitly to user 1.

This seems to me to be the most backward compatible with the way dbmail aliases and users used to work, while retaining the advantages of not requiring an explicit alias if the only deliver-to for the address *is* a user matching the address.

> I'm inclined to say that the question in this case is about what we *want*
> to have happen. I can't think of any other demonstation cases  corner
> cases right now, but let's keep the thinking caps on before doing anything
> on this.

I feel both frustrated and helpless right now. I love postgresql, my customers are driving up me up the wall with their demands to be able to do this very simple and for them, common thing that they have been able to do for years with the previous MTA - and I literally cannot offer them ANY way to do this without throwing them into a further tizzy by making them change their user logins... going non-standard,
away from the [EMAIL PROTECTED] which is the last thing we want to do.

Those who depended on getting their mail from accounts that are external forwards - now have mail they never got, waiting on our server - if I change the user login so that their external forwarding will start working - then the instructions they have for logging into webmail will not work - to get the mail they missed. And there are a lot of them - on various domains etc. And we just went through the painful migration and speaking to most of them phone call by phone call how to convert to the nice old standard of "all you have to remember is your user name is [EMAIL PROTECTED] - no more
of that ampersand stuff" ... etc.

As Paul or someone commented - all I'm asking for is a fix to return the operation to what dbmail documentation describes - or a reasonable facsimile. Not a new function or new feature that should maybe be theoretically consider for some distant debate.

If someone would tell me what file to edit and how to make the change start happening in my own installation now, I'd be eternally grateful. I am not a c programmer. I don't know if your SQL is editable wo recompiling etc or what is involved. Or if you can tell me the file to have messed with, I'll get one of my C programmers to mess with it -
and do Aaron's proposal if I can't do it.

Thank you,

- April Lorenzen


Reply via email to