Troubleshoot SQL database connections

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, speak 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.

Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

Ready to create your own dashboard?

Get started for free

Still have questions? Get in touch.