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 contains 3 replies, has 0 voices, and was last updated by  Stephan123 3 years, 1 month ago.

  • 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

You must be logged in to reply to this topic.