后缀 – 允许发送电子邮件与相关的别名

我已经在debian 8上安装了postfix 2.11.3 + sasl + postfixadmin + dovecot + roundcube。所有工作正常，但今天每个用户都可以用另一个电子邮件地址发送邮件。 我想添加一个限制，允许用户发送电子邮件只与他们的邮箱或与他们的邮箱相关的别名。

例子 ：
1）邮箱
[email protected]
[email protected]

2）别名
[email protected]转到[email protected]
[email protected]转到[email protected]

我希望[email protected]以[email protected]，只能发送电子邮件[email protected]和[email protected]。
user1不应该能够使用user2，alias2或其他。

• Exchange 2013，合作关系，域名和不在办公室
• Exim4电子邮件转发不起作用
• 电子邮件转发地址（又名别名）如何工作？
• 通过与发件人域匹配的别名筛选邮件收件人
• 是否有可能创build一个全局的SQL Server别名？

我正在寻找使用mysql_table查找的解决scheme，因为我使用postfixadmin和mysqlpipe理邮箱和别名。 像这样的东西：

SELECT address FROM alias WHERE address = '%s' AND goto LIKE '%<login>%' 

从手册页，只有参数可用：

  %s This is replaced by the input key. SQL quoting is used to make sure that the input key does not add unexpected metacharacters. %u When the input key is an address of the form user@domain, %u is replaced by the SQL quoted local part of the address. Otherwise, %u is replaced by the entire search string. If the localpart is empty, the query is sup- pressed and returns no results. %d When the input key is an address of the form user@domain, %d is replaced by the SQL quoted domain part of the address. Otherwise, the query is suppressed and returns no results. %[SUD] The upper-case equivalents of the above expansions behave in the query parameter identically to their lower-case counter-parts. With the result_format parameter (see below), they expand the input key rather than the result value. %[1-9] The patterns %1, %2, ... %9 are replaced by the corre- sponding most significant component of the input key's domain. If the input key is [email protected], then %1 is com, %2 is example and %3 is mail. If the input key is unqualified or does not have enough domain components to satisfy all the specified patterns, the query is sup- pressed and returns no results. 

login不可用。

我知道有一个解决scheme来对roundcube进行限制，但我的用户可以直接访问他们的电子邮件，而不需要使用roundcube。

在此先感谢您的帮助。

UPDATE

我试过这个： main.cf

 smtpd_sender_login_maps = mysql:/etc/postfix/mysql-virtual-sender-maps.cf smtpd_sender_restrictions = reject_authenticated_sender_login_mismatch permit_sasl_authenticated 

mysql-virtual-sender-maps.cf

 user = mailuser password = xxxxxxxxxxxxxxxx hosts = 127.0.0.1 dbname = postfixadmin query = SELECT address FROM alias WHERE goto LIKE '%%%s%%' 

用user1login，我能够发送带有别名2的电子邮件。

数据库的内容是postfixadmin的默认值：

 CREATE TABLE IF NOT EXISTS `alias` ( `address` varchar(255) NOT NULL, `goto` text NOT NULL, `domain` varchar(255) NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `active` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Aliases'; CREATE TABLE IF NOT EXISTS `mailbox` ( `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `name` varchar(255) CHARACTER SET utf8 NOT NULL, `maildir` varchar(255) NOT NULL, `quota` bigint(20) NOT NULL DEFAULT '0', `local_part` varchar(255) NOT NULL, `domain` varchar(255) NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `active` tinyint(1) NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Mailboxes'; 

 query = SELECT goto FROM alias WHERE address = '%s' 

 smtps inet n - y - - smtpd -o syslog_name=postfix/smtps -o smtpd_tls_wrappermode=yes -o smtpd_recipient_restrictions=permit_sasl_authenticated,reject_unauth_destination -o smtpd_sender_restrictions=reject_authenticated_sender_login_mismatch -o smtpd_sender_login_maps=mysql:/etc/postfix/mysql-smtpd-sender-login-maps.cf,mysql:/etc/postfix/mysql-virtual-sender-maps.cf 

 user = mailuser password = xxxxxxxxxxxxxxxx hosts = 127.0.0.1 dbname = postfixadmin query = SELECT goto FROM alias WHERE address='%s' 

 user = mailuser password = xxxxxxxxxxxxxxxx hosts = 127.0.0.1 dbname = postfixadmin query = select username from mailbox where username='%s'