Forum: Ruby on Rails ruby mysql error

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Febcde7f09d486161ab6b3180c8b85c7?d=identicon&s=25 Gourav Tiwari (Guest)
on 2009-06-01 13:45
(Received via mailing list)
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/...
http://stackoverflow.com/questions/436980/has-anyo...

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

Thanks in advance
-gourav
Ff834f7363c1dc9c48b525fc48c67912?d=identicon&s=25 Vipin (Guest)
on 2009-06-01 14:29
(Received via mailing list)
On Jun 1, 4:44 pm, Gourav Tiwari <gouravtiwar...@gmail.com> 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
3. Verify database.yml has your password

vipin
Febcde7f09d486161ab6b3180c8b85c7?d=identicon&s=25 Gourav Tiwari (Guest)
on 2009-06-01 15:06
(Received via mailing list)
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
631ed31d86f3f4e73a095a80c4b30096?d=identicon&s=25 Gerardo Gonzalez Cruz (Guest)
on 2009-06-01 19:31
(Received via mailing list)
The message said, update your MySQL client, reverify your conf file, and
try
again. What MySQL version have you?
Febcde7f09d486161ab6b3180c8b85c7?d=identicon&s=25 Gourav Tiwari (Guest)
on 2009-06-03 10:56
(Received via mailing list)
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...@gmail.com>
This topic is locked and can not be replied to.