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

Discussion in 'General' started by Dominik, Feb 14, 2021.

  1. Dominik

    Dominik New Member HowtoForge Supporter

    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
     

    Attached Files:

    Last edited: Feb 14, 2021
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

  3. Dominik

    Dominik New Member HowtoForge Supporter

    Attached Files:

  4. Dominik

    Dominik New Member HowtoForge Supporter

    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"
     
    Last edited: Feb 14, 2021
  5. Dominik

    Dominik New Member HowtoForge Supporter

    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
     
  6. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    This was fixed last week, I presume you installed your system prior to that?
     
  7. Dominik

    Dominik New Member HowtoForge Supporter

    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
     
    Last edited: Feb 15, 2021
  8. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Undo your changes and do the following:
    1. Run
    Code:
    touch /etc/postfix/sasl_passwd
    2. Replace
    Code:
    hash:{config_dir}/sasl_passwd
    with
    Code:
    texthash:{config_dir}/sasl_passwd
    in /etc/postfix/main.cf
     
  9. Dominik

    Dominik New Member HowtoForge Supporter

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

    Dominik New Member HowtoForge Supporter

    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
    
     
    Last edited: Feb 16, 2021
  11. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    Just edit proxy_read_maps as it says (see the above link to the upstream fix if needed).
     
  12. Dominik

    Dominik New Member HowtoForge Supporter

    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
    
     
    Jesse Norell likes this.

Share This Page