Too many TCP Ports?

Discussion in 'Site & Server Administration' started by Cobnut, Jul 18, 2008.

0
  1. #1
    Just today one of our PHP apps has started showing MySQL connection errors randomly ('Can't connect to MySQL server on 'localhost' (10048)'). Some surfing suggests that a possible cause is TCP ports (this is a Windows server, unfortunately).

    http://dev.mysql.com/doc/refman/5.0...ver.html#can-not-connect-to-server-on-windows

    How can I check to see if this IS the problem? Is there a perfmon counter I can look at to check how many ports are in use?

    Any help or suggestions of other causes appreciated.

    Jon
     
    Cobnut, Jul 18, 2008 IP
  2. jayshah

    jayshah Peon

    Messages:
    1,126
    Likes Received:
    68
    Best Answers:
    1
    Trophy Points:
    0
    #2
    Have you tried netstat?

    i.e. netstat -n (or -d, you don't want hostnames)

    Jay
     
    jayshah, Jul 18, 2008 IP
  3. mellow-h

    mellow-h Peon

    Messages:
    750
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #3
    If your php script is saying can't connect to mysql, that means your mysql is not running or your php script is not being able to connect with mysql. Can you try restarting your mysql?
     
    mellow-h, Jul 18, 2008 IP