Connecting to MySQL Server using SSL (AWS RDS)

sathhin

Hey all,
First time posting!

Having a bit of trouble using an SSL connection to a MySQL server. AFAIK I have all the prerequisites installed such as, MySQL Connector and OpenSSL. Since I'm using AWS and they only provide a CA file, I have used the code below;

Db = QSqlDatabase::addDatabase("QMYSQL");
Db.setConnectOptions("SSL_CA=rds.pem");
 
Db.setDatabaseName(DBName);
Db.setHostName(DBAddress);
Db.setUserName(DBUserName);
Db.setPassword(DBPassword);
 
Connected = Db.open();

There's plenty of information out there on opening an SSL connection, there's even a nice example in the documentation of QSqlDatabase. The issue I'm having is that I can't find much information regarding the error I'm getting.

QMYSQLDriver::open: Illegal connect option value 'SSL_CA=rds.pem'

I know I'm doing something wrong, just can't figure out what. Do I need to rebuild the MySQL libraries with SSL support or does the Qt binaries already come with that enabled?

I'm on Windows 10 using QT 5.5.

My apologies if I've missed something obvious.

SGaist

Hi and welcome to devnet,

The support for that option as been added to Qt 5.6. You should update to either 5.6.1 (just released) or you can also consider 5.7RC.