mysql install problem

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

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")'

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

Manisha Tripathy wrote:

Have you installed mysql-client?

Yes I have...

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:

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

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

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

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.

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

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.

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