安装mysql gem时出错

Question

安装日志：

Using launchy (2.3.0) 
Using libv8 (3.11.8.17)  
Installing mysql2 (0.3.11)  
Gem::Ext::BuildError: ERROR: Failed to build gem native extension. 

    /home/sanjay/.rvm/rubies/ruby-1.9.3-p484/bin/ruby extconf.rb  
checking for rb_thread_blocking_region()... yes 
checking for rb_wait_for_single_fd()... yes 
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... yes 
checking for mysql_query() in -lmysqlclient... no 
checking for main() in -lmygcc... 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=/home/sanjay/.rvm/rubies/ruby-1.9.3-p484/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 
    --with-mygcclib 
    --without-mygcclib 
    --with-mysqlclientlib 
    --without-mysqlclientlib 

extconf failed, exit code 1 

Gem files will remain installed in /home/sanjay/.rvm/gems/ruby-1.9.3-p484/gems /mysql2-0.3.11 for inspection. 
Results logged to /home/sanjay/.rvm/gems/ruby-1.9.3-p484/extensions/x86_64-linux/1.9.1 /mysql2-0.3.11/gem_make.out 

An error occurred while installing mysql2 (0.3.11), and Bundler cannot continue. 
Make sure that `gem install mysql2 -v '0.3.11'` succeeds before bundling. 

Answer 1

对于ubuntu，请使用以下命令：

sudo apt-get install libmysqlclient-dev libmysqlclient16 ruby-dev

sudo apt-get install libmysql-ruby libmysqlclient-dev

Answer 2

如果是在ubuntu debian系统上，请检查libmysql-ruby和libmysqlclient-dev库包。在ubuntu/debian系统上安装mysql2 gem是一个常见的问题。点击stackoverflow @ Error installing mysql2: Failed to build gem native extension链接

如果是在Mac系统上，通过查看问题中的错误日志，可能看起来是这样的，请访问解决方案@ Unable to install MySQL on Mac OS X的堆栈溢出链接