Technology Errors

MySQL Gem Install ERROR: Failed to build gem native extension

You may run into issues installing the mysql gem on a Linux server running a 64-bit version of MySQL server. When attempting to install the gem its likely you will get errors if you don’t specify a couple options when running the command. The issue I continued to have was the options are clearly listed out and I felt, because of previous issues with 64-bit applications being installed, that I was using the proper options to move past the errors I was seeing. What I finally figured out was the fact that an extra “–” was required in front of the options.

Below I show the error in detail which will then be followed by the command to issue for a successful installation of the MySQL gem on CentOS (should work with any Linux server) running mysql-server.x86_64 or the 64 bit version of mysql-server instead of the 32 bit mysql-server or mysql-server.i386.

Technology Errors

checking for mysql_close in -lmysqlclient… no

I received the below error when attempting to compile PHP to use with Litespeed as an LSAPI module. The error was related to multiple versions of numerous MySQL RPM packages being installed.

PHP Compile Error:
checking for MySQL support… yes
checking for specified location of the MySQL UNIX socket… no
checking for MySQL UNIX socket location… /var/lib/mysql/mysql.sock
checking for mysql_close in -lmysqlclient… no
checking for mysql_errno in -lmysqlclient… no

The PHP configure script was getting confused because of two 32-bit MySQL RPM packages being installed. If you look below this is the MySQL packages yum was showing installed on the server.