Skip to main content

Troubleshooting Database Integrations

info

This page focuses on troubleshooting errors when setting up new database Integrations in Superblocks. Navigate to Troubleshooting SQL to get help when using existing SQL databases in your Superblocks Applications, Workflows, and Scheduled Jobs.

If you encounter errors connecting database integrations (Postgres, MySQL, MariaDB, MongoDB, SQL Server) from Superblocks, check the following conditions / scenarios:

Correct settings for:

  • Host/IP address - Results in a getaddrinfo ENOTFOUND error when the hostname is incorrect.
  • Database name - Specify the database name, not the database instance identifier. Otherwise, Superblocks will report an Unknown database error.
  • Username and Password - Invalid credentials result in Access denied or password authentication failed for user errors.

Inbound access blocked

Is there a firewall blocking access to the database? For example, if you're using Superblocks Cloud, make sure your VPC security groups have the right inbound rules to allow access from the Superblocks IP addresses. Similarly, if you're running the On-premise Agent, make sure that it is running inside the same network as the database or is allowed to connect to your database externally. Expect to see Connection timeout: failed to create socket, timeout expired, or similar errors when the database instance is not accessible from Superblocks.

Server listening internally only

If you're running your own database server, you may need to configure it to accept remote connections, instead of listening locally on its network interfaces. If the latter is true, then you can configure the server to listen on all interfaces by editing the database config file and setting the bind / listening address accordingly (for example bind_address = 0.0.0.0 for MySQL or listen_addresses = '*' for Postgres).

Testing with On-premise Agent using localhost

For Docker containers, localhost inside a container doesn't mean the same from the context of the host where the container is running. As such, you'll see ECONNREFUSED errors if you've specified localhost in the integration form. Instead, use host.docker.internal in the Superblocks integration form configuration. More on this in the Docker docs here.

If you continue having any issues connecting to your database, contact help@superblocks.com and our support team will assist promptly.