RE: *** MySQL library could not be located... ****

[symphonynagios]

Hi,

We have checked and followed all the 4 steps but still error persists.

[jdalrymple]

Try:

Code: Select all

./configure --with-mysql=/usr/lib64/mysql

Erased and re-installed and configured by ./configure --with-mysql=/usr/lib64/mysql

This is a my bad, I'm sorry...

Try THIS:

Code: Select all

./configure --with-mysql-lib=/usr/lib64/mysql/

[symphonynagios]

No Luck,, Its throwing the same ERROR.

[symphonynagios]

checking for mysql_init in -lmysqlclient... no


*** MySQL library could not be located... **************************

[tgriep]

Could you run the following and post the output here?

Code: Select all

ll /etc/ld.so.conf.d
cat /etc/ld.so.conf.d/*

[symphonynagios]

[rpadakannaya@lnx0035 /]$ ll /etc/ld.so.conf.d
total 48
-rw-r--r-- 1 root root 17 Mar 20 2012 atlas-x86_64.conf
-r--r--r-- 1 root root 324 Oct 16 2012 kernel-2.6.32-279.11.1.el6.x86_64.conf
-r--r--r-- 1 root root 324 Nov 6 2012 kernel-2.6.32-279.14.1.el6.x86_64.conf
-r--r--r-- 1 root root 324 Dec 19 2012 kernel-2.6.32-279.19.1.el6.x86_64.conf
-r--r--r-- 1 root root 324 Aug 14 2012 kernel-2.6.32-279.5.1.el6.x86_64.conf
-r--r--r-- 1 root root 324 Aug 23 2012 kernel-2.6.32-279.5.2.el6.x86_64.conf
-rw-r--r-- 1 root root 16 May 12 05:01 myapp.conf
-rw-r--r-- 1 root root 17 May 12 04:59 mysql.conf
-rw-r--r-- 1 root root 17 Dec 7 2012 mysql-x86_64.conf.back
-rw-r--r-- 1 root root 22 Sep 23 2011 qt-x86_64.conf
-rw-r--r-- 1 root root 276 Sep 26 2011 vmware-tools-libraries.conf
-rw-r--r-- 1 root root 23 Jan 8 2013 xulrunner-64.conf

cat /etc/ld.so.conf.d/*
/usr/local/lib
/usr/lib64/mysql
/usr/lib64/mysql
/usr/lib64/qt-3.3/lib
/usr/lib/vmware-tools/lib32/libvmGuestLib.so
/usr/lib/vmware-tools/lib64/libvmGuestLib.so
/usr/lib/vmware-tools/lib32/libvmGuestLibJava.so
/usr/lib/vmware-tools/lib64/libvmGuestLibJava.so
/usr/lib/vmware-tools/lib32/libDeployPkg.so
/usr/lib/vmware-tools/lib64/libDeployPkg.so
/usr/lib64/xulrunner-2

[tgriep]

Could you run the following command and post the output?

Code: Select all

mysql_config

[symphonynagios]

Hi Could you please provide option because am getting output as below.
lnx0035:root# /usr/bin/mysql_config
Usage: /usr/bin/mysql_config [OPTIONS]
Options:
--cflags [-I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -fasynchronous-unwind-tables -fPIC -g -fabi-version=2 -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FASTMUTEX=1]
--cxxflags [-I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -fasynchronous-unwind-tables -felide-constructors -fPIC -Wno-unused-parameter -g -fabi-version=2 -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FASTMUTEX=1]
--include [-I/usr/include/mysql]
--libs [-L/usr/lib -lmysqlclient -lpthread -lm -lrt -ldl]
--libs_r [-L/usr/lib -lmysqlclient_r -lpthread -lm -lrt -ldl]
--plugindir [/usr/lib/mysql/plugin]
--socket [/var/lib/mysql/mysql.sock]
--port [0]
--version [5.6.10]
--libmysqld-libs [-L/usr/lib -lmysqld -lpthread -lm -lrt -lcrypt -ldl -laio]
--variable=VAR VAR is one of:
pkgincludedir [/usr/include/mysql]
pkglibdir [/usr/lib]
plugindir [/usr/lib/mysql/plugin]
lnx0035:root#

[tgriep]

I think the issue is that the system has both the 32 bit and 64 bit versions of MYSQL installed on it. To fix it, we need to determine if the system is 32 or 64 bit and remove the unneeded versions.
Can you run the following and post back the results?

Code: Select all

uname -a
cat /etc/*release

[symphonynagios]

lnx0035:root# uname -a
Linux lnx0035.ch3.prod.i.com 2.6.32-279.19.1.el6.x86_64 #1 SMP Wed Dec 19 07:05:20 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
lnx0035:root# cat /etc/*release
CentOS release 6.4 (Final)
CentOS release 6.3 (Final)
Template Name = TMPL_CENTOS-6.3_x64_0113
CentOS release 6.4 (Final)
CentOS release 6.4 (Final)
lnx0035:root#