Solved

mysql connections

Posted on 2007-03-22
4
3,612 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip is around source server preparation. No migration is an easy migration, there is a…
Have you considered what group policies are backwards and forwards compatible? Windows Active Directory servers and clients use group policy templates to deploy sets of policies within your domain. But, there is a catch to deploying policies. The…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

867 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

19 Experts available now in Live!

Get 1:1 Help Now