Hi !
I’d like x...@mydomain.dom being able to send mails from y...@mydomain.dom.
The actual error is : 5.7.1 y...@domain.dom: Sender address rejected: not owned
by user x...@domain.dom
My postfix configuration is a mysql one with map files.
I tried to use the unionmap fonctionnality in master.cf but i had no chance
with it.
Could you please help me being able to create some mysql record to allow user1
to send emails with user2 address ?
My config :
I use « reject_sender_login_mismatch » in main.cf
I added this line in master.cf (just before mua restrictions) :
[…]
-o smtpd_client_restrictions=$mua_client_restrictions
-o
smtpd_sender_login_maps=unionmap:{mysql:/etc/postfix/sql/sender-login-maps.cf,mysql:/etc/postfix/sql/sender_delegate_checks.cf}
-o smtpd_sender_restrictions=$mua_sender_restrictions
-o smtpd_relay_restrictions=$mua_relay_restrictions
[…]
My maps files :
sender-login-maps.cf :
user = dbusername
password = dbpassword
hosts = 127.0.0.1
dbname = dbname
query = SELECT email as user FROM virtual_users WHERE email='%s'
sender_delegate_checks.cf :
user = dbusername
password = dbpassword
hosts = 127.0.0.1
dbname = dbname
query = SELECT owned as user FROM virtual_delegation WHERE owner='%s'
Mysql virtual_delegation table :
MariaDB [mailserver]> select * from virtual_delegation;
+----+----------------------+-------------------------+
| id | owner | owned |
+----+----------------------+-------------------------+
| 1 | x...@domain.dom | y...@domain.dom |
+----+----------------------+-------------------------+
1 row in set (0.000 sec)
Thx,
Regards,
Gaetan
