Bug #22323 Source-compiled MySQL 5.0.24a on x86_64 causes LAST PHP 5.1.6 configure failure

• Submitted: 13 Sep 2006 19:10
• Modified: 1 Jun 2007 8:49
• Reporter: Carlos Javier Alcala Helguero
• Status: No Feedback
• Category: MySQL Server: Compiling
• Severity: S3 (Non-critical)
• Version: 5.0.24a
• OS: Linux (FEDORA 5 x86_64)
• CPU Architecture: Any

[13 Sep 2006 19:10] Carlos Javier Alcala Helguero

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!

How to repeat:
./configure --with-mysql=<path/to/mysql> when MySQL is compiled from
source code onX86_64 SYSTEM

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!

Suggested fix:
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

[15 Sep 2006 8:43] Valeriy Kravchuk

Thank you for a problem report. Please, specify the exact ./configure command line used to compile 5.0.24a from sources. Our binaries are using lib64 for some versions already, as far as i remember.

[15 Sep 2006 14:16] Carlos Javier Alcala Helguero

Hello...

Just the simplest comand:

$ mkdir /usr/local/mysql
$ ./configure --prefix=/usr/local/mysql
make
make install

Thats all !!

[30 Mar 2007 12:30] Sveta Smirnova

Please try with MySQL 5.0.37 accessible from http://dev.mysql.com/downloads/mysql/5.0.html.

Also try ./configure --prefix=/usr/local/mysql --with-mysql=/usr/local/mysql

[30 Apr 2007 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

[1 May 2007 8:49] Valeriy Kravchuk

Feedback on 5.0.37 is still needed.

[1 Jun 2007 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".