ID: 29860
Comment by: i-marcin at tlen dot pl
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 have the same problem with php-5.0.5 and MySQL 4.1 rpm`s downloaded
from mysql.com.
On another machine with the same OS and the same PHP version, but with
MySQL 4.1 compiled from source, the problem does not exist.
So I suggest to compile MySQL from source if any other solutions fail.
Previous Comments:
------------------------------------------------------------------------
[2005-09-27 23:44:08] keith at green-light dot ca
Same issue on Fedora Core 2, mysql 4.1.12, and php 5.0.4. Removed the
duplicated -lmysqlclient and was able to compile.
------------------------------------------------------------------------
[2005-06-09 19:12:52] michael at mompopmedia dot com
For what it is worth, I can confirm the same issue building php5.0.4 on
RHE 3. MySQL packages as follows:
MySQL-client-4.1.11-0
MySQL-shared-compat-4.1.11-0
MySQL-embedded-4.1.11-0
MySQL-bench-4.1.11-0
MySQL-shared-4.1.11-0
perl-DBD-MySQL-2.1021-3
MySQL-devel-4.1.11-0
MySQL-server-4.1.11-0
I'm also running Apache/1.3.33
chris at leftbrained dot org suggestion did the trick.
------------------------------------------------------------------------
[2005-05-09 18:48:49] jorge dot tiao dot pereira at gmail dot com
so do i.
i don´t connect mysql database to the pega in php.
how do it?
------------------------------------------------------------------------
[2005-02-19 19:32:23] chris at leftbrained dot org
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
------------------------------------------------------------------------
[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).
------------------------------------------------------------------------
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
