On Wednesday, August 05, 2009 at 14:43 CEST,
K bharathan <kbhara...@gmail.com> 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
mag...@dsek.lth.se
