MySQL Forums
Forum List  »  Install & Repo

'SSL error' when satrting thru systemd/systemctl
Posted by: Nicolas Dorfsman
Date: October 12, 2015 04:16PM

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 !!!!!

Options: ReplyQuote


Subject
Written By
Posted
'SSL error' when satrting thru systemd/systemctl
October 12, 2015 04:16PM


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.