gem install mysql failed問題排除

• 環境：Linux Mint 17.1，Ubuntu通用

問題描述

---

執行gem install mysql時發生錯誤，無法成功安裝。




Building native extensions.  This could take a while...

ERROR:  Error installing mysql:

ERROR: Failed to build gem native extension.

    /usr/local/bin/ruby -r ./siteconf20150713-2895-yymyus.rb extconf.rb

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=/usr/local/bin/$(RUBY_BASE_NAME)

--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

原因

---

• checking for mysql_query() in -lmysqlclient... no   問題的主因
  
• 沒有安裝mysql client

解決方式

---

1. 執行 sudo apt-get install libmysqlclient-dev
2. 重新執行gem install mysql

Building native extensions.  This could take a while...

Successfully installed mysql-2.9.1

Parsing documentation for mysql-2.9.1

Installing ri documentation for mysql-2.9.1

Done installing documentation for mysql after 1 seconds

1 gem installed