I have configured PHP with the following options:
./configure --with-apxs=/usr/sbin/apxs --with-mysql=/usr
/usr/lib/mysql contains libmyclient.a and libmyclient.sa.
Configuration and make goes fine, though I get the
following warning:
*** Warning: This library needs some functionality provided
by /usr/lib/mysql/libmysqlclient.la.
*** I have the capability to make that library
automatically link in when
*** you link to this library. But I can only do this if
you have a
*** shared version of the library, which you do not appear
to have.
Install goes fine, but when I restart Apache ( 1.3.3 ), I
get the following error:
Cannot load /usr/lib/apache/libphp4.so into server: /usr/
lib/apache/libphp4.so: undefined symbol: mysql_free_result
PHP 4.0.6 compiled from source and ran with no such
problems.

How exactly did you configure/compile/install Mysql ?
And what linux distribution is this ?
--Jani

[2001-12-14 04:14 UTC] glen at designsolution dot co dot uk

MySQL was installed from RPM's a while ago:
MySQL-3.22.21-2C1
MySQL-client-3.22.21-2C1
MySQL-devel-3.22.21-2C1
The system is a Cobalt Qube 2:
Linux qube.dessol 2.0.34C51_SK #1 Mon Nov 29 07:59:59 CET
1999 mips unknown
By the way, I also tried linking with libmcal.a which is
installed in /usr/local/mcal/lib/. I used the
configuration option --with-mcal=/usr/local/mcal and
configuration/compiling/installing went fine. However,
when restarting Apache, I get:
Cannot load /usr/lib/apache/libphp4.so into server: /usr/
lib/apache/libphp4.so: undefined symbol: mcal_close
I don't know what's going on here, but it seems the *.a
files are not being linked to correctly? There was no such
problems with the 4.0.6 release which I compilied with
MySQL and MCAL support with no problems.
Thanks.

[2002-01-02 11:30 UTC] glen at designsolution dot co dot uk

I have sucessfully linked PHP4.1.1 to static libtool
libraries with the following method:
1. ./configure in the 4.0.6 source directory
2. ./configure in the 4.1.1 source directory
3. copy the libtool from 4.0.6 to the 4.1.1 direcory
4. make
5. make install
Obviously this is a little messy, but it does seem to work
sucessfully.
Regards,
Glen

Thank you for taking the time to report a problem with PHP.
Unfortunately your version of PHP is too old -- the problem
might already be fixed. Please download a new PHP
version from http://www.php.net/downloads.php
If you are able to reproduce the bug with one of the latest
versions of PHP, please change the PHP version on this bug report
to the version you tested and change the status back to "Open".
Again, thank you for your continued support of PHP.

[2002-06-07 04:14 UTC] glen at designsolution dot co dot uk

Still not working with 4.2.1. This is particurlarly
problematic with MCAL which only compiles as a static
library.

Please give more information what the actual problem is.
Is the problem only with '--with-mcal' ??

[2002-06-07 12:03 UTC] glen at designsolution dot co dot uk

As I have mentioned above, PHP does not seem to compile
correctly with static libtool libraries. I have static
MySQL and MCAL libraries, and PHP fails to link to either.
PHP 4.0.6 worked, but nothing since has.

This must be some mips related thing since it works
fine for me and many others. And hard to fix/debug as
I think none of the developers have access to such system.
Do you get any clear compile _errors_ ?
Does config.log have any clues?
--Jani

[2002-06-18 07:53 UTC] glen at designsolution dot co dot uk

There are no compile errors at all. Everything goes well until I start Apache. Then I get errors about missing MySQL or MCAL functions.
PHP 4.0.6 was the last version that worked correctly.

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".