[MonoDevelop] Database plugin for monodevelop using MySQL

[xplicit]

  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.