Problem with connection

Hi Nathan!

I with some other guys are trying to connect to Database on server through local network with WiFi. We try do it with different 5 computers. But only 2 can connect with DB. We're useing one definition. When I switch to "true" in "MySQL Database List " I get the following message:

System.TimeoutException: Timeout in IO operation
   in MySql.Data.MySqlClient.TimedStream.StopTimer()
   in MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   in System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   in MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   in MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   in MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   in MySql.Data.MySqlClient.NativeDriver.Open()
   in MySql.Data.MySqlClient.Driver.Open()
   in MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   in MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   in MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   in MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   in MySql.Data.MySqlClient.MySqlPool.GetConnection()
   in MySql.Data.MySqlClient.MySqlConnection.Open()
   in Slingshot.GHMYSQL_DatabaseList.SolveInstance(IGH_DataAccess DA)

I have connecting with DB with MySQL Workbench, it means that I have link with server and DB. And i guess that is problem with Slingshot. Do you have some ideas about this problem?

Replies to This Discussion

Permalink Reply by Nathan Miller on August 8, 2011 at 1:12pm

Hello,

So to clarify, 2 out of the 5 computers are able to connect through Slingshot? And the other 3 return a timeout exception? Are all 5 of the computers able to connect with workbench?

Permalink Reply by Nathan Miller on August 8, 2011 at 1:16pm

Also, what are the connection speeds like over the WiFi?

Permalink Reply by Eduard Haiman on August 10, 2011 at 1:27am

Yesterday I had connection several time through slingshot . But now I cant connect again. I try connect with LAN but it didn't give effect.

Permalink Reply by Nathan Miller on August 8, 2011 at 1:31pm

Another thing to verify...

check that your users have the right db privileges. I found a thread where a MySQL user was getting a similar message with another .net program...

http://toadformysql.com/thread.jspa?threadID=32380

Permalink Reply by Eduard Haiman on August 10, 2011 at 3:15am

We have right privileges.

Permalink Reply by Eduard Haiman on August 10, 2011 at 3:15am

If this problem with Timeout, maybe there need extend delay for slingshot?

Permalink Reply by Nathan Miller on August 10, 2011 at 12:04pm

Send me your definition and I will take a look at it and see if I can replicate the error. It may be couple of days since I am away from home and not near my server. But I can at least take a look at your definition.

One thing you can try...

You can set a connection or command timeout in your connection string.

Instead of using my connection string component, use a panel component and use one of the following connection strings (fill in the blanks with your info)....

Set a command timeout:

Server=myServerAddress;Port=3306;Uid=myUsername;Pwd=myPassword;default command timeout=20

Set a connection timeout:

Server=myServerAddress;;Port=3306;Uid=myUsername;Pwd=myPassword;Connection Timeout=5

Set both:

Server=myServerAddress;;Port=3306;Uid=myUsername;Pwd=myPassword;Connection Timeout=5;default command timeout=20

In the meantime, I will look into changing the timeout properties in the source...or make them available as component parameters.

Also, out of curiosity, what is your MySQL version?

Permalink Reply by Eduard Haiman on August 10, 2011 at 12:18pm

I've just used string: Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Connection Timeout=30;

And it's working! Thanks a lot, Nathan!

Permalink Reply by Nathan Miller on August 10, 2011 at 1:47pm

Great!
I will add a timeout parameter (among others) to the connection string component in the next release. let me know if you have any other issues or recommendations.

cheers!

Nathan

RSS