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: 3810

Replies to This Discussion


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...
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!
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.








  • Add Photos
  • View All

© 2023   Created by Scott Davidson.   Powered by

Badges  |  Report an Issue  |  Terms of Service