MySQL Forums
Forum List  »  Install & Repo

MySQL 5.5.8 SSL error: Unable to get private key from 'server-key.pem'
Posted by: Dave Kelly
Date: December 29, 2010 05:37PM

Background: running on Windows. Cert and key files made the same way work on Apache 2.2.15, but MySQL Server 5.5.8 refuses to enable SSL with the following error during service start:

SSL error: Unable to get private key from 'C:/ProgramData/MySQL/server-key.pem'
101229 15:21:28 [Warning] Failed to setup SSL
101229 15:21:28 [Warning] SSL error: Unable to get private key

The my.ini config file looks like this:

ssl = On
ssl-ca = "C:/ProgramData/MySQL/ca-cert.pem"
ssl-cert = "C:/ProgramData/MySQL/server-cert.pem"
ssl-key = "C:/ProgramData/MySQL/server-key.pem"

The cert and key files were converted from a PFX file using the Openssl command-line tool with the following sequence:

1. openssl pkcs12 -in "combined-cert.pfx" -out "combined-cert.pem" -clcerts -nodes
2. openssl x509 -inform PEM -outform PEM -in "combined-cert.pem" -out "server-cert.pem"
3. openssl pkey -inform PEM -outform PEM -in "combined-cert.pem" -out "server-key.pem"

As stated above, these work fine on Apache and verify using the Openssl command line tool.

Any ideas, please?

Options: ReplyQuote


Subject
Written By
Posted
MySQL 5.5.8 SSL error: Unable to get private key from 'server-key.pem'
December 29, 2010 05:37PM


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.