Issues Creating a MySql Connection

Questions
1

Hello Community! I’m having a strange issue trying to connect a MySQL DB that’s hosted in AWS RDS.

I’ve configured the DB in N8N with the same exact credentials I’ve used to successfully connect to the DB in DBeaver but the attempt to connect keeps timing out and not able to successfully connect.

Note this is just a test and I have no SSL params set up. Any help here is VERY much appreciated.

2

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:
3

Hey @cs_lec,

What error are you seeing when trying to connect? It sounds like it could be that the n8n instance is not allowed to access the database instance but it could be that the certificate is not trusted as well which would result in an SSL/TLS error.

4

Thanks for the response here. It ended up being a whitelisting issue on the inbound request to the DB. I whitelisted all inbound IPs for the test in the AWS config and that cleared it up.

5

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