Unable to connect using SSL (CA file) with MySQL Connector/J ver. 5.1.44

Pinned

Workaround:

See https://youtrack.jetbrains.com/issue/DBE-5439#focus=streamItem-27-3352630.0-0

Workaround2:
See https://youtrack.jetbrains.com/issue/DBE-5439 for a workaround. In general, one needs to rollback to 5.1.40 driver.

I connect to an Amazon Web Services MySQL RDS instance using SSL with the CA file provided at http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.SSL.html (rds-downloads/rds-combined-ca-bundle.pem)

The other day I saw in my connection the option to update the MySQL driver, and since doing so I have been unable to connect using the SSL option. However, I can connect when not using SSL.

I have managed to get SSL to work again by switching from "MySQL Connector/J ver. 5.1.44" to "MySQL Connector/J ver. 5.1.40" found under Data Sources and Drivers > Drivers > MySQL > Driver Files.

So it seems there may be a problem with the MySQL Connector/J ver. 5.1.44 driver.

6 comments

I was running into this same problem! It was driving me insane. Thanks so much for the help!!!

0

We've found the same to be true for 5.1.45 driver. Hope they get this resolved moving forward!

0

Thank you! Yes we had the same problem. Reverting to 5.1.40 resolved it for now.

1

Same issue, suddenly couldn't connect anymore with DataGrip to my RDS server. Fixed by switching to 5.1.40 by clicking on the driver and selecting another version

 

1

Had the same issue in PyCharm, reverting back to MySQL Connector/J ver. 5.1.40 does help - not sure why that happens. 

0

Yup. Rolling back to 5.1.40 was the key. I was starting to question my abilities....

1

Please sign in to leave a comment.