mysql install problem

rubyonrails-talk
#1

Hi,

I got Mac OS X 15.6 installed, Locomotive 2.0.8 and MYSQL 5.0.67
running. I'm having this problem when I try to install mysql gem:

Last login: Mon Feb 9 13:37:37 on ttys001
source
/var/folders/be/bexGvm9pHdq0vcEmR8-WWk+++TM/-Tmp-//39E424DB-A260-4E41-AA2E-30B64FB46F3C-7395-00002254065EA712.environment.bash
You have mail.
MBPEduCirilo:~ eduardocirilo$ source
/var/folders/be/bexGvm9pHdq0vcEmR8-WWk+++TM/-Tmp-//39E424DB-A260-4E41-AA2E-30B64FB46F3C-7395-00002254065EA712.environment.bash
MBPEduCirilo:kshema098 eduardocirilo$ gem install mysqlBuilding native
extensions. This could take a while...ERROR: Error installing mysql:
  ERROR: Failed to build gem native extension.

/Applications/EdUtils/Locomotive2/Bundles/standardRailsSept2006.locobundle/i386/bin/ruby
extconf.rb install mysql
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lm... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lz... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lsocket... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lnsl... no
checking for mysql_query() in -lmysqlclient... no
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for more
details. You may need configuration options.

Provided configuration options:
  --with-opt-dir
  --without-opt-dir
  --with-opt-include
  --without-opt-include=${opt-dir}/include
  --with-opt-lib
  --without-opt-lib=${opt-dir}/lib
  --with-make-prog
  --without-make-prog
  --srcdir=.
  --curdir
  --ruby=/Applications/EdUtils/Locomotive2/Bundles/standardRailsSept2006.locobundle/i386/bin/ruby
  --with-mysql-config
  --without-mysql-config
  --with-mysql-dir
  --without-mysql-dir
  --with-mysql-include
  --without-mysql-include=${mysql-dir}/include
  --with-mysql-lib
  --without-mysql-lib=${mysql-dir}/lib
  --with-mysqlclientlib
  --without-mysqlclientlib
  --with-mlib
  --without-mlib
  --with-mysqlclientlib
  --without-mysqlclientlib
  --with-zlib
  --without-zlib
  --with-mysqlclientlib
  --without-mysqlclientlib
  --with-socketlib
  --without-socketlib
  --with-mysqlclientlib
  --without-mysqlclientlib
  --with-nsllib
  --without-nsllib
  --with-mysqlclientlib
  --without-mysqlclientlib

Gem files will remain installed in
/Applications/EdUtils/Locomotive2/Bundles/standardRailsSept2006.locobundle/i386/lib/ruby/gems/1.8/gems/mysql-2.7
for inspection.
Results logged to
/Applications/EdUtils/Locomotive2/Bundles/standardRailsSept2006.locobundle/i386/lib/ruby/gems/1.8/gems/mysql-2.7/gem_make.out
MBPEduCirilo:kshema098 eduardocirilo$

And when I type the rake command it shows:

MBPEduCirilo:kshema098 eduardocirilo$ rake db:migrate
(in /Users/eduardocirilo/Documents/WWW/kshema098)
Missing these required gems:
  mysql

You're running:
  ruby 1.8.4 at
/Applications/EdUtils/Locomotive2/Bundles/standardRailsSept2006.locobundle/i386/bin/ruby
  rubygems 1.3.1 at /Users/eduardocirilo/.gem/ruby/1.8,
/Applications/EdUtils/Locomotive2/Bundles/standardRailsSept2006.locobundle/i386/lib/ruby/gems/1.8

Run `rake gems:install` to install the missing gems.
MBPEduCirilo:kshema098 eduardocirilo$

What can I do to resolve this problem? I really need some help m8s.

Regards,
Ed

#2

your post says:
  'You're running: ruby 1.8.4'

while on ror.org is written:
  'We recommend Ruby 1.8.7 for use with Rails.'

1.8.4 should work, too. but to make sure it ain't a version-conflict,
i'd update.

other than that, did you follow this hint?:
  'OS X 10.5: Included with developer tools (then do "gem update
rails")'

#3

MaD wrote:

your post says:
  'You're running: ruby 1.8.4'

while on ror.org is written:
  'We recommend Ruby 1.8.7 for use with Rails.'

1.8.4 should work, too. but to make sure it ain't a version-conflict,
i'd update.

other than that, did you follow this hint?:
  'OS X 10.5: Included with developer tools (then do "gem update
rails")'

Hi MaD,

When I try to update it appens this:

MBPEduCirilo:kshema098 eduardocirilo$ gem update rails
Updating installed gems
Nothing to update

How can I update to Ruby 1.8.7? Is there another way?

Regards,
Ed

#4

Manisha Tripathy wrote:

Have you installed mysql-client?

Yes I have...

#5

If you're on an Intel mac, try this:

sudo env ARCHFLAGS="-arch i386" gem install mysql --
--with-mysql-dir=/usr/local/mysql
sudo ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql

Just be sure to get the mysql directories right to match your system
setup. These are the default for the MySQL binaries.

Brent

Eduardo Cirilo wrote:

#6

You're trying to update the rails framework, not ruby.

http://www.ruby-lang.org/en/downloads/

#7

^ make sure you'Re getting 1.8.7 (which is the latest stable). 1.9.1
still causes problems with some gems.

#8

Check here: http://foliosus.com/blog/howto-install-mysql-gem-on-leopard

Be sure to read the comments -- there is a fix in the comments for the
install command that might help you.

#9

you might also consider using sudo so it wont install in .gem

#10

I'm having the same issue except it happens when I simply do:

sudo gem install mysql

Does anyone know of a fix?

I've tried just about everything.

#11

I'm having the same issue except it happens when I simply do:

sudo gem install mysql

Does anyone know of a fix?

you need to tell the install scripts where the mysql libraries/headers
are (eg see the link Brent posted)

I've tried just about everything.

While I'm sure you may feel that way (I'm sure we can all empathise
with that) it's a singularly unhelpful thing to say, you could very
easily put off the person with the answer by making them think "oh,
he's probably already tried what I was going to suggest".

Fred