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?
Tags:
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?
Welcome to
Grasshopper
© 2024 Created by Scott Davidson. Powered by