MySQL Forums
Forum List  »  Security

Please help.... doesn't work SSL on MySQL
Posted by: Charles Tang
Date: August 24, 2010 08:07PM

I using the OpenSSL 1.0 and MySql server 5.1.5 on windows 7.
I followed this MySql website http://dev.mysql.com/doc/refman/5.0/en/secure-create-certs.html to created the ssl-ca, ssl-cert & ssl-key and edit the my.ini file but it doesn't work. the have_openssl still is Disabled.

mysql> show variables like '%ssl%';
+---------------+-----------------------------+
| Variable_name | Value |
+---------------+-----------------------------+
| have_openssl | DISABLED |
| have_ssl | DISABLED |
| ssl_ca | C:/newcerts/ca-cert.pem |
| ssl_capath | |
| ssl_cert | C:/newcerts/server-cert.pem |
| ssl_cipher | |
| ssl_key | C:/newcerts/server-key.pem |
+---------------+-----------------------------+
7 rows in set (0.00 sec)

but when I remove the ssl_cert in the my.ini. The have_openssl will be YES.

mysql> show variables like '%ssl%';
+---------------+-------------------------------+
| Variable_name | Value |
+---------------+-------------------------------+
| have_openssl | YES |
| have_ssl | YES |
| ssl_ca | /etc/mysql-ssl/ca-cert.pem |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_key | /etc/mysql-ssl/server-key.pem |
+---------------+-------------------------------+
7 rows in set (0.00 sec)

I don't know what happened on it and how to fix it.
Please help me to fix it.

Thank you for your help....

Options: ReplyQuote


Subject
Views
Written By
Posted
Please help.... doesn't work SSL on MySQL
5676
August 24, 2010 08:07PM


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.