[FIXED] Cant send Mails since configuring MySQL with SSL

Discussion in 'ISPConfig 3 Priority Support' started by ktownmods, Jul 9, 2019.

  1. ktownmods

    ktownmods Member HowtoForge Supporter

    Hey, i cant send email.

    I think its since i configured mysql to use SSL.

    Here is my mail.log

    Code:
    6:16 mail postfix/proxymap[24015]: warning: connect to mysql server 127.0.0.1: SSL connection error: SSL_CTX_set_default_verify_paths failed
    Jul  9 12:46:16 mail postfix/trivial-rewrite[24018]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "*"
    Jul  9 12:46:16 mail postfix/trivial-rewrite[24018]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "*"
    Jul  9 12:46:16 mail postfix/proxymap[24015]: warning: connect to mysql server 127.0.0.1: SSL connection error: SSL_CTX_set_default_verify_paths failed
    Jul  9 12:46:16 mail postfix/trivial-rewrite[24018]: warning: virtual_mailbox_domains: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem
    Jul  9 12:46:16 mail postfix/trivial-rewrite[24018]: warning: virtual_mailbox_domains lookup failure
    Jul  9 12:46:16 mail postfix/trivial-rewrite[24018]: warning: virtual_mailbox_domains: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem
    Jul  9 12:46:16 mail postfix/trivial-rewrite[24018]: warning: virtual_mailbox_domains lookup failure
    Jul  9 12:46:16 mail postfix/trivial-rewrite[24018]: warning: virtual_mailbox_domains: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem
    Jul  9 12:46:16 mail postfix/trivial-rewrite[24018]: warning: virtual_mailbox_domains lookup failure
    Also the permissons of the ssl files
    Code:
    -r-------- 1 mysql root 1440 Jul  7 23:16 ca-cert.pem
    -r-------- 1 mysql root 1679 Jul  7 23:16 ca-key.pem
    -r-------- 1 mysql root 1294 Jul  7 23:22 client-cert.pem
    -r-------- 1 mysql root 1679 Jul  7 23:22 client-key.pem
    -r-------- 1 mysql root 1704 Jul  7 23:21 client-key-pkcs8.pem
    -r-------- 1 mysql root 1054 Jul  7 23:22 client-req.pem
    -r-------- 1 mysql root 1294 Jul  7 23:21 server-cert.pem
    -r-------- 1 mysql root 1679 Jul  7 23:21 server-key.pem
    -r-------- 1 mysql root 1704 Jul  7 23:20 server-key-pkcs8.pem
    -r-------- 1 mysql root 1054 Jul  7 23:21 server-req.pem
    How can i fix that?

    THX

    EDIT: FIXED MY SELF WITH

    Code:
     chmod 644 ca-cert.pem ca-key.pem client-cert.pem client-key.pem client-key-pkcs8.pem client-req.pem server-cert.pem server-key.pem server-key-pkcs8.pem server-req.pem

    Code:
    -rw-r--r-- 1 mysql root 1440 Jul  7 23:16 ca-cert.pem
    -rw-r--r-- 1 mysql root 1679 Jul  7 23:16 ca-key.pem
    -rw-r--r-- 1 mysql root 1294 Jul  7 23:22 client-cert.pem
    -rw-r--r-- 1 mysql root 1679 Jul  7 23:22 client-key.pem
    -rw-r--r-- 1 mysql root 1704 Jul  7 23:21 client-key-pkcs8.pem
    -rw-r--r-- 1 mysql root 1054 Jul  7 23:22 client-req.pem
    -rw-r--r-- 1 mysql root 1294 Jul  7 23:21 server-cert.pem
    -rw-r--r-- 1 mysql root 1679 Jul  7 23:21 server-key.pem
    -rw-r--r-- 1 mysql root 1704 Jul  7 23:20 server-key-pkcs8.pem
    -rw-r--r-- 1 mysql root 1054 Jul  7 23:21 server-req.pem
     
    Last edited: Jul 9, 2019
    till likes this.

Share This Page