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

Cannot connect to RDS MariaDB with SSL

forums forums SQLyog Using SQLyog Cannot connect to RDS MariaDB with SSL

Viewing 1 reply thread
  • Author
    • #36104
      Staffan Sjöstedt

      Hi all
      I’m failing to get a SSL connection with SQLYog to our AWS RDS MariaDB server.
      In SQLYog I try to use SSL with the ca-certificate downloaded from AWS: “rds-combined-ca-bundle.pem”.
      SQLYog’s response is “You are trying to connect through SSL to a server which is not configured for SSL.”

      However, I have no problem to get a SLL connection with mysql.exe. There I use this command line:
      C:\afolder>mysql --host="serverurl" --user=user --password=secretsecret --ssl --ssl-ca=c:\certs\rds-combined-ca-bundle.pem

      and the response to the command ‘status’ is:

      MariaDB [(none)]> status;
      mysql Ver 15.1 Distrib 5.5.45-MariaDB, for Win64 (AMD64)

      Connection id:          203123
      Current database:
      Current user:           [email protected]
      SSL:                    Cipher in use is AES256-SHA
      Using delimiter:        ;
      Server:                 MariaDB
      Server version:         10.0.24-MariaDB MariaDB Server
      Protocol version:       10
      Connection:             serverurl via TCP/IP

      What am I missing here?

      Thanks in advance
      Staffan S

    • #36117
      Sibin A S


      We have replied to the ticket that you created.

      The solution was,

      Please note, The AWS documentation here >> https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MariaDB.html#MariaDB.Concepts.SSLSupport mentions ” MariaDB 10.2 now uses OpenSSL for secure connections.”


Viewing 1 reply thread
  • You must be logged in to reply to this topic.