[MonoDevelop] Database plugin for monodevelop using MySQL

[Luciano _]

Hi, i sent this yesterday

 

--------------------------------------------------------------------------------------------------------

 

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: Mon, 31 May 2010 11:43:15 -0700
> From: svg at ngs.ru
> To: monodevelop-list at lists.ximian.com
> Subject: Re: [MonoDevelop] Database plugin for monodevelop using MySQL
> 
> 
> I can change authentication on my MySQL server by using OLD_PASSWORD() sql
> command and after that Generator can connect to mysql server (but still not
> generates classes), but this won't resolve the main issue: ByteFx data
> provider is dead (last version was realized 2004) and does not support
> MySQL 5.0 (and even 4.1), so it's impossible to use it with stored
> procedures, new data types and all other new features, which were created
> since mysql version 3.
> When I made first post, I looked into the code and realized, that this is
> not right forum for this question, because MonoDevelop uses sqlmetal for
> generating dbml and sqlmetal uses DbLinq, which uses ByteFX. I hope, that I
> will be able to recompile DbLinq with MySQL connector (will try it further)
> and will check this issue again. 
> 
> 
> Jacek Rużyczka-2 wrote:
> > 
> > Hello,
> > 
> > Am Sonntag 30 Mai 2010 08:58:37 schrieb xplicit:
> >> 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?
> >> 
> > Although I am no MySQL expert, may I advise you to look into the config of 
> > your MySQL server. RDBMS servers offer a variety of authentication methods 
> > (plain password, MD5-encrypted password, Kerberos,...), and the
> > client-side 
> > database driver must support the authentication method preset on the
> > server. 
> > And the respective authentication method must be set in the connection
> > string 
> > you pass to IDbConnection. Otherwise you'll get error messages like the
> > one 
> > you encountered.
> > 
> > So please check both the server config, and the connection string, and 
> > experiment a little bit with the alternatives offered. If this does not
> > help, 
> > the driver doesn't support the authentication method you chose.
> > 
> > Kind regards
> > Jacek
> > 
> > 
> > ----------------------------------------------------------------------
> > Gra dla duzych chlopcow.
> > http://linkint.pl/f2717
> > 
> > _______________________________________________
> > Monodevelop-list mailing list
> > Monodevelop-list at lists.ximian.com
> > http://lists.ximian.com/mailman/listinfo/monodevelop-list
> > 
> > 
> 
> -- 
> View this message in context: http://mono.1490590.n4.nabble.com/Database-plugin-for-monodevelop-using-MySQL-tp2236120p2237722.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/20100609/6e03e2a3/attachment.html