Grasshopper

algorithmic modeling for Rhino

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?

Views: 3837

Replies to This Discussion

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?
Also, what are the connection speeds like over the WiFi?
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.
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
We have right privileges.
If this problem with Timeout, maybe there need extend delay for slingshot?

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?

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

And it's working! Thanks a lot, Nathan!
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

About

Translate

Search

Photos

  • Add Photos
  • View All

Videos

  • Add Videos
  • View All

© 2024   Created by Scott Davidson.   Powered by

Badges  |  Report an Issue  |  Terms of Service