Having started using Ignition at work I wanted to utilize my new found skills at home with a home automation setup on my Synology NAS using Ignition Maker.
Unfortunately I’m having trouble connecting Ignition to MariaDB 10 (both are installed on a Synology NAS). MariaDB is a Synology package and Ignition is in a Docker container. I’m able to access the database via phpMyAdmin (also a Synology package) but the database connection in Ignition is throwing an error.
I’ve tried resetting MariaDB’s password and granting full access to the user (‘root’ in this case).
Any help would be appreciated.
Cannot create PoolableConnectionFactory (Could not connect to address=(host=localhost)(port=3306)(type=master) : Socket fail to connect to host:localhost, port:3306. Connection refused (Connection refused))
Ignition DB settings: