#29860 [Com]: Cannot compile with mysql and mysqli extensions

ID: 29860 Comment by: kpederson at mail dot ewu dot edu Reported By: rjanson at msn dot com Status: No Feedback Bug Type: Compile Failure Operating System: Redhat 9 PHP Version: 5.0.1 New Comment: I can confirm a few things. I have both the static and the shared libraries installed as they both come in the standard mysql-devel rpm: /usr/lib/libmysqlclient.so /usr/lib/libmysqlclient.so.14 /usr/lib/mysql /usr/lib/mysql/libmysqlclient.a /usr/lib/mysql/libmysqlclient_r.la /usr/lib/mysql/libmysqld.a /usr/lib/mysql/libmysqlclient_r.a /usr/lib/mysql/mysqld.sym /usr/lib/mysql/libmysqlclient.la /usr/lib/libmysqlclient.so.14.0.0 /usr/lib/libmysqlclient_r.so /usr/lib/libmysqlclient_r.so.14 /usr/lib/libmysqlclient_r.so.14.0.0 If the static libraries are found, then the make dies with linking problems. I temporarily did a 'rename .a .a_old *.a' and 'rename .la .la_old *.la' in my /usr/lib/mysql directory, and then was able to make everything successfully. The output of ./configure ... | grep -i mysql gives: checking for MySQL support... yes checking for specified location of the MySQL UNIX socket... /var/run/mysql/mysql.sock checking for MySQL UNIX socket location... /var/run/mysql/mysql.sock checking for mysql_close in -lmysqlclient... (cached) yes checking for MySQLi support... yes checking whether to enable embedded MySQLi support... no checking for mysql_set_server_option in -lmysqlclient... (cached) yes checking for mysql_stmt_field_count in -lmysqlclient... (cached) yes BTW, I'm running Redhat Enterprise AS using PHP-5.0.2 and MySQL-4.1.7 (stable). Previous Comments: ------------------------------------------------------------------------ [2004-10-14 01:00:05] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, 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". ------------------------------------------------------------------------ [2004-10-07 12:52:08] stormchaser1 at gmail dot com forgot to mention it's the MySQL 5.0.1-alpha installed from rpms from mysql.com ------------------------------------------------------------------------ [2004-10-07 12:48:24] stormchaser1 at gmail dot com Saame problem... cvs HEAD (php 5.1) from yesterday... ------------------------------------------------------------------------ [2004-10-06 13:28:40] php at kilimajer dot net The errror occurs with these rpms installed: MySQL-server-4.1.5-0 MySQL-client-4.1.5-0 MySQL-bench-4.1.5-0 MySQL-shared-4.1.5-0 MySQL-embedded-4.1.5-0 MySQL-devel-4.1.5-0 They are downloaded from mysql.com ------------------------------------------------------------------------ [2004-10-06 08:52:32] derick@php.net That doesn't make sense unless you only have a static version of the libmysqlclient... in which case I still think that the linker handles that correctly. Can you please try to use a shared library version of libmysqlclient though? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/29860 -- Edit this bug report at http://bugs.php.net/?id=29860&edit=1