Connect your SQL database to Geckoboard using Databases
Before you start
Run through this checklist to prepare your database for connecting to Geckoboard:
- Verify that your database is running correctly.
- Ensure your database accept connections from these Geckoboard IP addresses:
23.23.205.140,50.16.244.16,54.204.39.96,54.243.225.101,54.243.235.136,54.243.235.173 - Geckoboard only allows SELECT queries, but for extra security, we only accept connections from users that have read-only access to the DB.
- Connections between Geckoboard and your database will be encrypted so your database must have TLS encryption enabled.
Otherwise, let us know.
Databases currently support MySQL, PostgreSQL, and Amazon Redshift databases.
Tip
If your database doesn't allow SSL connections, is not accessible online, you prefer to handle the connection yourself or want to connect to Microsoft SQL Server or a database we don't currently support with Databases, you can use one of these alternative methods.
Connecting your database
To make a new connection to an SQL database, follow these steps.
- On the Connect to Database panel, choose a Database type.
- Type in the Connection name. Give it a memorable name that helps you remember this connection.
- Type in the Host (this could be your Public IP) and Port. By default the port is set to 5432.
Note
We cannot connect to a database on localhost (
127.0.0.1). The Host needs to be a publicly accessible address. - Type in the Database name.
- Type in the database Username and Password
- Click . If successful, skip to running a query.
Having trouble connecting to your database?
Please run through the checklist for preparing your database for connecting to Geckoboard.
Troubleshoot common database connection issues
How do I know if my database is accessible online?
To check if your database is accessible online, run the following command on a computer that’s not logged into your VPN or private network. Replace your_db_host and your_db_port with the host and port of your database:
- Linux or OSX:
nc -v your_db_host your_db_port - Windows:
telnet your_db_host your_db_port
If the connection succeeds, your database is accessible online. If it fails, it likely isn’t.
Database connection failed. The permission level of the database user is too high
If you see this error, you are likely connecting with a superuser such as "root". Instead, you should connect using a "read only" user.
Database connection failed. We’re having trouble verifying your connection. Please re-check your details.
This is a generic error, but if you have verified that all connection details provided are correct, it is possible that you are trying to connect an unsupported version of the database. For example, trying to connect a MySQL database that runs on version 5.5.
We currently support MySQL versions 5.6, 5.7, and 8.0.13, PostgreSQL versions 11.1, 10.6, 9.6, 9.5, and 9.4 and the latest version of Redshift.