[PHP-INSTALL] “libmysqlclient.so.16: cannot open shared object ” when installing PHP

thomas Armstrong <[email protected]> Wed, 15 Jun 2016 20:07:25 +0200
Newsgroups gmane.comp.php.install
Message-ID <CAKgEBPS6FUshOG++hEe9LEozOaSDPdRMRz-ky-RgB4YchoTegw@mail.gmail.com>
--001a11415ee2754c36053554fe0d
Content-Type: text/plain; charset=UTF-8

Hi.

Trying to install PHP 5.2.17 (with MySQL 5.1.55) on a Linux box:

---------
# ./configure --prefix=/usr/local/php
--with-apxs2=/usr/local/apache2/bin/apxs --with-mysql=/usr/local/mysql
-----------

I get this error within my 'debug.log' file:
---------------
CONFIGURE:   './configure'  '--prefix=/usr/local/php'
'--with-apxs2=/usr/local/apache2/bin/apxs' '--with-mysql=/usr/local/mysql'
CC:         gcc
CFLAGS:     -I/usr/include -g -O2
CPPFLAGS:
CXX:
CXXFLAGS:
INCLUDES:    -I/home/pi/lampsources/php-5.2.17/ext/date/lib
-I/usr/include/libxml2 -I/usr/local/mysql/include/mysql
LDFLAGS:    -L/usr/lib  -R/usr/local/mysql/lib/mysql
-L/usr/local/mysql/lib/mysql
LIBS:       -lcrypt -lrt -lmysqlclient -lrt -lresolv -lm -ldl -lnsl  -lxml2
-lxml2 -lxml2 -lcrypt
DLIBS:
SAPI:       apache2handler
PHP_RPATHS:  /usr/local/mysql/lib/mysql
uname -a:   Linux raspberrypi 4.4.9+ #884 Fri May 6 17:25:37 BST 2016
armv6l GNU/Linux

gcc -o conftest -I/usr/include -g -O2  -L/usr/lib
-R/usr/local/mysql/lib/mysql -L/usr/local/mysql/lib/mysql conftest.c
-lcrypt -lrt -lmysqlclient -lrt -lresolv -lm -ldl -lnsl  -lxml2 -lxml2
-lxml2 -lcrypt 1>&5
conftest.c: In function 'main':
conftest.c:3:3: warning: incompatible implicit declaration of built-in
function 'exit'
   exit(0);
   ^
./conftest: error while loading shared libraries: libmysqlclient.so.16:
cannot open shared object file: No such file or directory
--------------------

If I browse '/usr/local/mysql/include/mysql' contents:
----------
# cd /usr/local/mysql/lib/mysql
# ls -l
total 11736
-rw-r--r-- 1 root staff    7450 Jun  7 22:27 libdbug.a
-rw-r--r-- 1 root staff  521222 Jun  7 22:28 libheap.a
-rw-r--r-- 1 root staff 2438930 Jun  7 22:28 libmyisam.a
-rw-r--r-- 1 root staff  735778 Jun  7 22:28 libmyisammrg.a
-rw-r--r-- 1 root staff 1762244 Jun  7 22:27 libmysqlclient.a
-rwxr-xr-x 1 root staff    1013 Jun  7 22:27 libmysqlclient.la
lrwxrwxrwx 1 root staff      24 Jun  7 22:27 libmysqlclient.so ->
libmysqlclient.so.16.0.0
lrwxrwxrwx 1 root staff      24 Jun  7 22:27 libmysqlclient.so.16 ->
libmysqlclient.so.16.0.0
-rwxr-xr-x 1 root staff 1219344 Jun  7 22:27 libmysqlclient.so.16.0.0
-rw-r--r-- 1 root staff 1835708 Jun  7 22:27 libmysqlclient_r.a
-rwxr-xr-x 1 root staff    1067 Jun  7 22:27 libmysqlclient_r.la
lrwxrwxrwx 1 root staff      26 Jun  7 22:27 libmysqlclient_r.so ->
libmysqlclient_r.so.16.0.0
lrwxrwxrwx 1 root staff      26 Jun  7 22:27 libmysqlclient_r.so.16 ->
libmysqlclient_r.so.16.0.0
-rwxr-xr-x 1 root staff 1267368 Jun  7 22:27 libmysqlclient_r.so.16.0.0
-rw-r--r-- 1 root staff  781372 Jun  7 22:27 libmystrings.a
-rw-r--r-- 1 root staff 1380062 Jun  7 22:27 libmysys.a
-rw-r--r-- 1 root staff   35420 Jun  7 22:28 libvio.a
drwxr-sr-x 2 root staff    4096 Jun  7 22:28 plugin
--------------

What am I doing wrong? I run 'ldconfig' after installing MySQL from sources.

Thank you very much in advance.

--001a11415ee2754c36053554fe0d
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"" itemprop=3D"text">Hi.<br><br>Trying to ins=
tall PHP 5.2.17 (with MySQL 5.1.55) on a Linux box:<br><br>---------<br># .=
/configure --prefix=3D/usr/local/php --with-apxs2=3D/usr/local/apache2/bin/=
apxs --with-mysql=3D/usr/local/mysql<br>-----------<br><br>I get this error=
 within my &#39;debug.log&#39; file:<br>---------------<br>CONFIGURE:=C2=A0=
