MySQL and RoR 2.2.2 -- deadlock?

Rails
1

Note: Serious criticism follows since I want to see rails improve.

I was a happy camper getting along well with introducing myself with RoR
2.2.2 when disaster struck and I think I am not alone (a Google search
indicates so).

So, I am looking for definitive actions to get out of the mess. Please
don’t suggest to work with sqlite3 to begin with. I want to get mysql
and rails 2.2.2 to speak to each other now.

  • Ubuntu installed – 8.0.4.
  • Lamp server reinstalled, just to wipe everything clean (sudo apt-get
    install lamp-server, this (hopefully) installs everything right).
  • Mysqld started
  • Ruby Gems installed.
  • gem install rails --> fetches rails 2.2.2.
  • rails --database=mysql people -> creates the standard structure
  • change the database.yml to reflect mysql password.
  • change the migrate file a bit to match a model created using
    script/generate model Person
  • rake db:migrate

This wreaks a havoc.
!!! The bundled mysql.rb driver has been removed from Rails 2.2. Please
install the mysql gem and try again: gem install mysql.
rake aborted!
no such file to load – mysql

Somewhere I even saw a fierce reaction (like WTF?) to removing mysql.rb
from rails 2.2. This is just unfortunate.

  • I press on.
  • kedar@kedar-laptop:~/Projects/ror/people$ sudo gem install mysql
    [sudo] password for kedar:
    Building native extensions. This could take a while…
    ERROR: Error installing mysql:
    ERROR: Failed to build gem native extension.

A HUGE trace follows. I am losing patience now.

Why doesn’t rails behave?
Why can’t gem improve the situation?

Please help and sorry to vent the frustration. But where else to vent it
if not here?

Thank you in advance.

-Kedar

2

Hi Kedar,

I am certainly no expert, but I suffered with the error for several
days too.

I think you need more information on your install line.

I used for OSX 10.5
sudo gem install mysql – --with-mysql-config=/usr/local/mysql/bin/
mysql_config

from:
http://www.scribemedia.org/2009/01/02/installing-mysql-gem-on-mac-osx-105/

I have included the other links I browsed on the way to the solution
too. There is likely a path difference with Ubuntu, but maybe this
will help.

Eric

http://discuss.joyent.com/viewtopic.php?id=5992
sudo gem install mysql – --with-mysql-include=/usr/local/mysql/
include/ with-mysql-lib=/usr/local/mysql/lib/

• A similar change (when rebuilding mysql) was required to install
the mysql gem:
â—¦ ./configure --prefix=/web/pkg/mysql/mysql … CPPFLAGS=‘-fPIC’
â—¦
• Installing the mysql gem also required an additional option to
help it find the libraries
â—¦ sudo gem install mysql – --with-mysql-config=/web/pkg/mysql/
current/bin/mysql_config

I also looked here.

http://pjforpresident.com/2008/06/20/compiling-mysql-native-bindings-on-os-x-macports/
http://blog.bmn.name/2008/02/rails-gem-install-mysql-throws-error-extconfrb-failed/
http://blog.springenwerk.com/2008/11/rails-22-and-native-mysql-gem-on-mac-os.html

3

A shame you omitted the bit with the actual information :slight_smile:
You’ll need to make sure you have the development packages for both
ruby and mysql (something like ruby-dev and libmysql-dev)

Fred

4

I used for OSX 10.5
sudo gem install mysql – --with-mysql-config=/usr/local/mysql/bin/
mysql_config

Hi Eric,

Thanks for your help. The problem was that the computer did not have
libmysqlclient15-dev package which contains mysql_config. I did the
following

sudo apt-get install libmysqlclient15-dev

and then gem install mysql worked as expected.

I am going to get this wiki’ed at Peak Obsession

Thanks for your help. It’s quite intimidating/challenging for a n00b
even if s/he is a hacker at heart. The funny part was it was all working
till I upgraded to rails 2.2.2 in a vein to be on the latest stable
branch.

-Kedar