Bug #36073 [Com]: Source-compiled MySQL on x86_64 causes PHP configure failure

Edit report at http://bugs.php.net/bug.php?id=36073&edit=1

 ID:               36073
 Comment by:       michael at michaelsnet dot us
 Reported by:      chris at spawnordie dot com
 Summary:          Source-compiled MySQL on x86_64 causes PHP configure
                   failure
 Status:           Wont fix
 Type:             Bug
 Package:          Compile Failure
 Operating System: Linux/Any
 PHP Version:      5.1.2

 New Comment:

IMHO this is a documentation bug.  Consider adding a README.64bit file
containing this information and other relevant information.


Previous Comments:
------------------------------------------------------------------------
[2006-01-18 23:53:50] [email protected]

Works fine for me.
Hint: Don't try building Mysql yourself if you don't know how to do it
properly. Use the binary packages provided by MySQL.
And last but not least: report this to MySQL. It's not our fault if they
do things wrong.

------------------------------------------------------------------------
[2006-01-18 22:14:10] chris at spawnordie dot com

Description:
------------
Please accept my apologies if this is already reported - I searched and
didn't find it.

When configuring PHP for x86_64, it is necessary to use:
--with-libdir=lib64

When you compile MySQL from source, it does not place its files in
lib64, but rather lib.

MySQL was configured using:
--prefix=/usr/local/mysql

Configuring PHP using:
--with-mysql=/usr/local/mysql
fails with this:
checking for MySQL support... yes
checking for specified location of the MySQL UNIX socket... no
checking for MySQL UNIX socket location... no
configure: error: Cannot find libmysqlclient under /usr/local/mysql.
Note that the MySQL client library is not bundled anymore!

This fixes the problem:
cd /usr/local/mysql
ln -s lib lib64

When PHP is configured using --with-mysql=<mysql_dir> and
--with-libdir=<lib_dir>, it should search <mysql_dir>/<lib_dir> and then
<mysql_dir>/lib

Reproduce code:
---------------
./configure --with-mysql=<path/to/mysql> when MySQL is compiled from
source code

Expected result:
----------------
successful configure

Actual result:
--------------
configure fails with:
checking for MySQL support... yes
checking for specified location of the MySQL UNIX socket... no
checking for MySQL UNIX socket location... no
configure: error: Cannot find libmysqlclient under /usr/local/mysql.
Note that the MySQL client library is not bundled anymore!



------------------------------------------------------------------------



-- 
Edit this bug report at http://bugs.php.net/bug.php?id=36073&edit=1