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

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?

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:

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
Screenshot 2024-12-26 at 16.12.17

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?

hello @TalentPools

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

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.

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.