Problems with MySQL Installation

Hello:

I am trying to get rails up and running with mysql for a redmine
installation. When I try to install the mysql gem, I get the following:

h1605521:/ # gem install mysql
Building native extensions. This could take a while…
ERROR: Error installing mysql:
ERROR: Failed to build gem native extension.

/usr/bin/ruby extconf.rb install mysql
checking for mysql_ssl_set()… no
checking for rb_str_set_len()… no
checking for rb_thread_start_timer()… no
checking for mysql.h… no
checking for mysql/mysql.h… 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=/usr/bin/ruby
–with-mysql-config
–without-mysql-config

Gem files will remain installed in
/usr/lib/ruby/gems/1.8/gems/mysql-2.8.1 for inspection.
Results logged to
/usr/lib/ruby/gems/1.8/gems/mysql-2.8.1/ext/mysql_api/gem_make.out

Tried already to find the solution reading other related posts here in
the forum - no cuccess so far.

Has anybody any idea ? Any help is very much appreciated. Thanks

I borrow this thread because I have the same problem but with sqlite3.


checking for sqlite3.h… no
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers.

I tried to fix it by downloading the source code for sqlite from
http://www.sqlite.org/ and installing it. Now i have the sqlite3.h
header file and tried again with

gem install sqlite3-ruby –
–with-sqlite3-dir=/my/sqlite/path/sqlite-3.6.17

The sqlite3.h file is in that directory but I get the same errors
again…

Do you really have sqlite3 installed? What happens when you type:
which sqlite3

i.e.: which sqlite3
/opt/local/bin/sqlite3

On my system I would then install the gem using:

gem install sqlite3-ruby – --with-sqlite3-include=/opt/local/include
–with-sqlite3-lib=/opt/local/lib

On Aug 29, 10:12 am, Joonas Lindholm <rails-mailing-l…@andreas-

Do you have mysql installed? What happens when you type: mysql –
version

i.e.: mysql --version
mysql Ver 14.14 Distrib 5.1.31, for apple-darwin9.5.0 (powerpc) using
readline 5.1

How about when you type: which mysql_config

i.e.: which mysql_config
/usr/local/mysql/bin/mysql_config

Assuming you have mysql installed, you can install the mysql gem by
typing:

gem install mysql --with-mysql-config=/usr/local/mysql/bin/
mysql_config

NOTE: substitute your path to mysql_config for mine here.

If you don’t have mysql installed, go to http://www.mysql.com/ and
follow the download instructions for your system.

On Aug 29, 5:57 am, Albrecht Backhaus <rails-mailing-l…@andreas-

Rick Lloyd wrote:

Do you have mysql installed?

Yes

What happens when you type: mysql --> version

mysql Ver 14.12 Distrib 5.0.67, for suse-linux-gnu (i686) using
readline 5.2

How about when you type: which mysql_config

i.e.: which mysql_config
/usr/local/mysql/bin/mysql_config

Assuming you have mysql installed, you can install the mysql gem by
typing:

gem install mysql --with-mysql-config=/usr/local/mysql/bin/
mysql_config

NOTE: substitute your path to mysql_config for mine here.

When I try this I get the follwing error:

h1605521:~ # gem install mysql --with-mysql-config=/usr/bin/mysql_config
ERROR: While executing gem … (OptionParser::InvalidOption)
invalid option: --with-mysql-config=/usr/bin/mysql_config

I checked more than twice for typos - can’t see

Any other idea ?