Gem install mysql error

ruby-talk
1

gem install mysql

generates this errors:

ruby extconf.rb install mysql
checking for mysql_query() in mysqlclient.lib... no
hecking for main() in m.lib... yes
checking for mysql_query() in mysqlclient.lib... no
checking for main() in z.lib... no
checking for mysql_query() in mysqlclient.lib... no
checking for main() in socket.lib... no
checking for mysql_query() in mysqlclient.lib... no
checking for main() in nsl.lib... no
checking for mysql_query() in mysqlclient.lib... no

Both in Linux and in Windows.

Any idea?

Thanks in advance. JC

2

Do you have the mysql client libraries installed?

···

On Dec 20, 2005, at 6:22 AM, javachallenge@gmail.com wrote:

gem install mysql

generates this errors:

ruby extconf.rb install mysql
checking for mysql_query() in mysqlclient.lib... no
hecking for main() in m.lib... yes
checking for mysql_query() in mysqlclient.lib... no
checking for main() in z.lib... no
checking for mysql_query() in mysqlclient.lib... no
checking for main() in socket.lib... no
checking for mysql_query() in mysqlclient.lib... no
checking for main() in nsl.lib... no
checking for mysql_query() in mysqlclient.lib... no

Both in Linux and in Windows.

Any idea?

Thanks in advance. JC

3

Try this (Debian, Ubuntu):

# aptitude install libmysqlclient16-dev

···

--
Posted via http://www.ruby-forum.com/.

4

Aleksi K. wrote in post #1005603:

I solved the problem by using 'ruby-mysql' gem instead of 'mysql'

Thanks Aleksi. This solved my problem. (I'm using Mac 10.6.8)

Regarding MAMP...

And by the way, I tried to use rails and passenger with MAMP and it was
really pain in the ass and won't recommend it.

... I decided to try to get things to work with MAMP and I was able to
get is up and running. Here's how. I installed the ruby-mysql gem with
the following configuration. (NO LINE BREAKS)

sudo gem install ruby-mysql --
--with-mysql-config=/Applications/MAMP/Library/bin/mysql_config
--with-mysql-dir=/Applications/MAMP/db/mysql
--with-mysql-lib=/Applications/MAMP/Library/bin/
--with-mysql-include=/Applications/MAMP/Library/bin/

This should install correctly, but your app will then give you a error
reading:

No such file or directory - /tmp/mysql.sock

Correct this error by specifying the socket in your database.yml file:

production:
  adapter: mysql
  encoding: utf8
  ...
  socket: /Applications/MAMP/tmp/mysql/mysql.sock

Restart the app:
$: touch tmp/restart.txt

And that worked for me.

···

--
Posted via http://www.ruby-forum.com/\.

5

Caleb Tennis wrote:

Do you have the mysql client libraries installed?

I have mysql server installed. Where do I get the "client" libraries?
Do I need to gem install mysql to use Rails?

Thanks.

6

Marcin Biegun wrote in post #977203:

Try this (Debian, Ubuntu):

# aptitude install libmysqlclient16-dev

This worked for me.
- Ubuntu 10.04
- Ruby 1.9.2
- Rails 2.3.14

···

--
Posted via http://www.ruby-forum.com/\.

7

Java,

I've had similar problems on Ubuntu. However, luckily Ubuntu provides a
package called rubymysql (or something like that) which does the trick,
and I assume there is a .deb and a .rpm for it.

I installed the client libraries and it still didn't help on my linux
box. A bit frustrating, honestly. But, I finally did get it working.
Its worth it!

-hampton.

8

you dont need to install the mysql gem for rails... just configure
databases.yml (i believe is the file)

···

On 12/20/05, Hampton <hcatlin@gmail.com> wrote:

Java,

I've had similar problems on Ubuntu. However, luckily Ubuntu provides a
package called rubymysql (or something like that) which does the trick,
and I assume there is a .deb and a .rpm for it.

I installed the client libraries and it still didn't help on my linux
box. A bit frustrating, honestly. But, I finally did get it working.
Its worth it!

-hampton.

9

Thank you guys. I will try once I get home and let you know.