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

koahnig

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?

SGaist

Hi,

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

koahnig

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

SGaist

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

koahnig

@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

Aditya20

@koahnig Try using skip_ssl in my.ini file located in MySQL installer path. This worked out for me.

[mysqld]

skip_ssl