[PLUG] Forwarding Mail

[Carlos Konstanski]

On Tue, 11 Aug 2009, Rich Shepard wrote:

> Date: Tue, 11 Aug 2009 03:46:46 -0700 (PDT)
> From: Rich Shepard <rshepard at appl-ecosys.com>
> Reply-To: "General Linux/UNIX discussion and help;	civil and on-topic"
>     <plug at lists.pdxlinux.org>
> To: "General Linux/UNIX discussion and help;	civil and on-topic"
>     <plug at lists.pdxlinux.org>
> Subject: Re: [PLUG] Forwarding Mail
> 
> On Mon, 10 Aug 2009, Carlos Konstanski wrote:
>
>> In my postfix/postgres setup, I would change the 'goto' field of the
>> 'alias' table to point to whatever email address I want.  I just tested it
>> with my yahoo account.  I think you'd want to do the equivalent (mess with
>> the aliases(, however you do that in a file-based config.
>
> Carlos,
>
>   It seems to me that the alias file is for user names rather than full
> addresses. I changed /etc/postfix/virtual so that mail addressed to her here
> is relayed to her there. Perhaps changing the alias file would work, too.
>
> Many thanks,
>
> Rich

In my setup, every domain is virtual and so is every user.  Therefore,
user names look exactly like email addresses, since they do not map to
local machine accounts.  When I log in via Squirrelmail, I have to
type the entire email address as my username.

Below is a sampling from my `alias' table.  It contains entries that
look like aliases, and also some that look very much like real
user-to-mailbox mappings.  This never made sense to me until now, as I
realize that the `address' field might really be a username field.
Maybe the distinction between username and address is completely lost
in such a virtual setup.  Such a system might look different than one
with real users.  If only I really understood it!

postfix=> select * from alias where address like '%@pippiandcarlos.com';
             address             |              goto              |       domain       |            created            |           modified            | active 
--------------------------------+--------------------------------+--------------------+-------------------------------+-------------------------------+--------
  hostmaster at pippiandcarlos.com  | ckonstanski at pippiandcarlos.com | pippiandcarlos.com | 2006-11-02 20:20:03.539414-07 | 2006-11-02 23:02:14.370951-07 | t
  abuse at pippiandcarlos.com       | ckonstanski at pippiandcarlos.com | pippiandcarlos.com | 2006-11-02 20:20:03.521354-07 | 2006-11-02 23:02:28.973171-07 | t
  postmaster at pippiandcarlos.com  | ckonstanski at pippiandcarlos.com | pippiandcarlos.com | 2006-11-02 20:20:03.5495-07   | 2006-11-02 23:02:41.835737-07 | t
  webmaster at pippiandcarlos.com   | ckonstanski at pippiandcarlos.com | pippiandcarlos.com | 2006-11-02 20:20:03.5646-07   | 2006-11-02 23:02:48.339324-07 | t
  pippi at pippiandcarlos.com       | pippi at pippiandcarlos.com       | pippiandcarlos.com | 2006-11-02 22:33:12.763242-07 | 2006-11-03 18:32:35.523646-07 | t
  mjensen at pippiandcarlos.com     | mjensen at pippiandcarlos.com     | pippiandcarlos.com | 2006-11-04 21:30:22.24389-07  | 2006-11-04 21:30:22.24389-07  | t
  keith at pippiandcarlos.com       | keith at pippiandcarlos.com       | pippiandcarlos.com | 2006-11-04 21:30:44.056888-07 | 2006-11-04 21:30:44.056888-07 | t
  jim at pippiandcarlos.com         | jim at pippiandcarlos.com         | pippiandcarlos.com | 2006-11-04 21:33:03.25656-07  | 2006-11-04 21:33:03.25656-07  | t
  info at pippiandcarlos.com        | ckonstanski at pippiandcarlos.com | pippiandcarlos.com | 2009-01-01 18:41:00.118942-07 | 2009-01-01 18:41:00.118942-07 | t
  ckonstanski at pippiandcarlos.com | ckonstanski at pippiandcarlos.com | pippiandcarlos.com | 2006-11-02 21:16:25.152472-07 | 2006-11-02 21:16:25.152472-07 | t
(10 rows)

Carlos