[MonoDevelop] Database plugin for monodevelop using MySQL

[Luciano _]

Hi, you could download the lastest mysql .net connector (i recommend 2.5.x branch) and add it to your gac (gacutil -i MySql.Data.dll), after that, open your machine.config and look at the System.Data configuration, you should have something like:

 

<system.data>
  <DbProviderFactories>
    <add name="MySql Cliente"
     invariant="ByteFx.." 
     description="MySql connector.." 
     type="ByteFx.Data, ByteFx.Data, 
     Version=2.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
    />
  </DbProviderFactories>
</system.data>

 

In the mysql line, change the invariant, type and version attribute with the new values of your downloaded assemblies.
After that, you will be using the new MySql connector, and this should work.


Bye.

Lucian0

 

 

 
> Date: Sat, 29 May 2010 23:58:37 -0700
> From: svg at ngs.ru
> To: monodevelop-list at lists.ximian.com
> Subject: [MonoDevelop] Database plugin for monodevelop using MySQL
> 
> 
> I have monodevelop 2.4 compiled from trunk (r158158). I tried to use database
> plugin with mysql 5. Database connection and database query work fine, but
> when I try to generate LINQ class exception "Client does not support
> authentication protocol requested by server" occurs. Should not they use the
> same approach for accessing mysql throught MySqlClient but not old ByteFx
> provider?
> 
> 
> 
> Database Exception
> MonoDevelop.Database.Sql.SqlMetalExecException: sqlmetal
> failed:ByteFX.Data.MySqlClient.MySqlException: Client does not support
> authentication protocol requested by server; consider upgrading MySQL client
> at ByteFX.Data.MySqlClient.Driver.ReadPacket () [0x00000] in <filename
> unknown>:0 
> at ByteFX.Data.MySqlClient.Driver.Authenticate (System.String userid,
> System.String password, Boolean UseCompression) [0x00000] in <filename
> unknown>:0 
> at ByteFX.Data.MySqlClient.Driver.Open
> (ByteFX.Data.MySqlClient.MySqlConnectionString settings) [0x00000] in
> <filename unknown>:0 
> at ByteFX.Data.MySqlClient.MySqlInternalConnection.Open () [0x00000] in
> <filename unknown>:0 
> at ByteFX.Data.MySqlClient.MySqlPool.CreateNewPooledConnection ()
> [0x00000] in <filename unknown>:0 
> at ByteFX.Data.MySqlClient.MySqlPool.GetPooledConnection () [0x00000] in
> <filename unknown>:0 
> at ByteFX.Data.MySqlClient.MySqlPool.GetConnection () [0x00000] in
> <filename unknown>:0 
> at ByteFX.Data.MySqlClient.MySqlPoolManager.GetConnection
> (ByteFX.Data.MySqlClient.MySqlConnectionString settings) [0x00000] in
> <filename unknown>:0 
> at ByteFX.Data.MySqlClient.MySqlConnection.Open () [0x00000] in <filename
> unknown>:0 
> 
> -- 
> View this message in context: http://mono.1490590.n4.nabble.com/Database-plugin-for-monodevelop-using-MySQL-tp2236120p2236120.html
> Sent from the Mono - MonoDevelop IDE mailing list archive at Nabble.com.
> _______________________________________________
> Monodevelop-list mailing list
> Monodevelop-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/monodevelop-list
 		 	   		  
_________________________________________________________________

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/monodevelop-list/attachments/20100608/93626a0f/attachment.html