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

This topic contains 1 reply, has 2 voices, and was last updated by  Sibin A S 6 months, 2 weeks ago.

  • Author
    Posts
  • #36104

    Staffan Sjöstedt
    Participant

    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:           user@an.ip.num.ber
    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
    Moderator

    Hi,

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

    Regards,
    Sibin

You must be logged in to reply to this topic.