UBB.Developers Forums Community Development Programming MySQL and Server Configuration how to upgrade to mysql 4?

I run Redhat Linux.

I got this error message. Question: which of these things are needed for this board, and how to upgrade.

I heard something about recompiling. Or can I install a newer php?? recompile is needed by php-mysql-4.1.2-7.2.6?? how?


rpm --upgrade --test MySQL-server-4.0.12-0.i386.rpm
error: failed dependencies:
libmysqlclient.so.10 is needed by perl-DBD-MySQL-1.2216-4
libmysqlclient.so.10 is needed by mod_auth_mysql-1.11-1
libmysqlclient.so.10 is needed by php-mysql-4.1.2-7.2.6

This would probably be better asked in the MySQL forum.

PHP does need to have the proper MySQL libraries for the version you use or you'll suffer verious segfault problmes when usage gets heavy. That's IF php can even connect to MySQL with the 3 series libraries.

If you are using RedHat linux and their MySQL 4 RPMS then you should see if they have updated PHP RPMS that match.

sorry, this is too vague for me.

actually, it seems it has to do with the interface routine.

http://rpmseek.com/rpm-pl/php-mysql.html?hl=com&cs=php-mysql:PN:0:0:0

http://rpmseek.com/rpm/php-mysql-4.3.2-3.i386.html?hl=com&cs=php-mysql:PN:0:0:0:654028

I am a little lost what "requires" and "provides" means. Or if this is the problem


libmysqlclient.so.12
instead of

libmysqlclient.so.10

or how I know exactly which version runs with my old redhat (how do I find out the redhat version? I have aprox 7.2) and which one is actually for the version 4 mysql.

I can keep trying of course, trying not to kill the server. Or do a test install of redhat on my home computer, but that is a lot of extra work!


Package Name php-mysql
File Name php-mysql-4.3.2-3.i386.rpm
Group /Development/Languages
Distribution RedHat Rawhide
Version 4.3.2 Architecture i386
Release 3 File Size 24.84 kb
Build Date 2003/Jun/04 15:54:40 Package Size 39.23 kb
Copyright The PHP License Download
Packager Red Hat, Inc. <http://bugzilla.redhat.com/bugzilla>
Further Infos http://www.php.net/
Changelog show
Vendor Red Hat, Inc.
Summary A module for PHP applications that use MySQL databases.
Description The php-mysql package contains a dynamic shared object that will add
MySQL database support to PHP. MySQL is an object-relational database
management system. PHP is an HTML-embeddable scripting language. If
you need MySQL support for PHP applications, you will need to install
this package and the php or mod_php package.
Requires config
libc.so.6
libmysqlclient.so.12
php
rpmlib
Provides config
mysql.so
php_database
php-mysql
Files /etc/php.d/mysql.ini
/usr/lib/php4/mysql.so

think I have got it.

link

has the missing libraries. I will see if that solves my problem

ok, upgrade worked. But occasional error message

Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/httpd/www3.angeles2.com/board/mysql.inc.php on line 38
SQL ERROR: Database error only visible to forum administrators

question 1: why is this occasional? maybe the server does not allow sufficient number of connections?

question 2: I am a forum administrator. Why can I not see the error message??

this seems serious!!!!!! what is wrong?

I only upgraded mysql server, do I need to upgrade mysql client or something like this??

Look at the MySQL error log to see what the real error is, or edit mysql.inc.php so that it doesn't suppress the error.

thanks.

I rebooted the server and the error did not occur any more.

where would that error log be? any idea??

You specify the path in Admin -> Edit config settings, or by editing config.inc.php and setting $config['sqllog'].