Member Avatar for manor

Hello all,

Here is my problem in detail,

I have to get data from remote server to local server. currently i am working on local server trying to connect to the remote server through php script. but rempte server is blocked due to security reasons.

I am the admin for the database in remote server and admin in local server too. But I could not unblock the firewall.

I am asked to make a hole to the remote server so that I can pull the data from it through my local machine.

I tried possible stuff like
1) Add a port in remote machine to give access to local server to fecth. ( group policy denied)
2) I tried
netsh firewall set icmpsetting type =All mode =Enable in remote server command prompt and the reply was ok.
but i tried to connect there is no effect

PS. Remoter server is windows machine
local server is linux machine

any help is appreciated

Thanks
manor

  • 3 Contributors
  • 3 Replies
  • 263 Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by Binod Suri

Dani AI

Generated

A short, practical checklist to finish this work and avoid chasing the wrong layer.

First, identify which layer is blocking traffic (host firewall, domain Group Policy, perimeter/NAT, or the database itself). already tried a local change that had no effect and correctly pointed out DB admin rights often don’t include GPO changes — that strongly suggests a Group Policy or network perimeter rule is in force rather than a simple local setting.

If you have admin access on the Windows box, verify the service and ports are actually listening and see the applied policy:

netstat -an | find "LISTENING"
gpresult /r

From the Linux machine test reachability (replace host/port as needed):

telnet remote-host 3306
# or
nc -zv remote-host 3306

Also confirm the DB is configured to accept remote connections (MySQL’s bind-address, SQL Server’s TCP/IP setting, etc.). If file sharing is the problem for , check that the Server service is running and that SMB/NetBIOS ports (137–139, 445) or “File and Printer Sharing” exceptions are allowed.

If you cannot change GPO or the perimeter firewall, prepare a minimal ticket for the network/GPO team. Include exact source IP(s), destination server name/IP, port(s), protocol, business justification, and required time window. Example text to send:

Please allow inbound TCP port <port> to <server-IP> from <source-IP/range> (only this IP range). Purpose: secure data pull by <team/app>. Please restrict to stated source IPs and log connections.

If opening an inbound DB port is not allowed or safe, use a secure alternative: VPN between sites, an outbound push from the Windows server (SFTP/HTTPS), or an SSH reverse tunnel/VPN so the Windows host initiates the connection. Finally, note Windows Server 2003 is end-of-life and exposing services on it is high risk — upgrade or isolate that host where possible.

Recommended Answers

All 3 Replies

Member Avatar for tspraveena

Hi,
Is there any open port in the remote machine?
If you are not having any open ports, you are supposed to change the firewall settings.
Nothing can be done in php if didnt have any open ports for this.
You will not have permissions as db administrator to change group permissions (even for firewall). Only the group administrator can do this.

Regards,
Praveen


Hello all,

Here is my problem in detail,

I have to get data from remote server to local server. currently i am working on local server trying to connect to the remote server through php script. but rempte server is blocked due to security reasons.

I am the admin for the database in remote server and admin in local server too. But I could not unblock the firewall.

I am asked to make a hole to the remote server so that I can pull the data from it through my local machine.

I tried possible stuff like
1) Add a port in remote machine to give access to local server to fecth. ( group policy denied)
2) I tried
netsh firewall set icmpsetting type =All mode =Enable in remote server command prompt and the reply was ok.
but i tried to connect there is no effect

PS. Remoter server is windows machine
local server is linux machine

any help is appreciated

Thanks
manor

Member Avatar for manor

Thanks so much.
I spoke to network techi guys at my school..
they said they will contact me and open the port for me so that i can access data..
I appreciate ur help


Manor

Member Avatar for Binod Suri

Hi,

My problem is when i go to ping server in my client system msg display request time out but i ping from my server all client reply but i can't access my server file in client i disable my ip sec remote & routing access but my problem is not solve pls reply me as soon as possible .

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.