Problem: Cannot connect remotely mysql or postgresql
Solution:
Allow ports 3306 for mysql or 5432 for pgs.
Go to /etc/mysql/mariadb.conf.d/50-server.cnf and change bind-address = 0.0.0.0. Restart mysql pr maria actually.
Go to hestiacp postgresql configuration part. Go and change listen_addresses = ‘*’, remove comment. Restart psg.
Done.