Hi all,
Just curious as I haven't heard this discussed, but are there any plans to fix
the issue with forwarding aliases in the upcoming release? I'm running 1.2.6
and it still forwards with [EMAIL PROTECTED] (in my case) in the
return path header, so bounces get sent to that instead of the original
sender. In my case, that makes them end up in my postmaster box, and it's
pretty annoying, as well as the fact it's cheating the sender out of their
rightfully earned bounce message.
I brought this up a while back, and Jesse suggested that this was something
that needed fixing on DBMail's end, and I was just curious if this was in the
works, or on a todo list, or if you guys even had this in your sights. I
hadn't heard any news about it on the lists.
Thanks, the original thread with Jesse is below.
-Micah
> [Dbmail] forwarded bounces
>
> dbmail at servpast.org dbmail at servpast.org
> Fri Jun 13 17:44:59 CEST 2003
>
> Previous message: [Dbmail] forwarded bounces
> Next message: [Dbmail] forwarded bounces
> Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
>
> In that case, I think it will be better to put the address in the
> deliver_to field and assign select field to deliver_to and and where field
> to alias. Ther real problem is that you lost some nice features like host
> (that will ne nice to have if forwarding is not to an address-domain but
> to a diferrent smtp server, perhaps in the militarized zone behind your
> firewall).
>
> And the enable/disable will allow you to implement a forward by demand.
> Last but not least, you can always add the fields to dbmail tables, but
> you will need to track down those changes when dbmail database schema
> changes (actually there´s a job in progress to support public folders and
> lmtp), so I suggest you don´t mix up things!
>
> >
> > How about I make the virtual.cf use this query:
> >
> > --- virtual.cf
> >
> > # the database name on the servers
> > dbname = dbmail
> >
> > # the table name
> > table = aliases
> >
> > select_field = dest
> > where_field = alias
> > additional_conditions = and deliver_to is like '[EMAIL PROTECTED]'
> >
> > ----
> >
> > wouldn't that just return a list of forwarded addresses only as any direct
> > delivery wouldn't include the '@' sign?
> >
> > -Micah
> >
> > On Thu June 12 2003 10:48 am, Jesse Norell wrote:
> >> 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. 1234 at yourdomain).
> >>
> >> > 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 <dbmail at dbmail.org>
> >> > > To: dbmail at dbmail.org
> >> > > 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: <dbmail at kci.net>" 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 <dbmail at dbmail.org>
> >> > > > To: dbmail at dbmail.org
> >> > > > 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 dbmail at yourdomain (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 <dbmail at dbmail.org>
> >> > > > > To: dbmail at dbmail.org
> >> > > > > 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 <dbmail at dbmail.org>
> >> > > > > > > To: dbmail at dbmail.org
> >> > > > > > > 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
> >> > > > > > > >
