On Jun 1, 4:44 pm, Gourav Tiwari <[email protected]> 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
> -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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
