Troubleshooting connection issues page

[susodapop]

Preview

Connection problems will generally fall into three categories:

• The target database is improperly configured
• The IP connection is interupted
• Redash is improperly configured

If you’re using the Hosted Redash service and your data source is behind a firewall, you need to allow access from the IP address 52.71.84.157 in your database firewall/Security Groups.

Apart from this portion in the Getting Started guide, what are other common connection problems? Are there particular databases that error-out more than others?

Initial Steps

Confirm database is accessible apart from Redash: Most databases provide a command line application (CLI). Confirm with this CLI that the database is operational.

Confirm your firewall will accept connections from 52.71.84.157: Should we provide examples in common firewalls like PFsense, IIS, UFW etc?

Request for feedback

Before I put this together I'd like to know what questions we commonly see.

[arikfr]

Quick notes:

1. For firewall rules, the only example worth adding are Security Groups configuration. Anyone who has some other firewall, will probably know how to manage it or have someone on the team who can do it (who set it up in the first place).
2. Worth mentioning a note on instances on private networks (maybe even provide a way to check if an IP is internal).
3. We can make the tip about our IP a bit more general by specifying that, if you're using hosted Redash then this is the IP you need to whitelist, but if you're self hosting it's the IP of the Redash host.