Problem with Mails on new Ubuntu 20.04 Multiserver local data error while talking to

Hi,
if installed a new Multiserver Setup with the guide Ubuntu Guide.
After this i have problems sending mails to specific receipients.
postfix/smtp[2529651]: error: open database /etc/postfix/sasl_passwd.db: No such file or directory
postfix/smtp[2529653]: warning: 16ADF221826: smtp_sasl_password_maps lookup error
postfix/smtp[2530650]: 5F42E22191A: to=, relay=:25, delay=189573, delays=189573/0.03/0.22/0, dsn=4.3.0, status=deferred (local data error while talking to ...)

After installation i have changed my hostname from the install hostnames to the productive hostnames.
I used the migration tool to migrate the data to the servers.

Here are the master and main.cf


Regards

Dominik

 

Hi Thom,
sorry for don't reading the guidelines and thanks for sending me the link to it.
The howto i have used was:
https://www.howtoforge.com/tutorial...l-pureftpd-bind-postfix-doveot-and-ispconfig/

 

The following is in the main.cf file :
smtp_sasl_password_maps = proxy:mysql:/etc/postfix/mysql-virtual_sender-relayauth.cf, hash:/etc/postfix/sasl_passwd
But i don't find a /etc/postfix/sasl_passwd on the system
The next Error i get is:

postfix/trivial-rewrite[19441]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql-virtual_sender-relayhost.cf"

 

Ok i found a Solution here: https://forum.howtoforge.de/threads/ubuntu-20-04-mail-probleme-bei-neuer-installation.12421/page-2
I commented out the following lines in main.cf

sender_dependent_relayhost_maps = proxy:mysql:{config_dir}/mysql-virtual_sender-relayhost.cf
smtp_sasl_password_maps = proxy:mysql:{config_dir}/mysql-virtual_sender-relayauth.cf, hash:{config_dir}/sasl_passwd
smtp_sender_dependent_authentication = yes
smtp_sasl_auth_enable = yes
smtp_sasl_security_options = noanonymous, noplaintext
smtp_sasl_tls_security_options = noanonymous

 

Yes the system was installed bevor.
Is there any other thing i should check or is everything OK with the settings in Main.CF

Thanks
Dominik

 

And the Problem With
postfix/trivial-rewrite[19441]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql-virtual_sender-relayhost.cf"

 

Hi Thom
i have done the steps above.
And uncommented the part from me.
But now i can't send mails. This does not solve the problem.

Code:

Feb 16 09:14:54 srv2 postfix/proxymap[718869]: warning: request for unapproved table: "mysql:/etc/postfix/mysql-virtual_sender-relayhost.cf"
Feb 16 09:14:54 srv2 postfix/proxymap[718869]: warning: to approve this table for read-only access, list proxy:mysql:/etc/postfix/mysql-virtual_sender-relayhost.cf in main.cf:proxy_read_maps
Feb 16 09:14:54 srv2 postfix/trivial-rewrite[718960]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql-virtual_sender-relayhost.cf"
Feb 16 11:42:21 srv2 postfix/proxymap[754340]: warning: to approve this table for read-only access, list proxy:mysql:/etc/postfix/mysql-virtual_sender-relayauth.cf in main.cf:proxy_read_maps

 

Ok Thanks Jesse,
that did it.

main.cf edit the following line from

Code:

proxy_read_maps =  $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $sender_bcc_maps $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $smtpd_sender_login_maps $virtual_uid_maps $virtual_gid_maps $smtpd_client_restrictions $smtpd_sender_restrictions $smtpd_recipient_restrictions

to

Code:

proxy_read_maps = proxy:mysql:/etc/postfix/mysql-virtual_sender-relayauth.cf $sender_dependent_relayhost_maps $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $sender_bcc_maps $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $smtpd_sender_login_maps $virtual_uid_maps $virtual_gid_maps $smtpd_client_restrictions $smtpd_sender_restrictions $smtpd_recipient_restrictions