=C2=A0 &#39;./configure&#39;=C2=A0 &#39;--prefix=3D/usr/local/php&#39; &#39=
;--with-apxs2=3D/usr/local/apache2/bin/apxs&#39; &#39;--with-mysql=3D/usr/l=
ocal/mysql&#39;<br>CC:=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 gcc<=
br>CFLAGS:=C2=A0=C2=A0=C2=A0=C2=A0 -I/usr/include -g -O2<br>CPPFLAGS:<br>CX=
X:<br>CXXFLAGS:<br>INCLUDES:=C2=A0=C2=A0=C2=A0 -I/home/pi/lampsources/php-5=
.2.17/ext/date/lib -I/usr/include/libxml2 -I/usr/local/mysql/include/mysql<=
br>LDFLAGS:=C2=A0=C2=A0=C2=A0 -L/usr/lib=C2=A0 -R/usr/local/mysql/lib/mysql=
 -L/usr/local/mysql/lib/mysql<br>LIBS:=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =
-lcrypt -lrt -lmysqlclient -lrt -lresolv -lm -ldl -lnsl=C2=A0 -lxml2 -lxml2=
 -lxml2 -lcrypt<br>DLIBS:<br>SAPI:=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 apac=
he2handler<br>PHP_RPATHS:=C2=A0 /usr/local/mysql/lib/mysql<br>uname -a:=C2=
=A0=C2=A0 Linux raspberrypi 4.4.9+ #884 Fri May 6 17:25:37 BST 2016 armv6l =
GNU/Linux<br><br>gcc -o conftest -I/usr/include -g -O2=C2=A0 -L/usr/lib=C2=
=A0 -R/usr/local/mysql/lib/mysql -L/usr/local/mysql/lib/mysql conftest.c -l=
crypt -lrt -lmysqlclient -lrt -lresolv -lm -ldl -lnsl=C2=A0 -lxml2 -lxml2 -=
lxml2 -lcrypt 1&gt;&amp;5<br>conftest.c: In function &#39;main&#39;:<br>con=
ftest.c:3:3: warning: incompatible implicit declaration of built-in functio=
n &#39;exit&#39;<br>=C2=A0=C2=A0 exit(0);<br>=C2=A0=C2=A0 ^<br>./conftest: =
error while loading shared libraries: libmysqlclient.so.16: cannot open sha=
red object file: No such file or directory<br>--------------------<br><br>I=
f I browse &#39;/usr/local/mysql/include/mysql&#39; contents:<br>----------=
<br># cd /usr/local/mysql/lib/mysql<br># ls -l<br>total 11736<br>-rw-r--r--=
 1 root staff=C2=A0=C2=A0=C2=A0 7450 Jun=C2=A0 7 22:27 libdbug.a<br>-rw-r--=
r-- 1 root staff=C2=A0 521222 Jun=C2=A0 7 22:28 libheap.a<br>-rw-r--r-- 1 r=
oot staff 2438930 Jun=C2=A0 7 22:28 libmyisam.a<br>-rw-r--r-- 1 root staff=
=C2=A0 735778 Jun=C2=A0 7 22:28 libmyisammrg.a<br>-rw-r--r-- 1 root staff 1=
762244 Jun=C2=A0 7 22:27 libmysqlclient.a<br>-rwxr-xr-x 1 root staff=C2=A0=
=C2=A0=C2=A0 1013 Jun=C2=A0 7 22:27 <a href=3D"http://libmysqlclient.la">li=
bmysqlclient.la</a><br>lrwxrwxrwx 1 root staff=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0 24 Jun=C2=A0 7 22:27 libmysqlclient.so -&gt; libmysqlclient.so.16.0.0<b=
r>lrwxrwxrwx 1 root staff=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 24 Jun=C2=A0 7 22:2=
7 libmysqlclient.so.16 -&gt; libmysqlclient.so.16.0.0<br>-rwxr-xr-x 1 root =
staff 1219344 Jun=C2=A0 7 22:27 libmysqlclient.so.16.0.0<br>-rw-r--r-- 1 ro=
ot staff 1835708 Jun=C2=A0 7 22:27 libmysqlclient_r.a<br>-rwxr-xr-x 1 root =
staff=C2=A0=C2=A0=C2=A0 1067 Jun=C2=A0 7 22:27 <a href=3D"http://libmysqlcl=
ient_r.la">libmysqlclient_r.la</a><br>lrwxrwxrwx 1 root staff=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0 26 Jun=C2=A0 7 22:27 libmysqlclient_r.so -&gt; libmysqlc=
lient_r.so.16.0.0<br>lrwxrwxrwx 1 root staff=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =
26 Jun=C2=A0 7 22:27 libmysqlclient_r.so.16 -&gt; libmysqlclient_r.so.16.0.=
0<br>-rwxr-xr-x 1 root staff 1267368 Jun=C2=A0 7 22:27 libmysqlclient_r.so.=
16.0.0<br>-rw-r--r-- 1 root staff=C2=A0 781372 Jun=C2=A0 7 22:27 libmystrin=
gs.a<br>-rw-r--r-- 1 root staff 1380062 Jun=C2=A0 7 22:27 libmysys.a<br>-rw=
-r--r-- 1 root staff=C2=A0=C2=A0 35420 Jun=C2=A0 7 22:28 libvio.a<br>drwxr-=
sr-x 2 root staff=C2=A0=C2=A0=C2=A0 4096 Jun=C2=A0 7 22:28 plugin<br>------=
--------<br><br>What am I doing wrong? I run &#39;ldconfig&#39; after insta=
lling MySQL from sources.<br><br>Thank you very much in advance.<br></div><=
/div>

--001a11415ee2754c36053554fe0d--