- Plesk Onyx for Linux
- Plesk Onyx for Windows
Upon the attempt to register database server in Tools & Settings > Database Servers, the following error is displayed:
PLESK_ERROR: Error: The test connection to the database server has failed because of network problems:
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host failed to respond.
On database server
# systemctl | grep firewall
firewalld.service loaded active running firewalld - dynamic firewal daemon
# systemctl | grep tables
The connection is blocked by a firewall.
Connect to the remote database server via SSH and add a firewall rule ta allow connections from Plesk server:
# firewall-cmd --add-rich-rule='rule family="ipv4" source address="203.0.113.2/32" port protocol="tcp" port="3306" accept'
# firewall-cmd --permanent --add-rich-rule='rule family="ipv4" source address="203.0.113.2/32" port protocol="tcp" port="3306" accept'
Where "203.0.113.2" is IP address of Plesk server, "3306" - port, on which MySQL is running.