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.Bajaj@stripped
> Phone:+124-413-3078 | Onnet: 2721-3078
>
>
> ________________________________
>
> From: Chandru [mailto:chandru.dba@stripped]
> Sent: 12 December 2008 13:40
> To: BAJAJ POOJA
> Cc: chaim.rieger@stripped; mysql@stripped
> 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.Bajaj@stripped> 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.Bajaj@stripped
> <mailto:Email%3APooja.Bajaj@stripped>
> Phone:+124-413-3078 | Onnet: 2721-3078
>
> -----Original Message-----
> From: chaim.rieger@stripped [mailto:chaim.rieger@stripped]
>
> Sent: 12 December 2008 13:13
> To: BAJAJ POOJA; Chandru
> Cc: mysql@stripped
> 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.Bajaj@stripped>
>
> Date: Fri, 12 Dec 2008 08:43:45
> To: <chaim.rieger@stripped>; Chandru<chandru.dba@stripped>
> Cc: <mysql@stripped>
> 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.Bajaj@stripped
> <mailto:Email%3APooja.Bajaj@stripped>
> Phone:+124-413-3078 | Onnet: 2721-3078
>
> -----Original Message-----
> From: chaim.rieger@stripped [mailto:chaim.rieger@stripped]
> Sent: 12 December 2008 13:02
> To: BAJAJ POOJA; Chandru
> Cc: mysql@stripped
> 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.Bajaj@stripped>
>
> Date: Fri, 12 Dec 2008 08:27:02
> To: Chandru<chandru.dba@stripped>
> Cc: <mysql@stripped>
> 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.Bajaj@stripped
> <mailto:Email%3APooja.Bajaj@stripped>
> Phone:+124-413-3078 | Onnet: 2721-3078
>
>
> ________________________________
>
> From: Chandru [mailto:chandru.dba@stripped]
> Sent: 12 December 2008 12:50
> To: BAJAJ POOJA
> Cc: mysql@stripped
> 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.Bajaj@stripped> wrote:
>
>
> Hi Chandru,
>
> Can you pls. help where can i search for logs.
>
>
> --
> Thanks & Regards
> Pooja Bajaj
> Alcatel-Lucent, India
> Email:Pooja.Bajaj@stripped
> <mailto:Email%3APooja.Bajaj@stripped>
> <mailto:Email%3APooja.Bajaj@stripped
> <mailto:Email%253APooja.Bajaj@stripped> >
> Phone:+124-413-3078 | Onnet: 2721-3078
>
>
> ________________________________
>
> From: Chandru [mailto:chandru.dba@stripped]
> Sent: 12 December 2008 11:58
> To: BAJAJ POOJA
> Cc: mysql@stripped
> 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.Bajaj@stripped> 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.Bajaj@stripped
> <mailto:Email%3APooja.Bajaj@stripped>
> <mailto:Email%3APooja.Bajaj@stripped
> <mailto:Email%253APooja.Bajaj@stripped> >
> Phone:+124-413-3078 | Onnet: 2721-3078
>
>
>
>
>
>
>
>
>
>
