Page 2 of 2

Re: Proplem in local host

PostPosted: 09. September 2009 03:08
by lordgzar
Wiedmann wrote:
The MySQL server is not running or is blocked by a firewall! UNKNOWN

You should check your firewall settings...


i dont open my firewall

Re: Proplem in local host

PostPosted: 09. September 2009 03:47
by Wiedmann
its already closed

Then you have to check your second firewall...

Re: Proplem in local host

PostPosted: 09. September 2009 03:50
by lordgzar
no have another

Re: Proplem in local host

PostPosted: 09. September 2009 04:05
by Wiedmann
no have another

Well, what else can block all connections to the IP 127.0.0.1?

Re: Proplem in local host

PostPosted: 09. September 2009 04:08
by lordgzar
dont know i need help from u please i want to opn mysql alot

Re: Proplem in local host

PostPosted: 09. September 2009 04:42
by Wiedmann
Just for interest. What output did you have with:
Code: Select all
netstat -a -n | find "TCP"

Re: Proplem in local host

PostPosted: 09. September 2009 07:52
by lordgzar
then i do as u said and the result was:

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

    C:\Documents and Settings\Administrator>netstat -n

    Active Connections

    Proto Local Address Foreign Address State
    TCP 10.0.0.157:80 10.0.0.157:1131 TIME_WAIT
    TCP 10.0.0.157:80 10.0.0.157:1133 TIME_WAIT
    TCP 10.0.0.157:80 10.0.0.157:1135 TIME_WAIT
    TCP 10.0.0.157:1051 65.54.189.180:1863 ESTABLISHED
    TCP 10.0.0.157:1081 217.53.170.30:1714 ESTABLISHED
    TCP 10.0.0.157:1088 69.63.180.15:80 TIME_WAIT
    TCP 10.0.0.157:1089 79.140.80.48:80 TIME_WAIT
    TCP 10.0.0.157:1091 79.140.80.35:80 TIME_WAIT
    TCP 10.0.0.157:1093 69.63.186.30:80 ESTABLISHED
    TCP 10.0.0.157:1095 79.140.80.48:80 TIME_WAIT
    TCP 10.0.0.157:1096 79.140.80.48:80 TIME_WAIT
    TCP 10.0.0.157:1102 91.203.99.45:443 TIME_WAIT
    TCP 10.0.0.157:1103 69.63.180.174:443 TIME_WAIT
    TCP 10.0.0.157:1105 216.191.247.209:80 TIME_WAIT
    TCP 10.0.0.157:1108 213.248.125.74:80 TIME_WAIT
    TCP 10.0.0.157:1112 213.248.125.33:80 TIME_WAIT
    TCP 10.0.0.157:1114 79.140.80.83:80 ESTABLISHED
    TCP 10.0.0.157:1115 80.15.233.27:80 ESTABLISHED
    TCP 10.0.0.157:1117 80.15.233.27:80 ESTABLISHED
    TCP 10.0.0.157:1118 80.15.233.27:80 ESTABLISHED
    TCP 10.0.0.157:1119 213.248.125.98:80 ESTABLISHED
    TCP 10.0.0.157:1121 213.248.125.8:80 ESTABLISHED
    TCP 10.0.0.157:1122 213.248.125.96:80 ESTABLISHED
    TCP 10.0.0.157:1123 213.248.125.96:80 ESTABLISHED
    TCP 10.0.0.157:1127 213.248.125.10:80 ESTABLISHED
    TCP 10.0.0.157:1130 91.203.99.45:80 FIN_WAIT_1
    TCP 10.0.0.157:1134 10.0.0.157:80 TIME_WAIT
    TCP 10.0.0.157:1139 69.63.176.193:80 ESTABLISHED
    TCP 10.0.0.157:1147 188.40.45.85:80 TIME_WAIT
    TCP 10.0.0.157:1148 188.40.45.85:80 ESTABLISHED
    TCP 10.0.0.157:1150 188.40.45.85:80 ESTABLISHED
    TCP 10.0.0.157:1151 188.40.45.85:80 ESTABLISHED

    C:\Documents and Settings\Administrator>netstat -a

    Active Connections

    Proto Local Address Foreign Address State
    TCP GAZAR:http GAZAR:0 LISTENING
    TCP GAZAR:epmap GAZAR:0 LISTENING
    TCP GAZAR:https GAZAR:0 LISTENING
    TCP GAZAR:microsoft-ds GAZAR:0 LISTENING
    TCP GAZAR:3306 GAZAR:0 LISTENING
    TCP GAZAR:http GAZAR:1131 TIME_WAIT
    TCP GAZAR:http GAZAR:1133 TIME_WAIT
    TCP GAZAR:http GAZAR:1135 TIME_WAIT
    TCP GAZAR:netbios-ssn GAZAR:0 LISTENING
    TCP GAZAR:1051 by2msg1020318.gateway.edge.messenger.live.com:18
    63 ESTABLISHED
    TCP GAZAR:1081 host.217.53.170.30.nile-online.net:1714 ESTABLI
    SHED
    TCP GAZAR:1091 79.140.80.35:http TIME_WAIT
    TCP GAZAR:1093 www.12.06.ash1.facebook.com:http ESTABLISHED
    TCP GAZAR:1096 79.140.80.48:http TIME_WAIT
    TCP GAZAR:1102 f99-045.opera-mini.net:https TIME_WAIT
    TCP GAZAR:1103 login.11.07.snc1.facebook.com:https TIME_WAIT
    TCP GAZAR:1105 crl.entrust.net:http TIME_WAIT
    TCP GAZAR:1108 213-248-125-74.customer.teliacarrier.com:http T
    IME_WAIT
    TCP GAZAR:1112 213-248-125-33.customer.teliacarrier.com:http T
    IME_WAIT
    TCP GAZAR:1114 79.140.80.83:http ESTABLISHED
    TCP GAZAR:1115 80.15.233.27:http ESTABLISHED
    TCP GAZAR:1117 80.15.233.27:http ESTABLISHED
    TCP GAZAR:1118 80.15.233.27:http ESTABLISHED
    TCP GAZAR:1119 213-248-125-98.customer.teliacarrier.com:http T
    IME_WAIT
    TCP GAZAR:1121 213-248-125-8.customer.teliacarrier.com:http TI
    ME_WAIT
    TCP GAZAR:1122 213-248-125-96.customer.teliacarrier.com:http T
    IME_WAIT
    TCP GAZAR:1123 213-248-125-96.customer.teliacarrier.com:http T
    IME_WAIT
    TCP GAZAR:1127 213-248-125-10.customer.teliacarrier.com:http E
    STABLISHED
    TCP GAZAR:1130 f99-045.opera-mini.net:http FIN_WAIT_1
    TCP GAZAR:1134 GAZAR:http TIME_WAIT
    TCP GAZAR:1147 chiba.apachefriends.org:http TIME_WAIT
    TCP GAZAR:1153 channel33.01.05.sf2p.facebook.com:http ESTABLIS
    HED
    TCP GAZAR:1028 GAZAR:0 LISTENING
    TCP GAZAR:1066 GAZAR:0 LISTENING
    TCP GAZAR:5152 GAZAR:0 LISTENING
    UDP GAZAR:microsoft-ds *:*
    UDP GAZAR:isakmp *:*
    UDP GAZAR:1048 *:*
    UDP GAZAR:1052 *:*
    UDP GAZAR:1107 *:*
    UDP GAZAR:4500 *:*
    UDP GAZAR:discard *:*
    UDP GAZAR:ntp *:*
    UDP GAZAR:netbios-ns *:*
    UDP GAZAR:netbios-dgm *:*
    UDP GAZAR:ntp *:*
    UDP GAZAR:1047 *:*
    UDP GAZAR:1064 *:*
    UDP GAZAR:1900 *:*

    C:\Documents and Settings\Administrator>

