Mysql install problem

dudus · February 9, 2009, 2:50pm

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

dudus · February 9, 2009, 3:24pm

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”)’

dudus · February 9, 2009, 3:56pm

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

dudus · February 9, 2009, 4:40pm

Have you installed mysql-client?

dudus · February 9, 2009, 11:08pm

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 C. wrote:

Manisha T. wrote:

Have you installed mysql-client?

Yes I have…

dudus · February 9, 2009, 11:19pm

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

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

On Feb 9, 6:56 am, Eduardo C. [email protected]

dudus · February 10, 2009, 8:44am

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

dudus · February 9, 2009, 6:23pm

Manisha T. wrote:

Have you installed mysql-client?

Yes I have…

dudus · February 10, 2009, 7:57pm

Hi,

I’m still having the problem…here what it says:

Run rake gems:install to install the missing gems.
MBPEduCirilo:kshema098 eduardocirilo$ rake gems:install
(in /Users/eduardocirilo/Desktop/kshema098)
gem install mysql
WARNING: Installing to ~/.gem since /opt/local/lib/ruby/gems/1.8 and
/opt/local/bin aren’t both writable.
WARNING: You don’t have /Users/eduardocirilo/.gem/ruby/1.8/bin in your
PATH,
gem executables will not run.
ERROR: Error installing mysql:
ERROR: Failed to build gem native extension.

/opt/local/bin/ruby extconf.rb install mysql
checking for mysql_query() in -lmysqlclient… no
checking for main() in -lm… yes
checking for mysql_query() in -lmysqlclient… no
checking for main() in -lz… yes
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=/opt/local/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
/Users/eduardocirilo/.gem/ruby/1.8/gems/mysql-2.7 for inspection.
Results logged to
/Users/eduardocirilo/.gem/ruby/1.8/gems/mysql-2.7/gem_make.out
Building native extensions. This could take a while…
Loaded suite /opt/local/bin/rake
Started

Finished in 0.000433 seconds.

0 tests, 0 assertions, 0 failures, 0 errors
MBPEduCirilo:kshema098 eduardocirilo$ rake db:migrate
(in /Users/eduardocirilo/Desktop/kshema098)
Missing these required gems:
mysql

You’re running:
ruby 1.8.7.72 at /opt/local/bin/ruby
rubygems 1.3.1 at /Users/eduardocirilo/.gem/ruby/1.8,
/opt/local/lib/ruby/gems/1.8

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

What must I do?

dudus · February 10, 2009, 8:02pm

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.

dudus · February 10, 2009, 11:07pm

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

On Tue, Feb 10, 2009 at 2:08 PM, Eduardo C. <

dudus · February 10, 2009, 8:08pm

Done !!!

What a lot of headache :S

Thanks for all m8s…

dudus · February 22, 2009, 12:17am

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.

On Feb 10, 1:57 pm, Eduardo C. [email protected]

dudus · February 22, 2009, 12:26am

On Feb 21, 6:55 pm, Tom M. [email protected] wrote:

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