Hi everyone!
I’m trying to create a MySQL connection that’s hosted on Amazon RDS. The connection manager on n8n requires cert private key. AWS RDS handles SSL connections differently - it provides .pem certificate file without a private key (Using SSL/TLS to encrypt a connection to a DB instance or cluster - Amazon Relational Database Service). How can I use .pem certificate without a private key to create a MySQL connection on n8n?
We’ve switched to Postgres connection, but both on AWS RDS Postgres instance and DigitalOcean Postgres instance the connection manager returns the following error: Self-signed certificate in certificate chain