#36073 [Opn->Bgs]: Source-compiled MySQL on x86_64 causes PHP configure failure

ID: 36073 Updated by: sniper@php.net Reported By: chris at spawnordie dot com -Status: Open +Status: Bogus Bug Type: Compile Failure Operating System: Linux/Any PHP Version: 5.1.2 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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/?id=36073&edit=1