From: Venks <venkatesh.mantha@...>
Date: 2007-12-05T23:04:33+09:00
Subject: Re: Ruby works but not JRuby - when using MySQL Driver

I am not able to make the pure Ruby Mysql driver work. I am getting
the following error and couldn't figure out why this error is showing
up. MySQL manual mentions something about old client and password but
I am using MySQL 5.1 and I have no other version installed previously.
Of course I never had any issues with the Native Ruby MySQL driver.
Any ideas?

Error message: Client does not support authentication protocol
requested by server; consider upgrading MySQL client

On Dec 5, 2007 2:31 AM, Charles Oliver Nutter <charles.nutter@sun.com> wrote:
> Venks wrote:
> > Below is the error while running with JRuby:
> >
> > connection.rb:4: /usr/lib/ruby/gems/1.8/gems/mysql-2.7/mysql.so:0:
> > Invalid char `\177' in expression (SyntaxError)
> >         from connection.rb:4:in `require'
> >         from connection.rb:4
> >
> > Is this a compatibility issue between JRuby and MySQL driver writting
> > in Ruby? Is this expected behaviour or can this be addressed?
>
> The pure Ruby MySQL driver should be fine, but it looks like you've got
> the non-pure-Ruby driver and it's trying to load it. There's a known bug
> in JRuby that it will try to load .so files as Ruby source (oops), but
> no amount of magic will make it load native extensions (yet).
>
> Make sure you're using a pure Ruby MySQL driver if you want to access SQL.
>
> - Charlie
>
>