ID: 29860
Comment by: chris at leftbrained dot org
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 know this hasn't been looked at in some time, but I've spent that
last few days working out this exact problem.
Apache 2.0.53 - Built by me into /usr/local/apache
MySQL 4.1.9 - Used the RPM download of of mysql.com
>MySQL-client-4.1.9-0
>MySQL-shared-compat-4.1.9-0
>MySQL-server-4.1.9-0
>MySQL-bench-4.1.9-0
>MySQL-devel-4.1.9-0
PHP 5.0.3 - ./configure --with-apxs2=/usr/local/apache/bin/apxs
--with-mysql=/usr --with-mysqli=/usr/bin/mysql_config
I'm on some form of RedHat Enterprise, I'm not quite sure how I would
check which one.
I was coming up witht he same exact errors, and the *only* way I was
able to make it work was this:
cd /usr/lib/mysql
rename .a .a_old *.a
rename .la .la_old *.la
Then run configure/make/make install
Then rename these files back.
cd /usr/lib/mysql
rename .a_old .a *.a_old
rename .la_old .la *.la_old
I'm not sure what precisely these files are, and this was a last resort
attempt for me, but it worked.
Chris
Previous Comments:
------------------------------------------------------------------------
[2004-10-28 21:49:01] kpederson at mail dot ewu dot edu
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).
------------------------------------------------------------------------
[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
------------------------------------------------------------------------
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