SQL node connection issues with MariaDB database on n8n - PERFEX CRM

Questions
1

Hi everyone,

I am working with Perfex CRM, which uses a MariaDB database. I am trying to load the data into a workflow using n8n, but the connection is not successful.

I would appreciate your help in determining if a specific connector for MariaDB is needed or if there is something wrong with the process. The MySQL node in n8n does not seem to connect to the Perfex CRM database.

Has anyone faced a similar problem or have any suggestions on how to resolve it?

Thanks in advance for your help.

Here are the details of my setup:

Version of n8n: 1.58.2
Database used (default: SQLite): Yes
EXECUTIONS_PROCESS setting in n8n (default: self, main): Self
Are you running n8n via Docker?: Yes
OS: Ubuntu docker - self-hosted

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

Hey @elduquecarlos,

What error do you get when trying to connect to the database and has the database user been configured to allow connections from the n8n instance (assuming different host)?

4

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