Cannot connect to RDS MariaDB with SSL

[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

[Sibin A S]

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

[Author]

Posts