MySQL Bugs: #43770: MYSQL Query Browser reports error when using SSL.

Bug #43770	MYSQL Query Browser reports error when using SSL.
Submitted:	20 Mar 2009 17:35	Modified:	3 Dec 2009 10:38
Reporter:	Christopher Barros	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.17	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
I'm running Mysql 5.1 from a MYSQL RPM and the Query Browser 1.2. I can connect via SSL from the localhost just fine. I can also connect from my workstation using SSL using Navicat. However, I can't seem to connect to Mysql with the Query Browser using SSL. I get a "MySQL Error Nr. 1045" error.

I have specified "USE_SSL" and "SSL-CA" on my Windows Client. I've also tried a linux client on the mysql server with the same results. I see that a number of others have the same issue.

How to repeat:
Install mysql 5.1 and Query Browser 1.2. Configure advanced parameters with:
USE_SSL  = YES
SSL_CA = c:/certs/ca-cert.pem

Thank you for the problem report. What exact version of QB, 1.2.x, you had used?

I'm using 1.2.17 of the Query Browser.

I just ran a test with the ODBC driver and was able to get the ODBC driver to connect with SSL by specifying "client-key.pem" for the SSL KEY. So, the problem appears to be isolated to Query Browser and Administrator.

Thank you for the bug report. Duplicate of bug: http://bugs.mysql.com/bug.php?id=7575.

Then why does MYSQL document SSL use in the Query Browser here: "http://dev.mysql.com/doc/query-browser/en/mysql-gui-options-ssl-connections.html"?

SSL use in the Query Browser client doesn't work on the Mac, Windows and linux query browser clients from any of my testing. What's the point of having SSL if none of the clients support it? It would be a great if this can be addressed. I'd be interested to know how Navicat does it's SSL connections.

Also, if Mysql Windows clients don't support SSL then why does the ODBC connector work fine when using SSL? Seems a little strange.

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Query Browser into MySQL Workbench.

Lots of functionality already is implemented in Workbench 5.2 which you can download here:

http://dev.mysql.com/downloads/select.php?display=upcoming&id=8#downloads

We won't fix this bug here in Query Browser anymore.

SSL functionality already is planned to implement in Workbench future release.