Resolved Plesk connect to remote server, port closed

[Jack Lee]

Trying to open port 3306 for MYSQL remote access.

Similar to this: Resolved - Cannot connect to database remote
but on our server the firewall is not running.

Centos 7
systemctl status firewalld
? firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
Active: inactive (dead)



telnet esaproductmanager.com 3306
Trying 74.208.165.208...
telnet: connect to address 74.208.165.208: Connection timed out


my.cnf
bind-address = ::

Any suggestions? Thanks in advance.

 

[IgorG]

What if you change

bind-address = ::

to

bind-address = 74.208.165.208

where 74.208.165.208 is IP address of your esaproductmanager.com domain?

 

[Jack Lee]

74.208.165.208 is the main server....

74.208.247.65 is the remote server. I don't have anything setup on it. Just trying to connect to 74.208.165.208

I tried your suggestion, but it didn't work.

 

[IgorG]

I see that port 3306 is filtered:

# nmap -p3306 esaproductmanager.com

Starting Nmap 6.40 ( Nmap: the Network Mapper - Free Security Scanner ) at 2017-09-05 11:06 NOVT
Nmap scan report for esaproductmanager.com (74.208.165.208)
Host is up (0.19s latency).
PORT STATE SERVICE
3306/tcp filtered mysql

I would suggest you check your network infrastructure. Maybe it is filtered on some kind of routers, service providers, etc?

 

[Jack Lee]

Thank you...the firewall rules at the service provider were the issue. I added an exception and viola, it works. You are the man Igor!