From: Derek Chesterfield <dez@...>
Date: 2006-02-05T02:17:44+09:00
Subject: Re: install mysql-ruby on RHEL

I don't know what is wrong in your case. However, in my case, I  
wanted a newer version of MySQL than came with RHEL (RHEL4 has MySQL  
v4 - I wanted v5), so I installed a new MySQL from sources into /usr/ 
local).

Then I did 'gem install mysql -- --with-mysql-dir=/usr/local', and  
everything built fine.

On 4 Feb 2006, at 3:58pm, Richard Navarrete wrote:

> Howdy,
>
> I've successfully installed ruby-rails-mysql on my powerbook, on  
> our Windows server, but am missing something on our Linux box.
>
> Ruby is installed (1.8.4), so is rails (0.8.11).  And I got the  
> "Congratulations, you put Ruby on Rails!" screen.  I have MySQL  
> already installed (it's been there for a long time), version 4.0.25).
>
> Now, I need to install the driver for MySQL/Ruby (mysql-ruby-2.7).   
> Here's how the progression goes:
>
> <code>
>
> [richard@www mysql-ruby-2.7]$ ruby ./extconf.rb --with-mysql-dir=/usr
> checking for mysql_query() in -lmysqlclient... yes
> checking for mysql_ssl_set()... yes
> checking for mysql.h... no
> checking for mysql/mysql.h... yes
> creating Makefile
>
> [richard@www mysql-ruby-2.7]$ make
> gcc -fPIC -g -O2  -I. -I/usr/local/lib/ruby/1.8/i686-linux -I/usr/ 
> local/lib/ruby/1.8/i686-linux -I. -DHAVE_MYSQL_SSL_SET - 
> DHAVE_MYSQL_MYSQL_H -I/usr/include  -c mysql.c
> gcc -shared  -L'/usr/lib' -Wl,-R'/usr/lib' -L'/usr/local/lib' -Wl,- 
> R'/usr/local/lib' -o mysql.so mysql.o  -lmysqlclient  -ldl -lcrypt - 
> lm   -lc
>
> [richard@www mysql-ruby-2.7]$ ruby ./test.rb localhost root  
> <myrootpass> test
> ./test.rb:143: undefined method `client_version' for Mysql:Class  
> (NoMethodError)
>
> </code>
>
> BTW, I created an empty database called `test`.
>
> Anyone had a similar experience?  Any ideas?
>
> Cheers,
> Richard
>
>