Bug #19547 SSL connections are not working

• Submitted: 4 May 2006 21:54
• Modified: 10 Jul 2006 9:31
• Reporter: Matthew Lord
• Status: Closed
• 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