Connecting to MySQL Server using SSL (AWS RDS)



  • 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.


  • Lifetime Qt Champion

    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.


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.