title: How to setup SSL on MariaDB hosted on AWS RDS with Embarcadero FireDAC
body: <p>I'am trying to connect to a MariaDB instance hosted on AWS RDS over SSL</p>
  
  <p>Looking to the docs: <a href="http://docwiki.embarcadero.com/RADStudio/Rio/en/Connect_to_MySQL_Server_(FireDAC)" rel="nofollow noreferrer">http://docwiki.embarcadero.com/RADStudio/Rio/en/Connect_to_MySQL_Server_(FireDAC)</a></p>
  
  <p>Seems I need to set those 4 params:</p>
  
  <pre><code>UseSSL=True
  SSL_ca=ca-cert.pem
  SSL_cert=client-cert.pem
  SSL_key=client-key.pem
  </code></pre>
  
  <p>but Amazon only gives me a rds-combined-ca-bundle.pem</p>
  
  <p>I don't know much about TLS/SSL. I need to generate those .pem files?
  If yes, how?</p>
  
  <p>I also tried to do like so:</p>
  
  <pre><code>            db_params-&gt;Add("DriverID=MySQL");
              db_params-&gt;Add("Server=my.rds.url.com");
              db_params-&gt;Add("Port=9999");
              db_params-&gt;Add("Database=my_database");
              db_params-&gt;Add("User_Name=my_user");
              db_params-&gt;Add("Password=my_password");
              db_params-&gt;Add("UseSSL=True");
              db_params-&gt;Add("SSL_ca=absolute\\path\\to\\rds-combined-ca-bundle.pem");
  </code></pre>
  
  <p>But it raises the exception</p>
  
  <pre><code>[FireDAC][Phys][MySQL] SSL connection error
  </code></pre>
  
  <p>Without user and password same thing...</p>
  
  <p>Thanks in advance!</p>