thanks all i'll check with postfixadmin On Wed, Aug 5, 2009 at 3:34 PM, Magnus Bäck <[email protected]> wrote:
> On Wednesday, August 05, 2009 at 14:43 CEST, > K bharathan <[email protected]> wrote: > > > in fact the setup is virtual users/mysql with postfixadmin; how can i > > put a virtual alias map? > > Doesn't Postfixadmin already support this? > > > i feel sql to be queried for expanding the list members; i'm not > > getting that part properly.. > > Use virtual alias rewriting, i.e. virtual_alias_maps. DO NOT make the > domain a virtual alias domain unless it already is. Create a file that > will hold the configuration of how Postfix should query MySQL. The example > shows you the idea but requires adjustments of the SQL query to suit > your schema. Test lookups with "postmap -q" before putting them into > production. > > /etc/postfix/main.cf: > virtual_alias_maps = mysql:/etc/postfix/virtual-aliases.cf > > /etc/postfix/virtual-aliases.cf: > hosts = databaseserver.example.com > user = username > password = secret > query = SELECT member FROM distribution_lists WHERE name = '%s' > > Please do not top-post. > > -- > Magnus Bäck > [email protected] >
