Install TNG on a Synology NAS

[steven]

The instructions recommend using a Unix socket for added security. This requires a direct local domain connection so you cannot use the socket with a DDNS host such as Synology.me. I will update the instructions this week to add more information about this as well as updating the permission settings. The original post is the result of trial and error testing over years and I did not make using a domain socket connection clear in the instructions.

Connecting to the MariaDB database with a DDNS host, such as Synology.me, requires using TCP/IP instead of the Domain Socket. To enable TCP/IP connections, login to DSM > open packages > open MariaDB and check the Enable the TCP/IP connection and note the port number and click Apply. The default port is normally 3306, unless it has been changed.

Then go to the DSM control panel and open Security > then the Firewall tab. Under the Firewall Profile select Edit Rules.
Check to see if a rule for MariaDB exists and if it does not select Create. Click the Select from a list of built-in application radio button and then click Select. Scroll down to MariaDB10 and click the checkbox and click OK. Then click OK again on the next window and click OK on the last window. Last click Apply to ensure the settings were saved. This procedure will allow connecting through the NAS firewall.

Return to the TNG install page and enter the port number and leave the socket blank. This will enable remote connections to allow connecting through a DDNS host. This should resolve your connection problem.

[harrieklomp]

Thank you Steven,

For now this is not the solution that works.
I wait for your updated instructions and give it a new try from start.

[steven]

I updated the instructions for the database connection and permissions. If you are using a domain from Synology you will be not able to connect using the database socket as that connection only works locally and not over a DDNS host connection. Once you enable TCP/IP on MariaDB and permit access through the NAS firewall, you should be able to connect unless you have a typo somewhere.