'How to setup SSL on MariaDB hosted on AWS RDS with Embarcadero FireDAC

I'am trying to connect to a MariaDB instance hosted on AWS RDS over SSL

Looking to the docs: http://docwiki.embarcadero.com/RADStudio/Rio/en/Connect_to_MySQL_Server_(FireDAC)

Seems I need to set those 4 params:

UseSSL=True
SSL_ca=ca-cert.pem
SSL_cert=client-cert.pem
SSL_key=client-key.pem

but Amazon only gives me a rds-combined-ca-bundle.pem

I don't know much about TLS/SSL. I need to generate those .pem files? If yes, how?

I also tried to do like so:

            db_params->Add("DriverID=MySQL");
            db_params->Add("Server=my.rds.url.com");
            db_params->Add("Port=9999");
            db_params->Add("Database=my_database");
            db_params->Add("User_Name=my_user");
            db_params->Add("Password=my_password");
            db_params->Add("UseSSL=True");
            db_params->Add("SSL_ca=absolute\\path\\to\\rds-combined-ca-bundle.pem");

But it raises the exception

[FireDAC][Phys][MySQL] SSL connection error

Without user and password same thing...

Thanks in advance!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source