Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Ssl Connect Error

forums forums SQLyog SQLyog: Bugs / Feature Requests Ssl Connect Error

Tagged: ,

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • #13456
      Stephan123
      Member

      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

    • #35574
      peterlaursen
      Participant

      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. 

    • #35575
      Stephan123
      Member

      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

    • #35576
      peterlaursen
      Participant

      Would you allow us temporary access to this server. If so please contact us at support@webyog.com 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? 

    • #35577
      Stephan123
      Member

      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

Viewing 4 reply threads
  • You must be logged in to reply to this topic.