Hey all,

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;

Qt Code: 
  1. Db = QSqlDatabase::addDatabase("QMYSQL");
  2. Db.setConnectOptions("SSL_CA=rds.pem");
  3.  
  4. Db.setDatabaseName(DBName);
  5. Db.setHostName(DBAddress);
  6. Db.setUserName(DBUserName);
  7. Db.setPassword(DBPassword);
  8.  
  9. Connected = Db.open();
To copy to clipboard, switch view to plain text mode 

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.

Qt Code: 
  1. QMYSQLDriver::open: Illegal connect option value 'SSL_CA=rds.pem'
To copy to clipboard, switch view to plain text mode 

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 7 using QT 5.5.

My apologies if I've missed something obvious.