Re: Which documentation to read for this..

2 msg	Duplicate messages with always_bcc
14 msg	[OT] Saving outgoing email Gmail style
3 msg	451 error
10 msg	Postfix 2.5 release candidate (and 2.6 snapshot...
2 msg	postfix errors when sending smtp auth via yahoo
4 msg	Documentation enhancement: Adjusting DB file pe...
11 msg	I don't want Postfix to confirm users via telnet
3 msg	Question on Earthlink and dnsbl.sorbs.net
36 msg	Re: Enforced Outbound TLS (part deux)
6 msg	smtpd_proxy_filter to unix: problem
4 msg	Again troubles with postfix and cyrus-sasl
3 msg	Exclude local host from smtpd_proxy_filter
4 msg	transport nexthop nexthop
3 msg	TLS has been selected, but TLS support is not c...

Which documentation to read for this..
\ Steve Finkelstein (14 Jan 2008)
. \ mouss (15 Jan 2008)

4 msg	Exchange 2003 to Postfix maildir migration
7 msg	virtual_mailbox_base & LDAP
12 msg	Enforced Outbound TLS
2 msg	postfix+maildrop error
10 msg	Outgoing IP address

Subject:	Re: Which documentation to read for this..
Group:	Postfix-users
From:	mouss
Date:	15 Jan 2008

Steve Finkelstein wrote:
> Hi folks,
>
> I'm looking to get pointed in the correct direction on which documentation
> to read if I plan on doing MySQL mapping for virtual user accounts for which
> my Postfix installation is the final destination ... however, it won't be
> storing messages locally. I'm just offering a relay service to where all
> recipients can have the mail forwarded/relayed to whatever email of their
> choice.
>
> I'd like to integrate this using a relational database such as MySQL, and
> I've found several pieces of documentation out there which discusses setting
> up MySQL with Postfix. However much of the documentation talks about local
> virtual accounts which I don't care for. I just want to figure out a table
> schema and mechanism to forward on the email.

it seems that you need virtual_alias_maps. you need to read the MYSQL
README. you will have something like this in your .cf file:

hosts = yoursqlhost
user = yourdbuser
password = yoursqlpassword
dbname = mail
query = SELECT destination from virtual_alias where alias = '%s'

This assumes a virtual_alias table with two fields: alias and destination.

you will also need to add the domain to virtual_alias_domains.