Hi everyone!
I’m trying to establish a MySQL connection on Amazon RDS using n8n. The n8n connection manager requires a certificate’s private key, but AWS RDS provides only a .pem certificate without one (Using SSL/TLS to encrypt a connection to a DB instance or cluster - Amazon RDS).
How can I use this .pem certificate in n8n to create a secure MySQL connection?
Additionally, our RDS instance employs security groups for IP whitelisting. Is there a dedicated IP address that n8n uses for connecting to RDS?

Screenshot 2024-12-24 at 14.15.02 3018×1808 210 KB