Page 2 of 3

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

Posted: Tue May 12, 2015 9:57 am
by symphonynagios
Hi,

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

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

Posted: Tue May 12, 2015 10:28 am
by jdalrymple
jdalrymple wrote:Try:

Code: Select all

./configure --with-mysql=/usr/lib64/mysql
symphonynagios wrote: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/

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

Posted: Wed May 13, 2015 6:19 am
by symphonynagios
No Luck,, Its throwing the same ERROR.

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

Posted: Wed May 13, 2015 7:56 am
by symphonynagios
checking for mysql_init in -lmysqlclient... no


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

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

Posted: Wed May 13, 2015 12:07 pm
by 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/*

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

Posted: Thu May 14, 2015 8:51 am
by 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

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

Posted: Thu May 14, 2015 1:47 pm
by tgriep
Could you run the following command and post the output?

Code: Select all

mysql_config

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

Posted: Tue May 19, 2015 4:43 am
by 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#

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

Posted: Tue May 19, 2015 12:02 pm
by 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

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

Posted: Wed May 20, 2015 4:14 am
by 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#