Table of Contents
Approved
Here are a few simple steps that should help resolve the wsagetlasterror return 10061 connection socket error issue.
Disclaimer: Information in the Paessler Knowledge Base is provided without warranty for this range. Use at your own risk. Before applying the instructions, please perform the appropriate administration by the administrator. You must ensure that a proper backup of all your data is available.
I feel like I’m new to PRTG. I want to monitor the database but my probe is returning this issue:Failed to connect to database: MySQL server cannot connect to ‘x.x.x.x’ (10061). Socket error while connecting. WSAGetLastError returns 10060 ($274C)
Can I tell the PRTG user (node) to be allowed to connect to the new database? Did you clear the permissions after creating the user?
I have the same problem. Normally you need a port when connecting to MySQL, which I found odd due to the fact that the software doesn’t have a box in the PRTG connection path.
The port, username, and identity must be configured for the device settings in the database management system credentials, is that correct?:)
I’ll check and let you know if everything is ok or not.
I don’t have an option to manage the system ID database in the device settings.Apparently I have a Windows system credential, a Linux/Solaris/Mac OS (SSH/WBEM) credential, a VMware/XenServer credential, and an SNMP device credential.
In older versions of PRTG, index credentials were configured in the alternatives sensor. But please test your reading and writing skills first as mentioned in many of my other articles 🙂
The PRTG host cannot select a MySQL server, but the user is assumed to be authorized to connect to the database (I have connected to other hosts before).
The connection between PRTG and a server on our network is usually through a router (which is probably also a firewall) controlled by other people. I asked these products to check if port 3306 should be open.
- iad
- Posts: 34
- Signed: Fri Nov 24, 2006 7:38 AM
Socket Error, Connectednaya With Connection. WSAGetLastError Returns 10060($274C)
Hello,
Thank you for your help,
Socket annoys me on connection error. WSAGetLastError recovery error 10060($274C) all the time,
This almost certainly happens when running scripts and executing queries, and interestingly, it only happens in medical procedures when two MySQL hosts are called one after the other.
It happens that a lot of customers diverge,
I set the time to 60 seconds but the game still launches.
I just have to say that if I use another MySQL step I don’t get the error,
Am I doing something wrong?
- iad
- Posts: 34
- Signed: Fri Nov 24, 2006 7:38 AM
and one more person,
I measured the time it takes for these errors to appear: 11-21 seconds,
The 60 second timeout I set should be everything?
- Anta
- Messages: 2098
- Signed: Tuesday, February 14, 2006 10:14 AM
Thanks for the resources. Unfortunately, we were unable to reproduce the disease.
Please send a small complete procedure to evgeniyD*crlab*com,show it, which contains a script to create and populate tables.
We also provide the following information
to a specific version of Delphi, C++ Builder or Kylix
– Accurate version of MyDAC. You can apply it to the details sheet using TMyConnection Editor
– Exactly relative to MySQL server version and MySQL owner. You can see this in the info sheet of the TMyConnection Editor
- Anta
- Posts: 2098
- Registered: Tuesday, February 14, 2008 10:14 AM
Approved
The ASR Pro repair tool is the solution for a Windows PC that's running slowly, has registry issues, or is infected with malware. This powerful and easy-to-use tool can quickly diagnose and fix your PC, increasing performance, optimizing memory, and improving security in the process. Don't suffer from a sluggish computer any longer - try ASR Pro today!
![](/wp-content/download7.png)
There is probably a problem with your network. Please check your proxy, firewall and antivirus software settings to help. Is there a problem when the second server part is on localhost?
- iad
- Messages: 34
- Signed: Fri Nov 24, 2006 7:38 AM
Hello,
I think I can solve this problem directly by setting the combination to True.
I wonder why….?
Now I bring a new problem, currently the MYSQL server crashes once when using SSL, which is unusual….
any index 2098
- Anta
- Messages: Tuesday, February 14, 2006 10:14 AM
I have the advantage that I can fix this by setting the pool to true.
I wonder why….?
Glad to see that the issue has been resolved.
Most likely, the cause of the above problem lies in your environment. If you set the pool to True, the report will not actually be shared. It was placed in a pool set. If someone then tries to connect with the same settings, they will no doubt be removed from the pool. So allowing join does not completely solve this problem. You will probably meet him later in a different form.
I have a new problem now, MYSQL server crashes for a whole day when using Strange SSL,…. go to
any?
Try to enable the connection to the server and check the log files after the failure. Choose to use the latest version of MySQL Server. The problem with the server is probably already resolved.
- iad
- Posts: 34
- Signed: Exclusive November 24, 2006 7:38 AM
What are the latest SSL libraries tested by MyDAC customers?
I use the most complex
and I get everything every time
Assertion failed (d:ProjectsDelphiMydacSourceMySqlVioTcpSSL.line number, 87)
Suggestions?
I’m using Delphi 2006 with your current MyDAC (not beta)
- Anta
- Posts: 2098
- Registered: Tuesday, February 14, 2007 10:14 AM The software to fix your PC is just a click away - download it now.
![Jake Steere](https://itnewstoday.net/wp-content/uploads/jakesteere.jpg)