Socket error on connect. WSAGetLastError return 10060($274C)

iad · Post by **iad** » Wed 24 Jan 2007 23:39

Hi,
Thanks for the help so far,
i getting annoyed by Socket error on connect. WSAGetLastError return 10060($274C) error all the time,
this is happening on Scrip execute and Query execute and what is interesting is that it happened only in procedure that calling to two MySQL servers one after one.
it happpenning several clients spreading around,
i set the time out to 60 seconds, but it still keep coming.
just must say that when i;'m using different MySQL component , i don;t get any error,
something i'm doing wrong ?

Lior,

iad · Post by **iad** » Wed 24 Jan 2007 23:44

and one more thing,
i measured the time it take for the spitting the error, it 11-21 seconds,
the the 60sec timeout i set should be intact ?

Antaeus · Post by **Antaeus** » Thu 25 Jan 2007 07:53

Thank you for information. Unfortunately we could not reproduce the problem.
Please send a complete small sample to evgeniyD*crlab*com to demonstrate it, including script to create and fill table(s).

Also supply us the following information
- Exact version of Delphi, C++ Builder or Kylix
- Exact version of MyDAC. You can see it in the About sheet of TMyConnection Editor
- Exact version of MySQL server and MySQL client. You can see it in the Info sheet of TMyConnection Editor

Antaeus · Post by **Antaeus** » Thu 25 Jan 2007 09:02

Probably there is something wrong with your network. Please check settings of your proxy, firewall, antivirus software, etc. Does the problem appear if the second server is located on localhost?

iad · Post by **iad** » Thu 25 Jan 2007 19:35

Hi,
i thing i manage to fix it by setting the pooling to True.
i wonder why .... ?

i have a new problem now, the MYSQL server is crashing one a day when using SSL, strange ....
any lead ?

Lior,

Antaeus · Post by **Antaeus** » Fri 26 Jan 2007 12:14

i thing i manage to fix it by setting the pooling to True.
i wonder why .... ?

It is good to see that this problem has been solved.
Probably the reason of this problem is in your environment. If you set Pooling to True, connection is not actually released. It is put into pool. Then if you try to establish a connection with the same settings, it is just obtained from the pool. So enabling pooling does not solve this problem completely. Probably you will encounter it later in a different form.

i have a new problem now, the MYSQL server is crashing one a day when using SSL, strange ....
any lead ?

Try to enable logging in the server and check log files after the crash. Make sure that you use the last version of MySQL Server. Probably this is a fixed server problem.

iad · Post by **iad** » Fri 26 Jan 2007 17:29

What is the latest SSL libs you tested MyDAC ?
i'm using the latest one
and i get all the time
Assertion failure (d:\Projects\Delphi\Mydac\Source\MySqlVioTcpSSL.pas, line 87)
any idea ?
i'm using Delphi 2006 with your latest MyDAC ( not the Beta)

Antaeus · Post by **Antaeus** » Tue 30 Jan 2007 10:59

We tested MyDAC with OpenSSL 0.9.7c. We know about problems with latest versions of OpenSSL. Now we are working on supporting the last OpenSSL version. It will be added to the nearest builds of MyDAC 4 and MyDAC 5 beta.

iad · Post by **iad** » Tue 30 Jan 2007 15:18

Thank you,
any have any estimation when it will b e ready ?

Lior,

Antaeus · Post by **Antaeus** » Tue 30 Jan 2007 15:42

We plan to release the new build of MyDAC 4 in about two or three weeks.

iad · Post by **iad** » Tue 30 Jan 2007 15:44

Thank You for your reply.

Lior,