MySQL with SSL Disabled

Found an issue today that was resolved fairly easily, but was a pain to find.

Was trying to get MySQL working with SSL, did everytihing in the howtos, everything looked right. But I was still getting that have_openssl & have_ssl were DISABLED.

Turns out the problem was the private key file.

MySQL wants the header to be:
-----BEGIN RSA PRIVATE KEY----- 

OpenSSL 1.0 makes a header of:
-----BEGIN PRIVATE KEY-----

Openssl 9.8 includes the RSA in the header.

The difference stems from:
– PKCS#1 RSAPrivateKey** (PEM header: BEGIN RSA PRIVATE KEY)
– PKCS#8 PrivateKeyInfo* (PEM header: BEGIN PRIVATE KEY)

Please note that the footer has to match the header as well.

Leave a Reply