Connecting to MySQL Using Mono on Solaris

Question

I am trying to use a MySQL database using mono 2.8.1 on Solaris 10. For this I am trying to use the official MySQL Connector / Net . But I get the following exception:

System.Net.Sockets.SocketException: Protocol option not supported at System.Net.Sockets.Socket.GetSocketOption (SocketOptionLevel optionLevel, SocketOptionName optionName) [0x00000] in <filename unknown>:0 at System.Net.Sockets.Socket.get_ReceiveTimeout () [0x00000] in <filename unknown>:0 at System.Net.Sockets.NetworkStream.get_ReadTimeout () [0x00000] in <filename unknown>:0 at MySql.Data.MySqlClient.TimedStream..ctor (System.IO.Stream baseStream) [0x00000] in <filename unknown>:0 at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.TimedStream:.ctor (System.IO.Stream) at MySql.Data.MySqlClient.MySqlStream..ctor (System.IO.Stream baseStream, System.Text.Encoding encoding, Boolean compress) [0x00000] in <filename unknown>:0 at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in <filename unknown>:0 at MySql.Data.MySqlClient.Driver.Open () [0x00000] in <filename unknown>:0 at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00000] in <filename unknown>:0 at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection () [0x00000] in <filename unknown>:0 at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection () [0x00000] in <filename unknown>:0 at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x00000] in <filename unknown>:0 

Solaris does not seem to support ReceiveTimeout , which uses this connector (indirectly).

Is there any way around this exception? Or another way to use a MySQL database from mono on Solaris?

Answer 1

Especially for this question, I installed a virtual machine with solaris 10 and followed the following instructions: Partly: http://developer.mindtouch.com/User:deprecated/*Archive/SAMP (Solaris10, Apache2, MySQL5, PHP5) _with_Mono_setup-guide_for_MindTouch

and http://www.mono-project.com/MySQL

since the last example worked for me.

Answer 2

Just an idea, but the DevArt MySQL connector ( dotConnect for MySQL ) officially supports Mono and maybe it has no problems on Solaris (not using ReceiveTimeout). The components of connecting to the DevArt database are very reliable, the performance is amazing, as well as a reasonable price. Of course, you can test your script with your test.