If you're having trouble connecting your SQL database to Geckoboard, start by running through our checklist for preparing your database. If you're still having issues, and can't see your issue listed here, chat with our Customer Success team.
The permission level of the database user is too high
If you see the error The permission level of the database user is too high
, you're likely connecting with a superuser such as "root". Instead, you should connect using a "read only" user.
We’re having trouble verifying your connection. Please re-check your details.
If you see the generic error We’re having trouble verifying your connection. Please re-check your details
, and you have double checked your details, it's possible you're 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 versions of Redshift and Microsoft SQL server.
Database host timeout
If we do not receive a response from your database host within 3 seconds, you'll see an error. This can happen if the host is under heavy load, if IP restrictions are not configured correctly, or if there's non-existent host on that port.
Disconnections when handling large numbers of Databases widgets
Be mindful of creating too many Databases widgets. Your SQL database may disconnect if you exceed approx. 200 widgets.