Create AWS RDS MySQL connection with SSL .pem cert without private key + IP whitelisting

[TalentPools]

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?

Additionally, our RDS uses security groups IP whitelisting. Is there a dedicated IP address that n8n is going to use for connection to RDS?

[n8n]

It looks like your topic is missing some important information. Could you provide the following if applicable.

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[TalentPools]

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

After reading several topics we’ve enabled “ignore mode” and the connection has been created

However on the worklow AI Agent refuses to connect to the Postgres with the same error: Self-signed certificate in certificate chain

Does anyone know if there is a Postgre provider that handles SSL differently and is compatible with AI Agent?

[gualter]

hello @TalentPools

Not sure about other providers but I take it hosting postgres yourself is not an option here?

[UniRing]

I’ve solved this in MySQL by mapping a local folder into the n8n container (i’m using Docker) like this:

• ./pki:/opt/custom-certificates

And adding the self signed certificates to that local pki folder in .pem format. Restart docker and they will validate.