MySQL Bugs: #41234: Cannot connect to SSL-secured MySQL server with Administrator

Bug #41234	Cannot connect to SSL-secured MySQL server with Administrator
Submitted:	4 Dec 2008 16:10	Modified:	15 Oct 2009 8:59
Reporter:	Chris Gross	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.2.17	OS:	Windows (XP)
Assigned to:		CPU Architecture:	Any

Description:
Setting the Advanced parameters in the MySQL Administrator for USE_SSL and SSL_CA does not allow me to connect to a MySQL server that requires SSL.  I have confirmed that the cert is valid by connecting with it using cygwin on the same machine.

The administrator only gives back the generic "MySQL Error Number 1045 Access denied for user 'user'@'location' (using password: YES)"

The stats for the server are below - I have hidden information that shouldn't be necessary.  Do note that I am connecting remotely and the PC connecting from is permitted to do so (refer to above mention of connecting via cygwin on same machine).

--------------
mysql  Ver 14.12 Distrib 5.0.26, for pc-linux-gnu (i686) using readline 5.1

Connection id:          1135592
Current database:       *****
Current user:           user@remotehost
SSL:                    Cipher in use is DHE-RSA-AES256-SHA
Current pager:          /usr/bin/less
Using outfile:          ''
Using delimiter:        ;
Server version:         5.0.54-log
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:               3308
Uptime:                 48 days 20 hours 13 min 33 sec

Threads: 2  Questions: 4039067  Slow queries: 0  Opens: 1833  Flush tables: 148  Open tables: 31  Queries per second avg: 0.957
--------------

How to repeat:
Unsure if this is a server-side or client-side issue but...

1. Get Admin 1.2.12
2. Attempt to connect to a remote MySQL 5.0 server that requires SSL
     - The only required advanced parameters should be USE_SSL and SSL_CA

Thank you for a problem report. Please, try to repeat with a newer version, 1.2.15, and inform about the results.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I can also confirm this bug on Windows XP SP2. Using 1.2.15 I get error 1045. Booting Linux on the same machine and connecting from mysql shell using

mysql -p -uuser --host=remote_host --ssl-ca=cacert.pem --ssl-key=client-key.pem --ssl-cert=client-cert.pem --ssl

works.

I have the same problem. I've also opened a bug recently, and haven't yet received an answer. Seems to connect fine via SSL using the ODBC connector. However, the Query Browser and Admin tool doesn't, Navicat works fine with SSL as well. So, the problem is with the Query Browser and Admin tool itself.

Still a bug with version 1.2.17 - on XP SP3.

Any chance that this will ever get fixed ?

Rasmus Christiansen

I have updated this to S2 because the GUI tools have now been without SSL connectivity, a major feature, for at least 11 months.  Still not functioning in version 1.2.17 on XP SP3.

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. We won't add this feature request anymore.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/