Solved

mysql connections

Posted on 2007-03-22
4
3,597 Views
Last Modified: 2008-02-21

We have just installed our application in about 100 user sites.(all remote)

On the whole it is going OK, but a couple of users keep getting this error

Can\'t connect to mySQL server on [server] 10061 .Socket error on connect. WSAGetLastError return 10061($274D)\

Out application is on the local PC, Mysql data on the server.
My application is written is Delphi, using standard components.
0
Comment
Question by:junebrown
  • 2
4 Comments
 
LVL 8

Expert Comment

by:Yuval_Shohat
ID: 18770624
i assume that the application is ran individually on each of the user's sites and all are linked to your mysql data server.
does the error appeares allways in the same computers (same users always getting this error)
then i would try to check what is different with these users. I had a case when a user decided to play with his firewall and deleted all the firewall's rules, thus blocking all data transfer to mysql port 3306. worth checking.
Or does the error randomly appearing everytime with  one or more different users? then maybe the server's limits of connections is worth checking, or maybe the bandwith and so on...
you need to do some debuging and go step by step in order to find out where exactly the problem is.

hope this helps
-=Yuval=-
0
 

Author Comment

by:junebrown
ID: 18779815
I think it is random, as sometimes it work other it does.

Dont think it is a user limit, as they only have 2 or 3 users on it.
and I will go back and check. thanks for these comments.
0
 
LVL 12

Expert Comment

by:str_kani
ID: 18814675
10061 means actively refused. May be check your event log around the same
time to see if mysql died?
0
 

Accepted Solution

by:
junebrown earned 0 total points
ID: 20886418
users cleared it through permissions
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Know what services you can and cannot, should and should not combine on your server.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now