All Collections
Connect your databases
MariaDB: 'database connection failed'
MariaDB: 'database connection failed'

Steps to avoid running into a Database connection failed error.

Updated over a week ago

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.

Did this answer your question?