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:	Virtual alias query question
Group:	Postfix-users
From:	Andrei-Florian Staicu
Date:	15 May 2007

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?

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?

Thanks (sorry for the fuzzy description of what I would like to do)

--
Sincerely,

Andrei-Florian STAICU
Network Administrator
Tel: (+40) 741.227.014
IPSO S.A.