Installed MySQL 5.0 on a fresh build of Windows XP. Installed Rails. When I attempt create a test app using scaffold, I get the following error: Client does not support authentication protocol requested by server; consider upgrading MySQL client Any ideas on how to get Rails to work with MySQL 5? -- Best Regards, -Larry "Work, work, work...there is no satisfactory alternative." --- E.Taft Benson _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
On Oct 19, 2005, at 7:33 PM, Larry Kelly wrote:> Client does not support authentication protocol requested by > server; consider upgrading MySQL clientIt means you didn''t up your client. http://dev.mysql.com/doc/refman/5.0/en/old-client.html - Jason
Thanks for the link. I didn''t understand what the message meant. -L On 10/19/05, Jason A. Hoffman <jason-xKtDo/uLHBtl57MIdRCFDg@public.gmane.org> wrote:> > > On Oct 19, 2005, at 7:33 PM, Larry Kelly wrote: > > > Client does not support authentication protocol requested by > > server; consider upgrading MySQL client > > It means you didn''t up your client. > > http://dev.mysql.com/doc/refman/5.0/en/old-client.html > > - Jason > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-- Best Regards, -Larry "Work, work, work...there is no satisfactory alternative." --- E.Taft Benson _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
On 10/19/05, Larry Kelly <ldk2005-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > Thanks for the link. I didn''t understand what the message meant. >It''s probably one of two things. Either your client is not the same version as the server, or you imported the mysql database from another mysql server running an older version. Mysql has a real pain in the (*(&^^ issue where passwords from older versions of mysql use a different encryption then newer versions. Google the error message and you should find a lot of links about this issue. Chris _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
Rubby on rails can''t support mysql5.0, because 5.0 changed auth method. So old client protocal can''t be used. Mysql4.1 is rubby support. Larry Kelly <ldk2005-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:Thanks for the link. I didn''t understand what the message meant. -L On 10/19/05, Jason A. Hoffman <jason-xKtDo/uLHBtl57MIdRCFDg@public.gmane.org > wrote: On Oct 19, 2005, at 7:33 PM, Larry Kelly wrote:> Client does not support authentication protocol requested by > server; consider upgrading MySQL clientIt means you didn''t up your client. http://dev.mysql.com/doc/refman/5.0/en/old-client.html - Jason _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails -- Best Regards, -Larry "Work, work, work...there is no satisfactory alternative." --- E.Taft Benson _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails --------------------------------- Yahoo! Music Unlimited - Access over 1 million songs. Try it free. _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Oct 20, 2005, at 12:55 AM, qiang zhou wrote:> Rubby on rails can''t support mysql5.0, because 5.0 changed auth > method. So old client protocal can''t be used. Mysql4.1 is rubby > support.I''ve been running Rails on MySQL 5 for months with no trouble. Just be sure to use new-style password hashing. Regards, jeremy -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (Darwin) iD8DBQFDV796AQHALep9HFYRAhjMAJ9DacCp3Q/zBIfsOmdDQAoOfcX68QCfdbuO i5CCrE4CZ9PcaYMFTc9Jr7M=x59k -----END PGP SIGNATURE-----
I found the docs on the rails site and the MySQL site confusing. After sorting
through it
you can update rails to use the new password meththod or downgrade MySQL 5 to
use the old
scheme. Since the particular MySQL database I''m using isn''t
valuable right now it was
easier for me to downgrade MySQL by doing:
SET Password = OLD_PASSWORD(''newpwd'')
You can revert back to the new, more secure password by doing:
SET Password = PASSWORD(''newpwd'')
See the MySQL docs referenced in earlier posts.
Warren Seltzer
_______________________________________________
Rails mailing list
Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
http://lists.rubyonrails.org/mailman/listinfo/rails
How do you do that? Warren Seltzer -----Original Message----- From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org [mailto:rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On Behalf Of Jeremy Kemper Sent: Thursday, October 20, 2005 6:02 PM To: rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org Subject: Re: [Rails] Mysql 5 client protocol error -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Oct 20, 2005, at 12:55 AM, qiang zhou wrote:> Rubby on rails can''t support mysql5.0, because 5.0 changed auth > method. So old client protocal can''t be used. Mysql4.1 is rubby > support.I''ve been running Rails on MySQL 5 for months with no trouble. Just be sure to use new-style password hashing.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Nov 21, 2005, at 7:03 AM, Warren Seltzer wrote:> How do you do that?gem install mysql jeremy> Warren Seltzer > > > -----Original Message----- > From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org [mailto:rails- > bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On > Behalf Of Jeremy Kemper > Sent: Thursday, October 20, 2005 6:02 PM > To: rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > Subject: Re: [Rails] Mysql 5 client protocol error > > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On Oct 20, 2005, at 12:55 AM, qiang zhou wrote: >> Rubby on rails can''t support mysql5.0, because 5.0 changed auth >> method. So old client protocal can''t be used. Mysql4.1 is rubby >> support. > > I''ve been running Rails on MySQL 5 for months with no trouble. > Just be sure to use new-style password hashing. > > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (Darwin) iD8DBQFDgeWiAQHALep9HFYRApzVAJ9QVhoU9sMWYlWDu3ON5ihoT8dVlgCfUrpM pe4sn/XatM0T/TgDRxxXEgQ=31mL -----END PGP SIGNATURE-----
Hi. You also could try to compile native bindings for the latest mysql client library. I have had recently the same problem with password incompatibility and I solve it by compiling bindings from sources. I have shared *.so file on my site. Check this out http://pomozov.info/opensource.php#mysql_ruby Let me know how it works for you. On 11/21/05, Jeremy Kemper <jeremy-w7CzD/W5Ocjk1uMJSBkQmQ@public.gmane.org> wrote:> > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On Nov 21, 2005, at 7:03 AM, Warren Seltzer wrote: > > How do you do that? > > gem install mysql > > jeremy > > > > Warren Seltzer > > > > > > -----Original Message----- > > From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org [mailto:rails- > > bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On > > Behalf Of Jeremy Kemper > > Sent: Thursday, October 20, 2005 6:02 PM > > To: rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > > Subject: Re: [Rails] Mysql 5 client protocol error > > > > > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > On Oct 20, 2005, at 12:55 AM, qiang zhou wrote: > >> Rubby on rails can''t support mysql5.0, because 5.0 changed auth > >> method. So old client protocal can''t be used. Mysql4.1 is rubby > >> support. > > > > I''ve been running Rails on MySQL 5 for months with no trouble. > > Just be sure to use new-style password hashing. > > > > > > _______________________________________________ > > Rails mailing list > > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > > http://lists.rubyonrails.org/mailman/listinfo/rails > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.2 (Darwin) > > iD8DBQFDgeWiAQHALep9HFYRApzVAJ9QVhoU9sMWYlWDu3ON5ihoT8dVlgCfUrpM > pe4sn/XatM0T/TgDRxxXEgQ> =31mL > -----END PGP SIGNATURE----- > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-- anatol _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Nov 21, 2005, at 10:34 AM, Anatol Pomozov wrote:> Hi. You also could try to compile native bindings for the latest > mysql client library. > > I have had recently the same problem with password incompatibility > and I solve it by compiling bindings from sources. I have shared > *.so file on my site. Check this out http://pomozov.info/ > opensource.php#mysql_ruby Let me know how it works for you.Incredible! Thank you! You may wish to upgrade to version 2.7 of mysql-ruby; it includes a significant speedup for Active Record. jeremy -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (Darwin) iD8DBQFDghkFAQHALep9HFYRAgMpAKC2jcm5q298D0SE2Q826TyInyVczwCfbZ6i fBSCAiejgx/wmY/o0GOxg5g=0ukt -----END PGP SIGNATURE-----
Hi, Jeremy. I have tried to compile also ver 2.7 but with it I had "Segmentation fault" error. I could also put ver2.7 on site if you like but you will use it for your own risk :) On 11/21/05, Jeremy Kemper <jeremy-w7CzD/W5Ocjk1uMJSBkQmQ@public.gmane.org> wrote:> > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On Nov 21, 2005, at 10:34 AM, Anatol Pomozov wrote: > > Hi. You also could try to compile native bindings for the latest > > mysql client library. > > > > I have had recently the same problem with password incompatibility > > and I solve it by compiling bindings from sources. I have shared > > *.so file on my site. Check this out http://pomozov.info/ > > opensource.php#mysql_ruby Let me know how it works for you. > > Incredible! Thank you! > > You may wish to upgrade to version 2.7 of mysql-ruby; it includes a > significant speedup for Active Record. > > jeremy > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.2 (Darwin) > > iD8DBQFDghkFAQHALep9HFYRAgMpAKC2jcm5q298D0SE2Q826TyInyVczwCfbZ6i > fBSCAiejgx/wmY/o0GOxg5g> =0ukt > -----END PGP SIGNATURE----- > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-- -- anatol (http://pomozov.info) _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails