Troubleshooting Database Integrations
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, Worklfows, 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 ENOTFOUNDerror when the hostname is incorrect.
- Database name - Specify the database name, not the database instance identifier. Otherwise, Superblocks will report an
- Username and Password - Invalid credentials result in
password authentication failed for usererrors.
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 email@example.com and our support team will assist promptly.