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
on 2005-12-20 13:24
on 2005-12-20 13:33
Do you have the mysql client libraries installed?
on 2005-12-20 14:39
Caleb T. 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.
on 2005-12-20 16:15
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.
on 2005-12-20 16:51
you dont need to install the mysql gem for rails... just configure databases.yml (i believe is the file)
on 2005-12-20 17:09
Thank you guys. I will try once I get home and let you know.
on 2011-01-24 20:03
Try this (Debian, Ubuntu): # aptitude install libmysqlclient16-dev
on 2011-06-16 10:51
I was struggling whole day with this problem and before this I got error about development tools not being installed despite I just installed latest Xcode. I'm using Mac OS X 10.6.7 and didn't found any similar commands like apt-get on linux to solve this problem. Anyway I solved the problem by using 'ruby-mysql' gem instead of 'mysql' gem and it works great! Just remember to add socket (default is /tmp/mysql.sock) and valid authentication information to database.yml (example socket: /path/to/socket/mysql.sock). 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. Instead use separate Apache and Mysql and you should be ballin'. I used mysql version 14.14 for osx10.6(i386), ruby version 1.92 and rails 3.0.7.
on 2011-10-04 09:59
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.
on 2012-01-06 19:48
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