Re: Virtual alias query question

2 msg	Deliver mail using my ISP server
3 msg	How can I avoid mime 8-bit errors in incoming e...
3 msg	non standard .forward location
2 msg	Cannot send mail from command line
2 msg	Address rewriting - converting an old domain to...
4 msg	Email routing like MX functionality
4 msg	3rd party spam filter and virtual users
2 msg	I don't understand how does postfix work with a...
2 msg	Sanitize 'Undelivered Mail Returned to Sender'
5 msg	Suggestion

Virtual alias query question
\ Andrei-Florian Staicu (15 May 2007)
. \ Magnus Bäck (15 May 2007)
. \ mouss (15 May 2007)

4 msg	How to force Postfix to rewrite (or masquerade)...
4 msg	Unknown error
9 msg	Trouble with mailbox_transport=error:foo
1 msg	per domain reporting ?
7 msg	make error
1 msg	postfix + procmail delivery
3 msg	Where's snapshot -20070511?
1 msg	tlsmgr on solaris9
6 msg	sasl problem

Subject:	Re: Virtual alias query question
Group:	Postfix-users
From:	mouss
Date:	15 May 2007

Andrei-Florian Staicu wrote:
> Hello
>
> I use postfix with virtual domains, mysql backend.
> I have virtual_alias_maps =
> proxy:mysql:$config_directory/mysql_virtual_alias_maps.cf
> mysql_virtual_alias_maps.cf is as follows:
> user = postfix
> password = <password>
> hosts = localhost
> dbname = postfix
> query = SELECT goto FROM alias WHERE address='%s' AND active
> = '1'
>
> I would like to create some "groups" in the mailbox table, adding a
> column with the list of groups the specific address belong to.
> Therefore, I will "complicate" the query to select from that table also.
> The problems is the I would like these groups (that is departments) to
> be accesible only when the sender is within that specific domain.
>
> To and with the real question: I see that the query uses %s to specify
> the "send to" address. Is there an option for the "from" address?
>
no, '%s' is not a recipient or sender address. it is the "argument" of
the query. so in check_sender_access, '%s' is the sender.
> I also have a second question: is there a straightforward way to
> create an all@domain alias and restrict access to it from within that
> domain only?

see Magnus reply.
>
> Thanks (sorry for the fuzzy description of what I would like to do)
>