all ports blocked on XP

P

Phil M

Hi all. I'm trying to open up port 3306 in order to allow traffic in
mySQL 5.0 server but my Windows XP SP2 machine refuses. I also
installed uTorrent 1.6 and configured it to listen to port 60030, same
problem: Ports are closed!

I uninstalled McAfee anti-virus, disabled Zone Alarm 6.5, plugged the
Internet cable directly to the winXP box bypassing the LinkSys BEFSR41
v2 router (although I previously forwarded ports 3306 and 60030 to
this local machine's IP which is 192.168.1.100): Ports Closed!

I completely disabled the built-in XP firewall by stopping the
service: Ports Closed

On my other machine, a win2k, both programs can listen to ports 3306
and 60030 respectively, therefore, my ISP isn't blocking them.

What can possibly close the ports on my winXP box? It's not the
router, it's not the firewall, it's not the ISP, what is? Is there any
software which will allow me to detect which application/service is
blocking my ports and force them open?

Thanks for any suggestions.
 
T

TheSailingNut

To make sure we understand correctly, are you using your XP machine to
connect to a MySQL server on a different network segment, or is the
MySQL server running on your XP box while other machines are trying to
connect to it?

Brian Crittenden, MS
 
T

TheSailingNut

Piggybacking on my previous post, if the MySQL server is running on
your XP box and other machines are trying to connect to it, what is
showing for port 3306 when you run "netstat -b"?

If the MySQL server is running somewhere else, what response do you
get when you try and telnet from the XP machine to port 3306 on the
MySQL server?

Please advise.


Brian Crittenden, MS
 
P

Phil M

is the MySQL server running on your XP box while other
machines are trying to connect to it?

Thank you for the quick reply.

The MySQL server is running on my XP box while other machines are
trying to connect to. But can't because ports are closed.

netstat -b gives this:


Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\>netstat -b

Active Connections

Proto Local Address Foreign Address State PID
TCP amd:1032 localhost:2190 ESTABLISHED 356
[isafe.exe]

TCP amd:1033 localhost:2191 ESTABLISHED 356
[isafe.exe]

TCP amd:2190 localhost:1032 ESTABLISHED 256
[vsmon.exe]

TCP amd:2191 localhost:1033 ESTABLISHED 256
[vsmon.exe]

TCP amd:2299 localhost:3306 ESTABLISHED
1936
[SAMBC.exe]

TCP amd:2301 localhost:3306 ESTABLISHED
1936
[SAMBC.exe]

TCP amd:2303 localhost:3306 ESTABLISHED
1936
[SAMBC.exe]

TCP amd:2304 localhost:3306 ESTABLISHED
1936
[SAMBC.exe]

TCP amd:2316 localhost:3306 ESTABLISHED
1936
[SAMBC.exe]

TCP amd:3306 localhost:2303 ESTABLISHED 768
[mysqld-nt.exe]

TCP amd:3306 localhost:2316 ESTABLISHED 768
[mysqld-nt.exe]

TCP amd:3306 localhost:2304 ESTABLISHED 768
[mysqld-nt.exe]

TCP amd:3306 localhost:2299 ESTABLISHED 768
[mysqld-nt.exe]

TCP amd:3306 localhost:2301 ESTABLISHED 768
[mysqld-nt.exe]

TCP amd:2189 206.167.78.23:http ESTABLISHED 256
[vsmon.exe]

TCP amd:2302 192.168.1.101:netbios-ssn ESTABLISHED
4
[System]

TCP amd:1025 localhost:2319 TIME_WAIT 0
TCP amd:1025 localhost:2328 TIME_WAIT 0
TCP amd:2309 localhost:2308 TIME_WAIT 0
TCP amd:2324 localhost:2323 TIME_WAIT 0
TCP amd:2295 free.teranews.com:nntp TIME_WAIT 0
TCP amd:2317 po-in-f91.google.com:http TIME_WAIT 0
TCP amd:2321 utorrent.com:http TIME_WAIT 0
TCP amd:2327 utorrent.com:http TIME_WAIT 0

C:\>

Thanks again!
 
S

smlunatick

is the MySQL server running on your XP box while other
machines are trying to connect to it?

Thank you for the quick reply.

The MySQL server is running on my XP box while other machines are
trying to connect to. But can't because ports are closed.

netstat -b gives this:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\>netstat -b

Active Connections

Proto Local Address Foreign Address State PID
TCP amd:1032 localhost:2190 ESTABLISHED 356
[isafe.exe]

TCP amd:1033 localhost:2191 ESTABLISHED 356
[isafe.exe]

TCP amd:2190 localhost:1032 ESTABLISHED 256
[vsmon.exe]

TCP amd:2191 localhost:1033 ESTABLISHED 256
[vsmon.exe]

TCP amd:2299 localhost:3306 ESTABLISHED
1936
[SAMBC.exe]

TCP amd:2301 localhost:3306 ESTABLISHED
1936
[SAMBC.exe]

TCP amd:2303 localhost:3306 ESTABLISHED
1936
[SAMBC.exe]

TCP amd:2304 localhost:3306 ESTABLISHED
1936
[SAMBC.exe]

TCP amd:2316 localhost:3306 ESTABLISHED
1936
[SAMBC.exe]

TCP amd:3306 localhost:2303 ESTABLISHED 768
[mysqld-nt.exe]

TCP amd:3306 localhost:2316 ESTABLISHED 768
[mysqld-nt.exe]

TCP amd:3306 localhost:2304 ESTABLISHED 768
[mysqld-nt.exe]

TCP amd:3306 localhost:2299 ESTABLISHED 768
[mysqld-nt.exe]

TCP amd:3306 localhost:2301 ESTABLISHED 768
[mysqld-nt.exe]

TCP amd:2189 206.167.78.23:http ESTABLISHED 256
[vsmon.exe]

TCP amd:2302 192.168.1.101:netbios-ssn ESTABLISHED
4
[System]

TCP amd:1025 localhost:2319 TIME_WAIT 0
TCP amd:1025 localhost:2328 TIME_WAIT 0
TCP amd:2309 localhost:2308 TIME_WAIT 0
TCP amd:2324 localhost:2323 TIME_WAIT 0
TCP amd:2295 free.teranews.com:nntp TIME_WAIT 0
TCP amd:2317 po-in-f91.google.com:http TIME_WAIT 0
TCP amd:2321 utorrent.com:http TIME_WAIT 0
TCP amd:2327 utorrent.com:http TIME_WAIT 0

C:\>

Thanks again!

Check the WIndows XP firewall settings (Control Panel) and "disable"
the firewal so as to test. If the SQL server can be access, the you
will need to add the SQL files/settings into the Exception list of the
Windows firewall.

NOTE: The answer was assuming that you are only using Windows XP
firewall. Consult with the makers of the firewall/anti-virus system
that you are using.
 
P

Phil M

NOTE: The answer was assuming that you are only using Windows XP
firewall.

Thanks for the reply. As I said in my initial message, I completely
disabled ICF Windows built-in firewall by completely stopping the
service. Via the router, I forwarded the ports to the local machine. I
don't really know what can cause this.
 
S

smlunatick

Thanks for the reply. As I said in my initial message, I completely
disabled ICF Windows built-in firewall by completely stopping the
service. Via the router, I forwarded the ports to the local machine. I
don't really know what can cause this.

It looks like McAfee/Zone Alarm may not have "cleanly" removed all the
settings off your PC.
 
P

Phil M

After some extensive Googling on the subject, I downloaded a utility
called VB WinSock Fix 1.2 and took care of the problem. I regained
the ports! Apparently the problem was some degree of corruption with
the registry. Thanks all!.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top