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