php configure: cannot find libmysqlclient

neocontrol · 09-07-2007, 10:18 AM

Never mind this. I just removed the --with-lib-dir option.

This is really an annoying issue, as I run into this every time, and I continue to have to come up with different solutions. This time, I'm stuck.

I'm trying to get apache / php / mysql working.
I installed apache with no issues.
I downloaded the lastest mysql rpms as well, and install those.

So here I am installing php with these terms:

Code:

./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-libdir=/usr/lib/mysql --with-mysql --with-mysqli --with-mcrypt=/usr/local --with-pear=/usr/local/apache2/php --with-bz2=/usr --enable-sockets --enable-dbx --enable-dbase --with-zlib --enable-mbstring --with-curl=/usr/local/bin/

And here's what it spits out at me at the end of the configure:

Code:

checking for MING support... no
checking for mSQL support... no
checking for MSSQL support via FreeTDS... no
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
configure: error: Cannot find libmysqlclient under /usr.
Note that the MySQL client library is not bundled anymore!

Here's the output of ldconfig which only has one /usr listed.

Code:

ldconfig -v |grep mysql
        libmysqlclient_r.so.15 -> libmysqlclient_r.so.15.0.0
        libmysqlclient_r.so.14 -> libmysqlclient_r.so.14.0.0
        libmysqlclient.so.10 -> libmysqlclient.so.10.0.0
        libmysqlclient.so.15 -> libmysqlclient.so.15.0.0
        libmysqlclient_r.so.10 -> libmysqlclient_r.so.10.0.0
        libmysqlclient.so.14 -> libmysqlclient.so.14.0.0
        libmysqlclient_r.so.12 -> libmysqlclient_r.so.12.0.0
        libmysqlclient.so.12 -> libmysqlclient.so.12.0.0

Need anything else from me to help? I'm pretty much totally lost on this one.

trickykid · 09-07-2007, 02:56 PM

Probably just a path issue. But removing apparently works, but you'll want to make sure this didn't break any functionality for PHP with a MySQL database as well.

arunr@caltech.edu · 02-03-2009, 12:43 AM

When I tried to run configure of PHP-5.2.8 (after installing MySQL-community 5.1.30) using

$./configure --with-mysql=/usr/bin/

I had the following problem:
---
checking for MySQL UNIX socket location... no
configure: error: Cannot find libmysqlclient under /usr.
Note that the MySQL client library is not bundled anymore!
---

Then I saw that libmysql client was in /usr/lib64/ instead of /usr/lib/. So the right way to run configure is:

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

Hope that helps!

(Hey, PHP guys who wrote the configure script: why not include check on /usr/lib64/ as well?)

augustofagioli · 11-17-2009, 04:52 AM

this works fine on my php on opensuse 11.2

grob115 · 07-04-2010, 10:11 AM

Brilliant! The "--with-libdir=lib64" is what solved the problem, after downloading the devel RPM.

UltraPain · 03-02-2011, 06:08 PM

To arunr@caltech.edu...THANK YOU. Five years later this post STILL has value! Two hours of trying to get this to configure, and your suggestion saved me. Hopefully you are still a member, and hopefully you get this thanks!!!

Cheers,
Dave

GarrathE · 06-05-2011, 02:01 PM

This, like the last poster, has been a life saver for me. What a fantastic long life posting from ARUNR in 2009.

iforce2d · 07-15-2011, 12:31 AM

Excellent! I'm another one helped by this thread, arunr's was indeed the correct fix.

I have to admit I did spend about 15 minutes before noticing the correct option is --with-libdir NOT --with-lib-dir as in the first line of the first post in the thread.

justin69 · 07-27-2012, 03:14 AM

Quote:

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

Hope that helps!

I only added: --with-libdir=lib64

This helped me! Now it works! Thank you so much!

lasantha86 · 11-24-2012, 07:22 AM

You might have to actually find the location of libmysqlclient by doing a "locate libmysqlclient" or similar. I stumbled upon this via this stackoverflow question (http://stackoverflow.com/questions/1...urce-on-ubuntu).

For Ubuntu Precise, I had to use "--with-libdir=/lib/x86_64-linux-gnu". But arunr's answer helped me too by pointing me in the right direction! Thank you very much!!

jalal7h · 11-27-2015, 06:48 AM

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

Worked for me too.

Thanks!