Я пытаюсь включить SSL в MySQL, работающей в Ubuntu
Код: Выделить всё
+-------------------------------------+-----------------------------+
| Variable_name | Value |
+-------------------------------------+-----------------------------+
| admin_ssl_ca | |
| admin_ssl_capath | |
| admin_ssl_cert | |
| admin_ssl_cipher | |
| admin_ssl_crl | |
| admin_ssl_crlpath | |
| admin_ssl_key | |
| have_openssl | DISABLED |
| have_ssl | DISABLED |
| mysqlx_ssl_ca | |
| mysqlx_ssl_capath | |
| mysqlx_ssl_cert | |
| mysqlx_ssl_cipher | |
| mysqlx_ssl_crl | |
| mysqlx_ssl_crlpath | |
| mysqlx_ssl_key | |
| performance_schema_show_processlist | OFF |
| ssl_ca | /opt/mysql/keys/ca.pem |
| ssl_capath | |
| ssl_cert | /opt/mysql/keys/tls.pem |
| ssl_cipher | |
| ssl_crl | |
| ssl_crlpath | |
| ssl_fips_mode | OFF |
| ssl_key | /opt/mysql/keys/tls-key.pem |
| ssl_session_cache_mode | ON |
| ssl_session_cache_timeout | 300 |
+-------------------------------------+-----------------------------+
27 rows in set (0.01 sec)
Selinux не включен. Есть ли более подробный журнал, который я мог бы посмотреть? Я вижу только
Код: Выделить всё
2024-03-13T13:33:00.962002Z 0 [Warning] [MY-013595] [Server] Failed to initialize TLS for channel: mysql_main. See below for the description of exact issue.
2024-03-13T13:33:00.962052Z 0 [Warning] [MY-010069] [Server] Failed to set up SSL because of the following SSL library error: SSL_CTX_set_default_verify_paths failed
2024-03-13T13:33:00.983378Z 0 [Warning] [MY-011302] [Server] Plugin mysqlx reported: 'Failed at SSL configuration: "SSL context is not usable without certificate and private key"'
Код: Выделить всё
sudo -u mysql cat /opt/mysql/keys/tls-key.pem -----BEGIN RSA PRIVATE KEY-----Источник: https://stackoverflow.com/questions/781 ... ths-failed
