'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 |
|---|
