Hi,

I have a CentOS 3 server that I need to update to MySQL 5 + PHP4. I
downloaded and installed the MySQL client and server RPM packages for
Red Hat 3, including the Shared Compatibility Libraries which
provide /usr/lib/libmysqlclient.so.10, .12, .14 and .15, which seems
to be the recommended way of upgrading a MySQL 3 installation. I then
went on to recompile PHP 4.4.7, which worked fine. But my PHP
installation is still using libmysqlclient.so.10, which does not play
100% correctly with the current MySQL 5 server. I'd need it to use
libmysqlclient.so.15. Apparently /usr/lib/php4/mysql.so is linked to
libmysqlclient.so.10.

How do I update/replace/relink the php-mysql connector to have PHP
talk to MySQL using the current client libraries?

Any hints'd greatly appreciated.
Cheers,
Dav

Dav,
>
> I have a CentOS 3 server that I need to update to MySQL 5 + PHP4. I
> downloaded and installed the MySQL client and server RPM packages for
> Red Hat 3, including the Shared Compatibility Libraries which provide
> /usr/lib/libmysqlclient.so.10, .12, .14 and .15, which seems to be
> the recommended way of upgrading a MySQL 3 installation. I then went
> on to recompile PHP 4.4.7, which worked fine. But my PHP installation
> is still using libmysqlclient.so.10, which does not play 100%
> correctly with the current MySQL 5 server. I'd need it to use
> libmysqlclient.so.15. Apparently /usr/lib/php4/mysql.so is linked to
> libmysqlclient.so.10.
>
> How do I update/replace/relink the php-mysql connector to have PHP
> talk to MySQL using the current client libraries?

We do quite a few builds of PHP 4.x and MySQL, and although
we are on RHEL 4, this should . When you are compiling PHP,
and make sure you do a 'make distclean' to empty any prior configure
info -- you need to make sure that ONLY libraries/includes for MySQL 5
are visible. From what you describe it looks like php is finding
the older stuff.

In your configure for php, you probably have a line like:
--with-mysql=/usr/local/mysql
make sure that is correct. We normally build MySQL from source,
so I'm not really sure what the interaction is with an RPM MySQL
install?

I think you know the command 'ldd libphp4.so' will show you
where it wants to go.

Hope this s!
--
John
__________________________________________________ _________________
John Murtari Software Workshop Inc.
jmurtari@following domain 315.635-1968(x-211) "TheBook.Com" (TM)
http://thebook.com/