Ssl Connect Error

[Stephan123]

I want to connect with SSL to an external database .

In addition I have created an SSL certificate.

The instructions below

‘ http://lowendbox.com/blog/getting-started-with-mysql-over-ssl/ ‘ .

If I want to connect to the database I get an error .

The error message is :

‘ Error No. 2026 SSL connection error : wrong version number ‘ .

I use SQLYog in version 12.1 .

Who can help ?

Stephan

[peterlaursen]

Please tell the MySQL verson and the OpenSSL version used to generate the keys.

 

This error (a 4-digit error starting with “2”) is a MySQL client/protocol error. There is a similar report here https://bugs.mysql.com/bug.php?id=64870.  Does this have something you can use?

 

 

As a workaround can you try to SSH-tunnel instead?  Note that for this you will keys in Putty-format. The ‘Puttygen’ utility can convert keys. 

[Stephan123]

Hello,

 

I use SQLYog version 12.1 and OpenSSL vers. 1.0.1k , 8 Jan 2015 on debian8 server.

 

Here is the my.cnf

 

…

 

[client]

ssl-ca=/ssl/ca-cert.pem

ssl-cert=/ssl/client-cert.pem

ssl-key=/ssl/client-key.pem

 

…

 

[mysqld]

ssl-ca=/ssl/ca-cert.pem

ssl-cert=/ssl/server-cert.pem

ssl-key=/ssl/server-key.pem

 

…

 

 

 

Sorry for my bad english.

 

 

Your sincerly

 

Stephan

[peterlaursen]

Would you allow us temporary access to this server. If so please contact us at [email protected] so that we can exchange details privately. You should then create a user account for us. It will not need to have access to any data. But also this we can arrange privately.

 

BTW: did you try SSH-tunnel? 

[Stephan123]

Hello there,

Thanks for the information. I will prepare an experimental server .

This server is identical to the production server .

I send a mail when the server is ready.

With best regards

Stephan

[Author]

Posts