Hello,
> alright, I undertstand. Thanks for doing that research Jesse.
Oh sure ... we're gonna need to fix that for our setup here too
(or rewrite some inhouse apps, but fixing dbmail would be better).
> Has anyone set up a postfix query to pull just forwarding aliases from thhe
> dbmail alias table? it would be inconvenient to make a new table.
You don't want to do that - a normal dbmail alias entry has the
user_idnr as the deliver_to, so when postfix sees that it'll try to
forward to a user of that name (eg. [EMAIL PROTECTED]).
> Probably wouldn't be that hard I suppose, I'll have a go at it.
It's pretty simple - as seems the normal case, our setup is a
little more complex :), but here's what we use (this in postgres):
create table postfix_aliases (
idnr serial,
alias varchar(255) not null,
recipient varchar(255) not null,
host varchar(255) null default '',
disabled bit not null default B'0',
comment varchar(255) null
);
grant select on postfix_aliases to postfix;
And our .cf entry for postfix to use this is:
user = postfix
password = something
dbname = dbmail
hosts = dbhostname
table = postfix_aliases
select_field = recipient
where_field = alias
additional_conditions = host in ('','mail2','mail2.kci.net') and disabled = B'0'
This example was from mail2.kci.net, and the setup allows for
aliases to only exist on one of the mail servers (we have multiple
dbmail servers for the same db). You can drop the host, disabled,
and comments fields from the table, and the additional_conditions
from the .cf file. You also need a line in main.cf pointing to this,
of course, eg.:
alias_maps = proxy:pgsql:/etc/postfix/postfix_aliases.cf
> -Micah
>
>
> On Thu June 12 2003 10:05 am, Jesse Norell wrote:
> > Hello,
> >
> > From rfc 2821, we have excerpts:
> >
> > "SMTP servers performing a relay function MUST NOT inspect the
> > message data, and especially not to the extent needed to determine
> > if Return-path headers are present."
> >
> > and
> >
> > " a gateway from elsewhere->SMTP SHOULD delete any return-path
> > header present in the message, and either copy that information to
> > the SMTP envelope or combine it with information present in the
> > envelope of the other transport system to construct the reverse
> > path argument to the MAIL command in the SMTP envelope."
> >
> > So, if dbmail is considered part of the SMTP implimentation, it
> > is broken, and shouldn't remove the Return-Path: that was there - but
> > I don't think it is part of SMTP, it's more a "gateway from elsewhere"
> > which becomes an SMTP sender, in which case it SHOULD make this work
> > right, but strictly speaking, doesn't have to.
> >
> > In short, use postfix aliases right now, and this should be put on
> > a todo list to fix in dbmail (ie. when it strips the Return-Path:
> > out of a message it is forwarding somewhere, use that address as the
> > envelop sender in MAIL FROM command).
> >
> > Later...
> >
> > ---- Original Message ----
> > From: Jesse Norell <[email protected]>
> > To: [email protected]
> > Subject: Re: [Dbmail] forwarded bounces
> > Sent: Thu, 12 Jun 2003 10:42:23 -0600 (MDT)
> >
> > > Heh...
> > >
> > > It just occured to me, that I am using a dbmail forward myself as
> > > of last weekend. Looking that this message (the one I'm replying to),
> > > there is a single "Return-Path: <[EMAIL PROTECTED]>" header. That will
> > > be where bounces are sent, and from some testing it looks like that
> > > is inserted by the smtp receiver, using the MAIL FROM address. (There
> > > was no Return-Path: in the message headers of what dbmail sent me
> > > on a forward, so the one I see has to be added by the local smtp
> > > receiver). Lemme see what I can find in rfc 2822.
> > >
> > >
> > > ---- Original Message ----
> > > From: Jesse Norell <[email protected]>
> > > To: [email protected]
> > > Subject: Re: [Dbmail] forwarded bounces
> > > Sent: Thu, 12 Jun 2003 09:23:59 -0600 (MDT)
> > >
> > > > Hello,
> > > >
> > > > You might need to use postfix aliases for this right now, which
> > > > work the way you want. I'll try testing a dbmail off-site forward
> > > > and see if I get the same results. Can you look in the relayed
> > > > message for Return-Path: headers? See if there are multiple ones
> > > > there, or just one with [EMAIL PROTECTED] (or none at all, I guess).
> > > > I'd have to look at the rfc for proper behavior, but it seems dbmail
> > > > should leave the Return-Path: that postfix puts in there alone, so
> > > > the far end replies to that address. If dbmail changes it itsself
> > > > (which I kind of doubt), it's probably broken. If the far end smtp
> > > > server is putting a Return-Path: from the smtp MAIL FROM command,
> > > > then... I don't know if it ought to be configured not to do that when
> > > > a Return-Path: is already present, of if dbmail should use the
> > > > Return-Path: address in it's MAIL FROM command - but one or the other
> > > > should probably fix it.
> > > >
> > > > More ramblings from the desk of,
> > > > Jesse
> > > >
> > > > ---- Original Message ----
> > > > From: Micah Stevens <[email protected]>
> > > > To: [email protected]
> > > > Subject: Re: [Dbmail] forwarded bounces
> > > > Sent: Thu, 12 Jun 2003 07:59:51 -0700
> > > >
> > > > > Yes, that entry is:
> > > > > dbmail unix - n n - - pipe
> > > > > flags=R user=dbmail:dbmail argv=/usr/local/sbin/dbmail-smtp -d
> > > > > ${recipient}
> > > > >
> > > > > On Thu June 12 2003 7:21 am, Jesse Norell wrote:
> > > > > > Hello,
> > > > > >
> > > > > > Do you have flags=R in your master.cf entry for dbmail?
> > > > > >
> > > > > >
> > > > > > ---- Original Message ----
> > > > > > From: Micah Stevens <[email protected]>
> > > > > > To: [email protected]
> > > > > > Subject: [Dbmail] forwarded bounces
> > > > > > Sent: Wed, 11 Jun 2003 22:30:01 -0700
> > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > > As I have many forwarded aliases to other domain in the table,
> > > > > > > I've been noticing that if a mail is forwarded through dbmail and
> > > > > > > gets rejected from the recipient's server, the mail gets bounced
> > > > > > > to postmaster at the dbmail domain. Ideally, the error notice
> > > > > > > should then get sent back to the original sender, but it's just
> > > > > > > getting dropped into my postmaster account.
> > > > > > >
> > > > > > > Is this behavior standard for mail forwarding or is it peculiar
> > > > > > > to dbmail? It seems wrong as the sender will never know that the
> > > > > > > mail was not recieved, but I wasn't sure if there was a technical
> > > > > > > hurdle for this happen or not. If I was using Postfix for
> > > > > > > forwarding, would it behave differently?
> > > > > > >
> > > > > > > My other thought was that there was something configured wrong,
> > > > > > > but I couldn't think of what to change. I'm running dbmail CVS as
> > > > > > > of a couple of months ago, with MySQL / Postfix.
> > > > > > >
> > > > > > > Thanks for any insight on this,
> > > > > > > -Micah
> > > > > > >
> > > > > > > _______________________________________________
> > > > > > > Dbmail mailing list
> > > > > > > [email protected]
> > > > > > > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> > > > > >
> > > > > > -- End Original Message --
> > > > > >
> > > > > >
> > > > > > --
> > > > > > Jesse Norell
> > > > > > jesse (at) kci.net
> > > > > >
> > > > > >
> > > > > > _______________________________________________
> > > > > > Dbmail mailing list
> > > > > > [email protected]
> > > > > > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> > > > >
> > > > > _______________________________________________
> > > > > Dbmail mailing list
> > > > > [email protected]
> > > > > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> > > >
> > > > -- End Original Message --
> > > >
> > > >
> > > > --
> > > > Jesse Norell
> > > > jesse (at) kci.net
> > > >
> > > >
> > > > _______________________________________________
> > > > Dbmail mailing list
> > > > [email protected]
> > > > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> > >
> > > -- End Original Message --
> > >
> > >
> > > --
> > > Jesse Norell
> > > jesse (at) kci.net
> > >
> > >
> > > _______________________________________________
> > > Dbmail mailing list
> > > [email protected]
> > > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
> > -- End Original Message --
> >
> >
> > --
> > Jesse Norell
> > jesse (at) kci.net
> >
> >
> > _______________________________________________
> > Dbmail mailing list
> > [email protected]
> > https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
> _______________________________________________
> Dbmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
-- End Original Message --
--
Jesse Norell
jesse (at) kci.net
