You have ten half-open connections (in SYN_SENT state), and a new connection attempt is
giving you error 10055 which is windows' way of saying it can't allocate a buffer for a
new connection. Are you running XP SP2 or SP3 or Vista? Microsoft introduced a throttle
on in these versions, if more than ten are in the process of handshaking (e.g. SYN_SENT
state). In theory this is to limit SYN floods and other connection attacks. To confirm
if this is your problem, check your windows event viewer for system events with event id
4226: "TCP/IP has reached the security limit"
Your ten handshaking connections are all to port 445 ... which is microsoft-ds
(aka Active Directory). If the above matches your scenario, shut down whatever
services/apps are doing this on the box, and MySQL will be able to give you a
connection.
Ciao
Fuzzy
:-)
------------------------------------------------
Dazed and confused about technology for 20 years
http://fuzzydata.wordpress.com/
BAJAJ POOJA wrote:
Hi,
Pls. find response below:
C:\wamp\mysql\bin>netstat -an
Active Connections
Proto Local Address Foreign Address State
TCP 0.0.0.0:25 0.0.0.0:0 LISTENING
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:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:2701 0.0.0.0:0 LISTENING
TCP 0.0.0.0:2702 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING
TCP 0.0.0.0:8081 0.0.0.0:0 LISTENING
TCP 0.0.0.0:13468 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1074 0.0.0.0:0 LISTENING
TCP 172.21.138.200:139 0.0.0.0:0 LISTENING
TCP 172.21.138.200:1074 172.21.136.21:139 TIME_WAIT
TCP 172.21.138.200:3389 172.21.138.11:2590 ESTABLISHED
TCP 172.21.138.200:4534 172.21.136.21:135 TIME_WAIT
TCP 172.21.138.200:4535 172.21.136.21:1026 TIME_WAIT
TCP 172.21.138.200:4537 172.21.136.21:135 TIME_WAIT
TCP 172.21.138.200:4538 172.21.136.21:389 TIME_WAIT
TCP 172.21.138.200:4575 172.21.13.139:445 SYN_SENT
TCP 172.21.138.200:4576 172.21.13.140:445 SYN_SENT
TCP 172.21.138.200:4577 172.21.13.141:445 SYN_SENT
TCP 172.21.138.200:4578 172.21.13.142:445 SYN_SENT
TCP 172.21.138.200:4579 172.21.13.143:445 SYN_SENT
TCP 172.21.138.200:4580 172.21.13.144:445 SYN_SENT
TCP 172.21.138.200:4581 172.21.13.145:445 SYN_SENT
TCP 172.21.138.200:4582 172.21.13.146:445 SYN_SENT
TCP 172.21.138.200:4583 172.21.13.147:445 SYN_SENT
TCP 172.21.138.200:4584 172.21.13.148:445 SYN_SENT
UDP 0.0.0.0:69 *:*
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:1025 *:*
UDP 0.0.0.0:1026 *:*
UDP 0.0.0.0:1221 *:*
UDP 0.0.0.0:4500 *:*
UDP 0.0.0.0:8081 *:*
UDP 0.0.0.0:8082 *:*
UDP 127.0.0.1:123 *:*
UDP 127.0.0.1:1900 *:*
UDP 127.0.0.1:4542 *:*
UDP 172.21.138.200:123 *:*
UDP 172.21.138.200:137 *:*
UDP 172.21.138.200:138 *:*
UDP 172.21.138.200:1900 *:*
C:\wamp\mysql\bin>mysql -u root -p
Enter password: *****
ERROR 2003: Can't connect to MySQL server on 'localhost' (10055)
C:\wamp\mysql\bin>mysql -u root -p
Enter password:
ERROR 2003: Can't connect to MySQL server on 'localhost' (10055)
--
Thanks & Regards
Pooja Bajaj
Alcatel-Lucent, India
Email:pooja.ba...@alcatel-lucent.com
Phone:+124-413-3078 | Onnet: 2721-3078
________________________________
From: Chandru [mailto:chandru....@gmail.com]
Sent: 12 December 2008 13:40
To: BAJAJ POOJA
Cc: chaim.rie...@gmail.com; mysql@lists.mysql.com
Subject: Re: MYSQL startup problem
Hi,
I think you may have to get me the output of netstat -an (this only
tells the ports that are all listening). sorry for the confusion.
can you connect using "mysql -u root -p" and also using "mysql -u root
-p -h 127.0.0.1"
one thing that i find here is that you have missed the "-p" option which
prompts for password.
Regards,
Chandru
www.mafiree.com
On Fri, Dec 12, 2008 at 1:39 PM, BAJAJ POOJA
<pooja.ba...@alcatel-lucent.com> wrote:
Hi,
Pls. Find response below:
C:\wamp\mysql\bin>Mysql -h localhost -u root
ERROR 2003: Can't connect to MySQL server on 'localhost' (10055)
--
Thanks & Regards
Pooja Bajaj
Alcatel-Lucent, India
Email:pooja.ba...@alcatel-lucent.com
<mailto:email%3apooja.ba...@alcatel-lucent.com>
Phone:+124-413-3078 | Onnet: 2721-3078
-----Original Message-----
From: chaim.rie...@gmail.com [mailto:chaim.rie...@gmail.com]
Sent: 12 December 2008 13:13
To: BAJAJ POOJA; Chandru
Cc: mysql@lists.mysql.com
Subject: Re: MYSQL startup problem
When you do the following
Mysql -h localhost -u root.
What do you get ?
Sent via BlackBerry from T-Mobile
-----Original Message-----
From: "BAJAJ POOJA" <pooja.ba...@alcatel-lucent.com>
Date: Fri, 12 Dec 2008 08:43:45
To: <chaim.rie...@gmail.com>; Chandru<chandru....@gmail.com>
Cc: <mysql@lists.mysql.com>
Subject: RE: MYSQL startup problem
Hi,
It doesn't allows me to telnet port 3306.
If I ping that port I receive Request timed out.
--
Thanks & Regards
Pooja Bajaj
Alcatel-Lucent, India
Email:pooja.ba...@alcatel-lucent.com
<mailto:email%3apooja.ba...@alcatel-lucent.com>
Phone:+124-413-3078 | Onnet: 2721-3078
-----Original Message-----
From: chaim.rie...@gmail.com [mailto:chaim.rie...@gmail.com]
Sent: 12 December 2008 13:02
To: BAJAJ POOJA; Chandru
Cc: mysql@lists.mysql.com
Subject: Re: MYSQL startup problem
It says that is started mysql
Can you telnet to port 3306 ?
Sent via BlackBerry from T-Mobile
-----Original Message-----
From: "BAJAJ POOJA" <pooja.ba...@alcatel-lucent.com>
Date: Fri, 12 Dec 2008 08:27:02
To: Chandru<chandru....@gmail.com>
Cc: <mysql@lists.mysql.com>
Subject: RE: MYSQL startup problem
Hi,
Pls find logs attached below in mail:
080605 15:28:08 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
080606 9:32:18 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
080606 9:32:18 InnoDB: Starting shutdown...
080606 9:32:21 InnoDB: Shutdown completed
080606 9:32:21 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
080606 9:30:58 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
080606 11:43:53 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
080606 11:43:53 InnoDB: Starting shutdown...
080606 11:43:54 InnoDB: Shutdown completed
080606 11:43:54 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
080606 11:43:55 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
080609 9:29:04 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
080609 10:14:40 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
080609 10:14:40 InnoDB: Starting shutdown...
080609 10:14:41 InnoDB: Shutdown completed
080609 10:14:41 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
080609 10:26:27 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
080609 16:45:52 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
080609 16:45:52 InnoDB: Starting shutdown...
080609 16:45:54 InnoDB: Shutdown completed
080609 16:45:54 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
080609 17:01:50 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
080610 11:05:35 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
080610 11:05:35 InnoDB: Starting shutdown...
080610 11:05:36 InnoDB: Shutdown completed
080610 11:05:36 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
080610 11:11:23 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
080613 17:28:21 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
080613 17:28:21 InnoDB: Starting shutdown...
080613 17:28:24 InnoDB: Shutdown completed
080613 17:28:24 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
080616 11:28:22 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
080701 11:10:31 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
080701 11:10:31 InnoDB: Starting shutdown...
080701 11:10:33 InnoDB: Shutdown completed
080701 11:10:33 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
080701 11:12:34 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
080701 11:15:12 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
080701 11:15:12 InnoDB: Starting shutdown...
080701 11:15:13 InnoDB: Shutdown completed
080701 11:15:13 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
080701 11:16:01 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
080818 16:40:28 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
081211 13:10:16 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
081211 13:10:16 InnoDB: Starting shutdown...
081211 13:10:17 InnoDB: Shutdown completed
081211 13:10:17 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
081211 13:10:18 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
081111 13:13:43 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
081111 13:13:43 InnoDB: Starting shutdown...
081111 13:13:44 InnoDB: Shutdown completed
081111 13:13:44 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
081111 13:13:59 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
081111 13:14:35 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
081111 13:14:35 InnoDB: Starting shutdown...
081111 13:14:36 InnoDB: Shutdown completed
081111 13:14:36 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
081111 13:14:36 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
081111 13:16:50 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
081111 13:16:50 InnoDB: Starting shutdown...
081111 13:16:52 InnoDB: Shutdown completed
081111 13:16:52 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
081111 13:17:30 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
081111 13:18:04 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
081111 13:18:04 InnoDB: Starting shutdown...
081111 13:18:04 InnoDB: Shutdown completed
081111 13:18:04 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
081111 13:19:09 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
081111 13:26:53 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
081111 13:26:53 InnoDB: Starting shutdown...
081111 13:26:55 InnoDB: Shutdown completed
081111 13:26:55 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
081111 13:26:55 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
081111 13:28:18 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
081111 13:28:18 InnoDB: Starting shutdown...
081111 13:28:20 InnoDB: Shutdown completed
081111 13:28:20 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
081111 13:28:20 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
081111 13:43:46 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
081111 13:43:46 InnoDB: Starting shutdown...
081111 13:43:49 InnoDB: Shutdown completed
081111 13:43:49 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
081111 13:44:55 InnoDB: Started
MySql: ready for connections.
Version: '4.0.18-nt' socket: '' port: 3306
081212 10:13:28 MySql: Normal shutdown
081212 10:13:28 InnoDB: Starting shutdown...
081212 10:13:29 InnoDB: Shutdown completed
081212 10:13:29 MySql: Shutdown Complete
081212 10:13:46 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
081212 10:14:45 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
081212 10:14:45 InnoDB: Starting shutdown...
081212 10:14:47 InnoDB: Shutdown completed
081212 10:14:47 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
081212 10:14:47 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
081212 10:31:10 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
081212 10:31:10 InnoDB: Starting shutdown...
081212 10:31:11 InnoDB: Shutdown completed
081212 10:31:11 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
081212 10:31:45 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
081212 11:14:06 c:\wamp\mysql\bin\mysqld-nt.exe: Normal
shutdown
081212 11:14:06 InnoDB: Starting shutdown...
081212 11:14:08 InnoDB: Shutdown completed
081212 11:14:08 c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown
Complete
081212 11:15:12 InnoDB: Started
MySql: ready for connections.
Version: '4.0.18-nt' socket: '' port: 3306
081212 11:16:17 MySql: Normal shutdown
081212 11:16:17 InnoDB: Starting shutdown...
081212 11:16:19 InnoDB: Shutdown completed
081212 11:16:19 MySql: Shutdown Complete
081212 11:16:48 InnoDB: Started
MySql: ready for connections.
Version: '4.0.18-nt' socket: '' port: 3306
080612 11:20:47 MySql: Normal shutdown
080612 11:20:47 InnoDB: Starting shutdown...
080612 11:20:49 InnoDB: Shutdown completed
080612 11:20:49 MySql: Shutdown Complete
080612 11:21:19 InnoDB: Started
MySql: ready for connections.
Version: '4.0.18-nt' socket: '' port: 3306
081212 11:43:44 InnoDB: Started
MySql: ready for connections.
Version: '4.0.18-nt' socket: '' port: 3306
--
Thanks & Regards
Pooja Bajaj
Alcatel-Lucent, India
Email:pooja.ba...@alcatel-lucent.com
<mailto:email%3apooja.ba...@alcatel-lucent.com>
Phone:+124-413-3078 | Onnet: 2721-3078
________________________________
From: Chandru [mailto:chandru....@gmail.com]
Sent: 12 December 2008 12:50
To: BAJAJ POOJA
Cc: mysql@lists.mysql.com
Subject: Re: MYSQL startup problem
Hi,
By default you can find them in the datadirectory ( the place
where you
have all your databases stored)
Regards,
Chandru
www.mafiree.com
On Fri, Dec 12, 2008 at 12:42 PM, BAJAJ POOJA
<pooja.ba...@alcatel-lucent.com> wrote:
Hi Chandru,
Can you pls. help where can i search for logs.
--
Thanks & Regards
Pooja Bajaj
Alcatel-Lucent, India
Email:pooja.ba...@alcatel-lucent.com
<mailto:email%3apooja.ba...@alcatel-lucent.com>
<mailto:email%3apooja.ba...@alcatel-lucent.com
<mailto:email%253apooja.ba...@alcatel-lucent.com> >
Phone:+124-413-3078 | Onnet: 2721-3078
________________________________
From: Chandru [mailto:chandru....@gmail.com]
Sent: 12 December 2008 11:58
To: BAJAJ POOJA
Cc: mysql@lists.mysql.com
Subject: Re: MYSQL startup problem
Hi,
can you please look at the mysql error logs? if you are
not
able to figure out the reason, please paste the error log.
Regards,
Chandru
www.mafiree.com
On Fri, Dec 12, 2008 at 11:52 AM, BAJAJ POOJA
<pooja.ba...@alcatel-lucent.com> wrote:
Hi,
I am using wamp server version 1.1.
When I try to start wamp server, It starts apache
only,
and does not
starts mysql service.
I tried to start mysql service independently,
even that
is not possible.
Pls. let me know if any solution available.
--
Thanks & Regards
Pooja Bajaj
Alcatel-Lucent, India
Email:pooja.ba...@alcatel-lucent.com
<mailto:email%3apooja.ba...@alcatel-lucent.com>
<mailto:email%3apooja.ba...@alcatel-lucent.com
<mailto:email%253apooja.ba...@alcatel-lucent.com> >
Phone:+124-413-3078 | Onnet: 2721-3078
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org