MariaDB: 'database connection failed'

If you're trying to connect a MariaDB database and receive a Database connection failed error, run through this checklist to prepare your database for connecting to Geckoboard:

  • Verify that your database is running correctly and is accessible online. You can run a check for this.
  • 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
  • Connections between Geckoboard and your database will be encrypted so your database must have TLS encryption enabled. For MariaDB TLS is disabled by default. Check if it's enabled by running the command SHOW VARIABLES LIKE '%ssl%';. Learn more about how to enable TLS for MariaDB.
  • Geckoboard only allows SELECT queries, but for extra security, we only accept connections from users that have read-only access to the DB.
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.