ODBC failing to connect to AWS RDS when SSL enabled

by Jason   Last Updated September 11, 2019 20:01 PM - source

I cannot get ODBC to connect to our MySQL RDS instance using SSL. I get the following output:

[[email protected]]# isql mysql-test_db -v
[S1000][unixODBC][MySQL][ODBC 5.1 Driver]SSL connection error
[ISQL]ERROR: Could not SQLConnect

This is the section in my odbc.ini:

Description = ODBC to MySQL test
Driver = MySQL
Database = testdb
Server = db.domain.com
User = admin
Password = password
Port = 3306
sslca = /path/to/rds-combined-ca-bundle.pem

I can connect when I remove the sslca option so I'm pretty sure the other options are correct.

Tags : mysql ssl odbc rds

Related Questions

Issue MySQL 8.0 ODBC 8.0

Updated August 13, 2019 21:01 PM

Anyway to use SSMS to connect to MySql?

Updated August 16, 2017 03:01 AM

MySQL ODBC driver 5.1 and Windows 7

Updated June 26, 2015 17:00 PM