SSL connection error.

[Anton]

hi, I am testing on a Windows XP platform. MySQL 5.0.21.

According to the release notes, SSL is included in the binary for MySQL 5.0.20a on Windows.

So, I installed OpenSSL for windows and completed the process without any errors.. the .pem files seem to be properly generated. The relevant portions of the my.ini files are:

[client]

ssl-ca="C:/OpenSSL/cacert.pem"
ssl-cert="C:/OpenSSL/client-cert.pem"
ssl-key="C:/OpenSSL/client-key.pem"

[mysqld]

ssl-ca="C:/OpenSSL/cacert.pem"
ssl-cert="C:/OpenSSL/server-cert.pem"
ssl-key="C:/OpenSSL/server-key.pem"


However, when I fire up the mysql.exe command line client on the same machine, I receive the error:

ERROR 2026 (HY000): SSL connection error

Any suggestions?
Thanks, -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[rian]

First of all, make sure you have OpenSSL installed ON THE MYSQL SERVER.

Follow as given:

1) Modify C:\OpenSSL\bin\openssl.cnf file with the following changes:

[ CA_default ]

dir = ./MyCompany # Where everything is kept
certs = $dir/certs # Where the issued certs are kept
crl_dir = $dir/crl # Where the issued crl are kept
database = $dir/index.txt # database index file.
#unique_subject = no # Set to 'no' to allow creation of
# several ctificates with same subject.
new_certs_dir = $dir/newcerts # default place for new certs.

certificate = $dir/cacert.pem # The CA certificate
serial = $dir/serial # The current serial number
crlnumber = $dir/crlnumber # the current crl number
# must be commented out to leave a V1 CRL
crl = $dir/crl.pem # The current CRL
private_key = $dir/private/cakey.pem# The private key
RANDFILE = -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --