Ruby mysql error


#1

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:inreal_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:ininitialize’
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:inmysql_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:innew
_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:inall_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:inselect_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

but it did not help. Do I need to make any configuration for this?

Thanks in advance
-gourav


#2

On Jun 1, 4:44 pm, Gourav T. removed_email_address@domain.invalid wrote:

    from D:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/

active_record/connection_adapters/abstract/connection_pool.rb:223:in
… 16 levels…
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
  4. Verify database.yml has your password

vipin


#3

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


#4

The message said, update your MySQL client, reverify your conf file, and
try
again. What MySQL version have you?


#5

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 C. removed_email_address@domain.invalid