I agree with Micah. DBMail alias table it´s to resolved address that will
be recieve by DBMail, not to forward it.
>
> 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
>
>
> _______________________________________________
> Dbmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
