Bug #19547 SSL connections are not working

Submitted: 4 May 2006 21:54 Modified: 10 Jul 2006 9:31
Reporter: Matthew Lord Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.1.9 OS:Windows (Windows XP)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any
Tags: Generic

[4 May 2006 21:54] Matthew Lord
Description:
When creating a connection and checking the "use SSL" box the connection fails with:

X Could not connect to specified instance
MySQL Error Number 0

mysqld supports SSL using yaSSL and SSL connections can be made using mysql.exe.

How to repeat:
Install 5.0.21
Setup server certificates
test ssl connections using mysql --ssl
Once successful install Administrator 1.0.9, create a connection
and check the SSL box in the connection options panel.
[4 May 2006 23:16] MySQL Verification Team
Thank you for the bug report.

c:\mysql\bin>type c:\windows\my.ini
[client]
ssl-ca=c:/mysql/bin/cacert.pem
ssl-cert=c:/mysql/bin/server-cert.pem
ssl-key=c:/mysql/bin/server-key.pem

[mysqld]
basedir=c:/mysql
datadir=c:/mysql/data/
ssl-ca=c:/mysql/bin/cacert.pem
ssl-cert=c:/mysql/bin/server-cert.pem
ssl-key=c:/mysql/bin/server-key.pem

c:\mysql\bin>mysqld-nt --standalone --console -ssl
060504 20:14:18  InnoDB: Started; log sequence number 0 1566743
060504 20:14:18 [Note] mysqld-nt: ready for connections.
Version: '5.0.21-log'  socket: ''  port: 3306  Source distribution

c:\mysql\bin>mysql -uroot --ssl
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.21-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like "%ssl%";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_openssl  | YES   |
+---------------+-------+
1 row in set (0.00 sec)

mysql> exit
Bye

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.