'SSL error' when satrting thru systemd/systemctl
1) Without systemctl
# su - mysql -c "/usr/bin/mysqld_safe"
151013 00:10:58 mysqld_safe Logging to '/var/log/mysqld.log'.
151013 00:10:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
mysql> show global variables like '%ssl%';
+---------------+------------------------+
| Variable_name | Value |
+---------------+------------------------+
| have_openssl | YES |
| have_ssl | YES |
| ssl_ca | ca.pem |
| ssl_capath | /etc/my/ |
| ssl_cert | /etc/my/cert.pem |
| ssl_cipher | |
| ssl_crl | |
| ssl_crlpath | |
| ssl_key | /etc/my/server-key.pem |
+---------------+------------------------+
2) starting thru systemctl
# systemctl start mysqld
# grep SSL /var/log/mysqld.log
SSL error: Unable to get certificate from '/etc/my/cert.pem'
2015-10-13 00:13:51 22275 [Warning] Failed to setup SSL
2015-10-13 00:13:51 22275 [Warning] SSL error: Unable to get certificate
mysql> show global variables like '%ssl%';
+---------------+------------------------+
| Variable_name | Value |
+---------------+------------------------+
| have_openssl | DISABLED |
| have_ssl | DISABLED |
| ssl_ca | ca.pem |
| ssl_capath | /etc/my/ |
| ssl_cert | /etc/my/cert.pem |
| ssl_cipher | |
| ssl_crl | |
| ssl_crlpath | |
| ssl_key | /etc/my/server-key.pem |
+---------------+------------------------+
Versions :
# more /etc/centos-release
CentOS Linux release 7.1.1503 (Core)
mysql> show global variables like '%version%'
-> ;
+-------------------------+------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------+
| innodb_version | 5.6.27 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.6.27 |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+------------------------------+
Thx for your help !!!!!
Subject
Written By
Posted
'SSL error' when satrting thru systemd/systemctl
October 12, 2015 04:16PM
November 07, 2015 07:16AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.