MariaDB: 'database connection failed' | Geckoboard Help Center
MariaDB: 'database connection failed'
Steps to avoid running into a Database connection failed error.
June 20, 2022
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 accepts connections from these Geckoboard IP addresses:
23.23.205.14050.16.244.1654.204.39.9654.243.225.10154.243.235.13654.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
SELECTqueries, but for extra security, we only accept connections from users that have read-only access to the DB.