SSL connection error: unknown error number QMYSQL: Unable to connect



  • I am trying to open a mysql db somewher on an external server. The QMYSQL driver is loaded, but after the open statement for the db the error message is:
    "SSL connection error: unknown error number QMYSQL: Unable to connect"

    db name, user and password are correct. With these credentials and MySQL workbench I can open the DB without SSL.

    During trials and look-up in the documentation I have found

    db.setConnectOptions("SSL_KEY=client-key.pem;SSL_CERT=client-cert.pem;SSL_CA=ca-cert.pem;CLIENT_IGNORE_SPACE=1");
    

    which does not work, since I have no key or certificate. I have tried to reset the connect options without success with

    db.setConnectOptions();
    

    Does anybody have an idea what to check and/or how to open the db connection without SSL?


  • Lifetime Qt Champion

    Hi,

    What address are you using to connect to your server instance ?



  • @SGaist

    It is simply the ipv4 address on a webhosting without any additions. Basically I had that before the identical way and it did work. Never thought about SSL for this.


  • Lifetime Qt Champion

    Are you sure that workbench is not using OpenSSL ?
    Which version of it do you want ?



  • @SGaist

    I have OpenSSL recently installed, but I am stating explicitly "no" for SSL connection option in MySql workbench.
    The connection give a warning, but this relates to the workbench version which seem to be higher than the actual MySql install at the web domain. No mention of SSL at all there.

    Since I have not really used OpenSSL I am lost on those parameters as used above. They are from the Qt document example and potentially completely wrong


Log in to reply