Hi, I am getting a mysql error while running a ruby file on my system (Windows): D:/ruby/lib/ruby/1.8/mysql.rb:453:in `read'': Client does not support authentication protocol requested by server; consider upgrading MySQL c lient (Mysql::Error) from D:/ruby/lib/ruby/1.8/mysql.rb:130:in `real_connect'' from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/mysql_adapter.rb:576:in `connect'' from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/mysql_adapter.rb:204:in `initialize'' from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/mysql_adapter.rb:76:in `new'' from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/mysql_adapter.rb:76:in `mysql_connectio n'' from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/abstract/connection_pool.rb:223:in `sen d'' from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/abstract/connection_pool.rb:223:in `new _connection'' from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/abstract/connection_pool.rb:245:in `che ckout_new_connection'' ... 16 levels... from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/base.rb:1991:in `all_attributes_exists?'' from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/base.rb:1847:in `method_missing'' from test1.rb:28:in `select_type'' from test1.rb:39 I have Ruby 1.8.6 and Mysql Server 5.0 installed. I also have gone through google: http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/198795 http://stackoverflow.com/questions/436980/has-anyone-successfully-connected-to-mysql-from-ruby but it did not help. Do I need to make any configuration for this? Thanks in advance -gourav
On Jun 1, 4:44 pm, Gourav Tiwari <gouravtiwar...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hi, > > I am getting a mysql error while running a ruby file on my system > (Windows): > > D:/ruby/lib/ruby/1.8/mysql.rb:453:in `read'': Client does not support > authentication protocol requested by server; consider upgrading MySQL > c > lient (Mysql::Error) > from D:/ruby/lib/ruby/1.8/mysql.rb:130:in `real_connect'' > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > active_record/connection_adapters/mysql_adapter.rb:576:in `connect'' > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > active_record/connection_adapters/mysql_adapter.rb:204:in `initialize'' > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > active_record/connection_adapters/mysql_adapter.rb:76:in `new'' > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > active_record/connection_adapters/mysql_adapter.rb:76:in > `mysql_connectio > n'' > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > active_record/connection_adapters/abstract/connection_pool.rb:223:in > `sen > d'' > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > active_record/connection_adapters/abstract/connection_pool.rb:223:in > `new > _connection'' > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > active_record/connection_adapters/abstract/connection_pool.rb:245:in > `che > ckout_new_connection'' > ... 16 levels... > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > active_record/base.rb:1991:in `all_attributes_exists?'' > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > active_record/base.rb:1847:in `method_missing'' > from test1.rb:28:in `select_type'' > from test1.rb:39 > > I have Ruby 1.8.6 and Mysql Server 5.0 installed. I also have gone > through google:http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/198795http://stackoverflow.com/questions/436980/has-anyone-successfully-con... > > but it did not help. Do I need to make any configuration for this? > > Thanks in advance > -gouravCan you verify if following things are in proper place. 1. Are you able to connect to mysql otherwise on your system. 2. Have you done $gem install mysql 3. Copy libmySQL.dll from MYSQL_INSTALL/bin forlder to RUBY_INSTALL/ bin folder 3. Verify database.yml has your password vipin
Thanks for your reply Vipin, I am able to connect to Mysql through command prompt and mysql query browser. Also, I am able to connect to a remote system by mysql query browser tool. I have copied ibmySQL.dll from MYSQL_INSTALL/bin forlder to RUBY_INSTALL/bin folder I have mysql gem installed 2.7.1 but it still doesn''t work. -gourav On Jun 1, 5:28 pm, Vipin <sh.vi...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> On Jun 1, 4:44 pm, Gourav Tiwari <gouravtiwar...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > Hi, > > > I am getting a mysql error while running a ruby file on my system > > (Windows): > > > D:/ruby/lib/ruby/1.8/mysql.rb:453:in `read'': Client does not support > > authentication protocol requested by server; consider upgrading MySQL > > c > > lient (Mysql::Error) > > from D:/ruby/lib/ruby/1.8/mysql.rb:130:in `real_connect'' > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > active_record/connection_adapters/mysql_adapter.rb:576:in `connect'' > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > active_record/connection_adapters/mysql_adapter.rb:204:in `initialize'' > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > active_record/connection_adapters/mysql_adapter.rb:76:in `new'' > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > active_record/connection_adapters/mysql_adapter.rb:76:in > > `mysql_connectio > > n'' > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > active_record/connection_adapters/abstract/connection_pool.rb:223:in > > `sen > > d'' > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > active_record/connection_adapters/abstract/connection_pool.rb:223:in > > `new > > _connection'' > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > active_record/connection_adapters/abstract/connection_pool.rb:245:in > > `che > > ckout_new_connection'' > > ... 16 levels... > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > active_record/base.rb:1991:in `all_attributes_exists?'' > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > active_record/base.rb:1847:in `method_missing'' > > from test1.rb:28:in `select_type'' > > from test1.rb:39 > > > I have Ruby 1.8.6 and Mysql Server 5.0 installed. I also have gone > > through google:http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/198795htt...... > > > but it did not help. Do I need to make any configuration for this? > > > Thanks in advance > > -gourav > > Can you verify if following things are in proper place. > > 1. Are you able to connect to mysql otherwise on your system. > 2. Have you done $gem install mysql > 3. Copy libmySQL.dll from MYSQL_INSTALL/bin forlder to RUBY_INSTALL/ > bin folder > 3. Verify database.yml has your password > > vipin
The message said, update your MySQL client, reverify your conf file, and try again. What MySQL version have you? On Mon, Jun 1, 2009 at 8:05 AM, Gourav Tiwari <gouravtiwari21-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>wrote:> > Thanks for your reply Vipin, > > I am able to connect to Mysql through command prompt and mysql query > browser. > > Also, I am able to connect to a remote system by mysql query browser > tool. > I have copied ibmySQL.dll from MYSQL_INSTALL/bin forlder to > RUBY_INSTALL/bin folder > > I have mysql gem installed 2.7.1 > > but it still doesn''t work. > > -gourav > > On Jun 1, 5:28 pm, Vipin <sh.vi...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > On Jun 1, 4:44 pm, Gourav Tiwari <gouravtiwar...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > > > > > Hi, > > > > > I am getting a mysql error while running a ruby file on my system > > > (Windows): > > > > > D:/ruby/lib/ruby/1.8/mysql.rb:453:in `read'': Client does not support > > > authentication protocol requested by server; consider upgrading MySQL > > > c > > > lient (Mysql::Error) > > > from D:/ruby/lib/ruby/1.8/mysql.rb:130:in `real_connect'' > > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > > active_record/connection_adapters/mysql_adapter.rb:576:in `connect'' > > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > > active_record/connection_adapters/mysql_adapter.rb:204:in `initialize'' > > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > > active_record/connection_adapters/mysql_adapter.rb:76:in `new'' > > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > > active_record/connection_adapters/mysql_adapter.rb:76:in > > > `mysql_connectio > > > n'' > > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > > active_record/connection_adapters/abstract/connection_pool.rb:223:in > > > `sen > > > d'' > > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > > active_record/connection_adapters/abstract/connection_pool.rb:223:in > > > `new > > > _connection'' > > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > > active_record/connection_adapters/abstract/connection_pool.rb:245:in > > > `che > > > ckout_new_connection'' > > > ... 16 levels... > > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > > active_record/base.rb:1991:in `all_attributes_exists?'' > > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > > active_record/base.rb:1847:in `method_missing'' > > > from test1.rb:28:in `select_type'' > > > from test1.rb:39 > > > > > I have Ruby 1.8.6 and Mysql Server 5.0 installed. I also have gone > > > through google: > http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/198795htt.... > .. > > > > > but it did not help. Do I need to make any configuration for this? > > > > > Thanks in advance > > > -gourav > > > > Can you verify if following things are in proper place. > > > > 1. Are you able to connect to mysql otherwise on your system. > > 2. Have you done $gem install mysql > > 3. Copy libmySQL.dll from MYSQL_INSTALL/bin forlder to RUBY_INSTALL/ > > bin folder > > 3. Verify database.yml has your password > > > > vipin > > >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Hi Gerardo, I am using "MYSQL Ver 14.12 Distrib 5.0.77, for Win32 (ia32)" Another strange thing I noticed is I am able to run a rails(2.2.2) application here, without any issue. On Jun 1, 9:31 pm, Gerardo Gonzalez Cruz <gerardogc2...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> The message said, update your MySQL client, reverify your conf file, and try > again. What MySQL version have you? > > On Mon, Jun 1, 2009 at 8:05 AM, Gourav Tiwari <gouravtiwar...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>wrote: > > > > > Thanks for your reply Vipin, > > > I am able to connect to Mysql through command prompt and mysql query > > browser. > > > Also, I am able to connect to a remote system by mysql query browser > > tool. > > I have copied ibmySQL.dll from MYSQL_INSTALL/bin forlder to > > RUBY_INSTALL/bin folder > > > I have mysql gem installed 2.7.1 > > > but it still doesn''t work. > > > -gourav > > > On Jun 1, 5:28 pm, Vipin <sh.vi...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > On Jun 1, 4:44 pm, Gourav Tiwari <gouravtiwar...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > Hi, > > > > > I am getting a mysql error while running a ruby file on my system > > > > (Windows): > > > > > D:/ruby/lib/ruby/1.8/mysql.rb:453:in `read'': Client does not support > > > > authentication protocol requested by server; consider upgrading MySQL > > > > c > > > > lient (Mysql::Error) > > > > from D:/ruby/lib/ruby/1.8/mysql.rb:130:in `real_connect'' > > > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > > > active_record/connection_adapters/mysql_adapter.rb:576:in `connect'' > > > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > > > active_record/connection_adapters/mysql_adapter.rb:204:in `initialize'' > > > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > > > active_record/connection_adapters/mysql_adapter.rb:76:in `new'' > > > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > > > active_record/connection_adapters/mysql_adapter.rb:76:in > > > > `mysql_connectio > > > > n'' > > > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > > > active_record/connection_adapters/abstract/connection_pool.rb:223:in > > > > `sen > > > > d'' > > > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > > > active_record/connection_adapters/abstract/connection_pool.rb:223:in > > > > `new > > > > _connection'' > > > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > > > active_record/connection_adapters/abstract/connection_pool.rb:245:in > > > > `che > > > > ckout_new_connection'' > > > > ... 16 levels... > > > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > > > active_record/base.rb:1991:in `all_attributes_exists?'' > > > > from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > > > active_record/base.rb:1847:in `method_missing'' > > > > from test1.rb:28:in `select_type'' > > > > from test1.rb:39 > > > > > I have Ruby 1.8.6 and Mysql Server 5.0 installed. I also have gone > > > > through google: > >http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/198795htt.... > > .. > > > > > but it did not help. Do I need to make any configuration for this? > > > > > Thanks in advance > > > > -gourav > > > > Can you verify if following things are in proper place. > > > > 1. Are you able to connect to mysql otherwise on your system. > > > 2. Have you done $gem install mysql > > > 3. Copy libmySQL.dll from MYSQL_INSTALL/bin forlder to RUBY_INSTALL/ > > > bin folder > > > 3. Verify database.yml has your password > > > > vipin