Re: Proplem in local host

PostPosted: 09. September 2009 08:38
by lordgzar
Wiedmann wrote:Just for interest. What output did you have with:
Code: Select all
netstat -a -n | find "TCP"

iam not professionla on this but i think that apache is leastin to another ip not same as MySQL
so give me away to change the apaceh Ip so we can try or to change MySQL Ip

Re: Proplem in local host

PostPosted: 09. September 2009 08:44
by Wiedmann
then i do as u said and the result was:

No. Please use exact the command I have written...

Re: Proplem in local host

PostPosted: 09. September 2009 09:12
by lordgzar
Wiedmann wrote:
then i do as u said and the result was:

No. Please use exact the command I have written...


done and the result was :
[list=]Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>netstat -a -n

Active Connections

Proto Local Address Foreign Address State
TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:443 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING
TCP 10.0.0.157:139 0.0.0.0:0 LISTENING
TCP 10.0.0.157:1051 65.54.189.180:1863 ESTABLISHED
TCP 10.0.0.157:1463 41.196.250.118:58429 ESTABLISHED
TCP 10.0.0.157:1514 41.232.92.78:1213 ESTABLISHED
TCP 10.0.0.157:1858 65.54.189.166:1863 ESTABLISHED
TCP 10.0.0.157:1959 69.63.180.15:80 TIME_WAIT
TCP 10.0.0.157:1963 65.54.189.31:1863 ESTABLISHED
TCP 10.0.0.157:1967 188.40.45.85:80 TIME_WAIT
TCP 10.0.0.157:1969 188.40.45.85:80 TIME_WAIT
TCP 10.0.0.157:1970 69.63.176.193:80 ESTABLISHED
TCP 127.0.0.1:1028 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1066 0.0.0.0:0 LISTENING
TCP 127.0.0.1:5152 0.0.0.0:0 LISTENING
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:1048 *:*
UDP 0.0.0.0:1052 *:*
UDP 0.0.0.0:1107 *:*
UDP 0.0.0.0:1171 *:*
UDP 0.0.0.0:1464 *:*
UDP 0.0.0.0:4500 *:*
UDP 10.0.0.157:9 *:*
UDP 10.0.0.157:123 *:*
UDP 10.0.0.157:137 *:*
UDP 10.0.0.157:138 *:*
UDP 10.0.0.157:47655 *:*
UDP 127.0.0.1:123 *:*
UDP 127.0.0.1:1047 *:*
UDP 127.0.0.1:1064 *:*
UDP 127.0.0.1:1900 *:*

C:\Documents and Settings\Administrator>[/list]

Re: Proplem in local host

PostPosted: 09. September 2009 09:29
by Wiedmann
Code: Select all
netstat -a -n

That's not the command I have written...

But ok, with this output it's still clear that a firewall is blocking the connections. Now it's up to you to configure this firewall in a correct way.

Re: Proplem in local host

PostPosted: 09. September 2009 09:31
by lordgzar
can u tell me how to configure the firewall of the windows?but iam sure it's closed