Sending  ruls

-------

postfix - allow sending email with related alias

user1@example.com, logged with user1@example.com, can send email with user1@example.com and alias1@example.com only.

user1 should not be able to use user2, alias2 or whatever.

Examples :

1) Mailboxes

user1@example.com

user2@exemple.com

2) Alias

alias1@example.com goto user1@example.com

alias2@example.com goto user2@example.co

# main.cf

smtpd_sender_login_maps = 

             proxy:mysql:/etc/postfix/mysql-smtpd-sender-login-maps.cf,

             proxy:mysql:/etc/postfix/mysql-virtual-sender-maps.cf

*** creat file Postfix - SQL

#mysql-virtual-sender-maps.cf:

user = postfixadmin

password = dhaka1234

hosts = localhost

dbname = postfixadmin

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

#mysql-smtpd-sender-login-maps.cf

user = postfixadmin

password = dhaka1234

hosts = localhost

dbname = postfixadmin

query = select username from mailbox where username = '%s'

-------