Forum: Ruby on Rails mysql.rb driver has been removed from Rails 2.2 ?

3cc7ed7c36e8eec971cc8991084bdf00?d=identicon&s=25 Jose Fernandez (jfernandez)
on 2008-07-22 07:44
Out of nowhere I'm starting to get this error message when trying to
access the DB (currently at rails edge):

jose@macbook [~/Development/clients/sequoyah] $ rake db:create
(in /Users/jose/Development/clients/sequoyah)
!!! 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!
Failed to lookup Init function
/usr/local/lib/ruby/site_ruby/1.8/i686-darwin9.3.0/mysql.bundle

(See full trace by running task with --trace)

I've already re-installed the mysql gem a million times (uninstall and
reinstall) and I still get this, any ideas?
6638d6f5855bfd97eb0b99ea31d173b2?d=identicon&s=25 Justin Halsall (juice10)
on 2008-08-14 10:58
I have the same problem when running script/server:
JuicyBook:trunk justin$ script/server
=> Booting Mongrel (use 'script/server webrick' to force WEBrick)
=> Rails 2.1.0 application starting on http://0.0.0.0:3000
=> Call with -d to detach
=> Ctrl-C to shutdown server
** Starting Mongrel listening at 0.0.0.0:3000
** Starting Rails with development environment...
Failed to lookup Init function
/usr/local/lib/ruby/gems/1.8/gems/mysql-2.7/lib/mysql.bundle
/usr/local/lib/ruby/gems/1.8/gems/mysql-2.7/lib/mysql.bundle
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
`require'
...

The only way I can get around this is to add the old mysql.rb file to
your RAILS_ROOT/lib folder (the one that was removed from edge rails).

This really bugs me though because I have to do this for every checkout,
every branch and I need to remember to not commit it.

If anyone has a real solution it would be very helpful!

Jose Fernandez wrote:
> Out of nowhere I'm starting to get this error message when trying to
> access the DB (currently at rails edge):
>
> jose@macbook [~/Development/clients/sequoyah] $ rake db:create
> (in /Users/jose/Development/clients/sequoyah)
> !!! 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!
> Failed to lookup Init function
> /usr/local/lib/ruby/site_ruby/1.8/i686-darwin9.3.0/mysql.bundle
>
> (See full trace by running task with --trace)
>
> I've already re-installed the mysql gem a million times (uninstall and
> reinstall) and I still get this, any ideas?
6638d6f5855bfd97eb0b99ea31d173b2?d=identicon&s=25 Justin Halsall (juice10)
on 2008-08-14 11:04
And you also need to edit the mysql_adapter.rb file line 63
change the line into:
          require RAILS_ROOT + "/lib/mysql.rb"

Justin Halsall wrote:
> The only way I can get around this is to add the old mysql.rb file to
> your RAILS_ROOT/lib folder (the one that was removed from edge rails).
033480d49e4bd62e4f925748b14da745?d=identicon&s=25 Weng Edgar (edgarw)
on 2008-11-26 14:32
you can go to  http://www.tmtm.org/en/ruby/mysql/ to download the tar
file, and run the command below

# ruby ./install.rb

to install the mysql.rb
4d1a1cc1fdf4d82a2b91b733de5548d8?d=identicon&s=25 JoeMSak (Guest)
on 2008-11-26 18:25
(Received via mailing list)
This worked for me.

Thanks.


On Nov 26, 8:32 am, Weng Edgar <rails-mailing-l...@andreas-s.net>
16b4fdc83c35267ed8a5d39ee56cc978?d=identicon&s=25 Shawn Cheatham (shawnc)
on 2008-12-11 02:27
Weng Edgar wrote:
> you can go to  http://www.tmtm.org/en/ruby/mysql/ to download the tar
> file, and run the command below
>
> # ruby ./install.rb
>
> to install the mysql.rb

Just learning so hang with me. I downloaded, unzipped and in terminal
ran # ruby ./install.rb which returned a new command line. Is there a
specific location the folder should sit in before the install command is
entered or a directory I should be in first?

Thanks in advance
6ef8cb7cd7cd58077f0b57e4fa49a969?d=identicon&s=25 Brian Hogan (Guest)
on 2008-12-11 14:15
(Received via mailing list)
You get around this by actually installing the MySQL gem with C
bindings. The one you guys are talking about is the pure Ruby one.

 The pure-MySQL library is terrible for performance and can cause some
seriously flaky stuff. There are a number of posts on tis list that
discuss the installation of that library.

If you're getting the error relating to

/usr/local/lib/ruby/gems/1.8/gems/mysql-2.7/lib/mysql.bundle

then you have a half-installed mysql driver and I bet you're on a Mac.

The solution that worked for me was to do this:

http://www.napcsweb.com/blog/2007/06/01/mysql-gem-on-osx/

I hope that helps!

On Wed, Dec 10, 2008 at 7:27 PM, Shawn Cheatham
16b4fdc83c35267ed8a5d39ee56cc978?d=identicon&s=25 Shawn Cheatham (shawnc)
on 2008-12-12 00:48
Thanks for the help - after a bit of onsite help I was able to complete
the install. Still some quirks to be worked out but that's the
point...to tinker.

Thanks again

Brian Hogan wrote:
> You get around this by actually installing the MySQL gem with C
> bindings. The one you guys are talking about is the pure Ruby one.
>
>  The pure-MySQL library is terrible for performance and can cause some
> seriously flaky stuff. There are a number of posts on tis list that
> discuss the installation of that library.
>
> If you're getting the error relating to
>
> /usr/local/lib/ruby/gems/1.8/gems/mysql-2.7/lib/mysql.bundle
>
> then you have a half-installed mysql driver and I bet you're on a Mac.
>
> The solution that worked for me was to do this:
>
> http://www.napcsweb.com/blog/2007/06/01/mysql-gem-on-osx/
>
> I hope that helps!
>
> On Wed, Dec 10, 2008 at 7:27 PM, Shawn Cheatham
05c3f39db309047f28628a223a757bec?d=identicon&s=25 Hans Marmolin (marmolin)
on 2009-01-22 18:09
(Received via mailing list)
I have installed rails 2.2.2 (had 2.0.1) and the mysql performance is
very bad compared to earlier
I takes me 10 minutes to load data into a mysql database. With 2.0.1
it took less than 4 minutes
The amount of save and creating operations is indicated of that the
log file is about 2.7 MB
I have tried to install mysql gem as proposed.

I first uninstalled mysql by
sudo gem uninstall mysql
I then installed it again with
 sudo env ARCHFLAGS="-arch i386" gem install mysql --   --with-mysql-
dir=/usr/local/mysql --with-mysql-lib=/usr/local/mysql/lib   --with-
mysql-include=/usr/local/mysql/include

but there is now change in performance
I have Mysql 5.051, gem 1.3.1 ruby 1.8.6 rails 2.2.2

Appriciate any helps!!!!!

On 12 Dec 2008, 00:48, Shawn Cheatham <rails-mailing-l...@andreas-
E1b1706c1794a3732242df21b768cb4b?d=identicon&s=25 Nate Leavitt (nateleavitt)
on 2009-01-22 20:59
This way has worked everytime for me.  Make sure the path is correct in
your environment.

sudo gem install mysql --
--with-mysql-config=/usr/local/mysql/bin/mysql_config
E1d7bafd1a720b110c0bb949fb0b5dd7?d=identicon&s=25 Jules (Guest)
on 2009-04-18 01:30
(Received via mailing list)
Jumpin Jahoosefats Nate... this worked! Thanks very much!

On Jan 22, 3:59 pm, Nate Leavitt <rails-mailing-l...@andreas-s.net>
003e8514b6720bd8d065d07494eb1803?d=identicon&s=25 Marcos Ramos (Guest)
on 2009-04-20 22:33
(Received via mailing list)
Hi there Nate,

That solution didn't work for me with rails 2.3.2
I get - invalid option for --with-mysql-config...

On Jan 22, 8:59 pm, Nate Leavitt <rails-mailing-l...@andreas-s.net>
Please log in before posting. Registration is free and takes only a minute.
Existing account

NEW: Do you have a Google/GoogleMail, Yahoo or Facebook account? No registration required!
Log in with Google account | Log in with Yahoo account | Log in with Facebook account
No account? Register here.