Connecting to Amazon RDS over SSL causes crash

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Connect to an Amazon RDS instance over SSL using their .PEM file 
(https://rds.amazonaws.com/doc/mysql-ssl-ca-cert.pem)
2. SP crashes immediately when clicking "Connect"

What is the expected output? What do you see instead?

SP opening rather than crashing.

What version of Sequel Pro are you using? What version of MySQL are you
connecting to on the server?

SP: 0.9.9.1
MySQL: 5.1.57
OS X: 10.6.8

Please provide any additional information below.

I reported this via the crash reporter, but I'm also reporting here because 
this was the method preferred in your documentation.

I am able to connect to this instance with no problems using SP over a regular 
connection.  However, when using SSL it results in an immediate crash when I 
click "Connect".  The only setting I'm using is the "CA Cert" field, which I 
pointed to the Amazon RDS .pem file which I downloaded to my local computer.

Just to test, I downloaded MySQL Workbench, and was able to connect to the RDS 
instance over SSL using the exact same credentials.  The RDS instance holds 
roughly 50 databases at the moment if that matters.

PS.  I've attached the crash log.

Original issue reported on code.google.com by aaron.ri...@gmail.com on 6 Sep 2011 at 5:54

Attachments:

• crash_log.rtf

[GoogleCodeExporter]

Thanks for the bug report here.

I haven't been able to reproduce this on 10.6 or 10.7 against Amazon RDS 
hosting 5.1.57, connecting via either SSL with that CA or without SSL.  Are you 
doing anything else differently or extra?  Does it crash all the time, or only 
sometimes?

The crash itself is happening within the mysql libraries, and may be a 
thread-safety issue, but there could be something else contributing to the 
crashes.

Original comment by rowanb@gmail.com on 7 Sep 2011 at 11:37

[GoogleCodeExporter]

Thanks for checking into this.

Yes, it crashes every time I attempt to connect with SSL enabled.  No problems 
with SSL disabled.  I'm not doing anything out of the norm. either, just a 
basic connection. =[

I've done a fresh install of snow leopard just this past week, so my system is 
pretty clean.  The only thing I can think of that's probably different between 
our setups is that my iMac is 32-bit (time for an upgrade!).

Original comment by aaron.ri...@gmail.com on 8 Sep 2011 at 3:30

[GoogleCodeExporter]

Kapow!  Excellent debug on potential differences - if I run in 32-bit mode, I 
get the same SSL verification crash.  That will help a lot when debugging - 
many thanks.

Original comment by rowanb@gmail.com on 8 Sep 2011 at 4:00

[GoogleCodeExporter]

Nice... glad we found the problem!  Thanks again for looking into this.

Original comment by aaron.ri...@gmail.com on 8 Sep 2011 at 4:35

[GoogleCodeExporter]

Original comment by stuart02 on 8 Oct 2011 at 10:07

• Changed state: Accepted
• Added labels: Component-Logic, Milestone-Release1.0, Priority-Low, Type-Defect, Usability

[GoogleCodeExporter]

Original comment by stuart02 on 13 Aug 2012 at 7:29

• Added labels: Milestone-Release1.1
• Removed labels: Milestone-Release1.0