Hi,

I have been trying to install the MySql package on RH9.0 but have been unsuccessful so far. I need to use both php and Mysql for PostNuke

I get the following error.

[tools@localhost coe_downloads]$ rpm -ivh php-mysql-4.2.2-17.i386.rpm
warning: php-mysql-4.2.2-17.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e
error: Failed dependencies:
libmysqlclient.so.10 is needed by php-mysql-4.2.2-17

Then on downloading and installing the following packages I get the following error
[tools@localhost coe_downloads]$ rpm -ivh mysql-4.0.17 mod_auth_mysql-1.11-10 MySql-server-4.0 php-mysql-4.2.2-8.05 libdbi-dbd-mysql-0.6.5-2 mysql-devel-4.0 MySql-python-0.9.1-4 perl-DBD-MySql-2.1017-3 qt-MySQL-3.0.5-17

I get the following error:

mx is needed by MySQL-python-0.9.1-4
libmysqlclient.so.10 is needed by MySQL-python-0.9.1-4
libdbi = 0.6.5-2 is needed by libdbi-dbd-mysql-0.6.5-2
libmysqlclient.so.10 is needed by libdbi-dbd-mysql-0.6.5-2
libmysqlclient.so.10 is needed by mod_auth_mysql-1.11-10
qt = 1:3.0.5-17 is needed by qt-MySQL-3.0.5-17
libmysqlclient.so.10 is needed by qt-MySQL-3.0.5-17
libmysqlclient.so.10 is needed by perl-DBD-MySQL-2.1017-3
libmysqlclient.so.10 is needed by php-mysql-4.2.2-17

I am pretty new to linux so is there some version compatibilty problem?

u can try the nodeps option within rpm.
rpm -ivh --nodeps <packagenames>
this wont give u the error regarding dependencies

Yeah, but then Neha will be missing the necessary librarys and dependencies.

Do you need to install all of those packages to meet the libmysqlclient.so.10 failed dependency?

Neha,

I think u need to install mysql client.

get apt (http://apt.freshrpms.net) It will take care of the dependencies

if i wanted to use apt to download and upgrade mysql on RH9 how would i do that?

just apt-get install mysql

then would it install the latest version of mysql?

just wondering........apt sounds cool.

apt-get update (syncs your local list of packages with the servers)
apt-get upgrade (upgrades all packages)
apt-get install mysql-server (installs the latest version included with the distro) (redhat 9 is 3.23 something)

If you really need mysql 4 you have to download the rpm from www.mysql.com . If you have a dependency problem you can do

apt-cache search dependency

ex: apt-cache libdbi


Final though: I really suggest you install MySQL shared libraries if you are planning on using mysql 4 on a redhat box. Solves a lot of problems

Sorry. Bad example

The example should look like

ex: apt-cache sarch libdbi

I suggest you read

man apt-get
man apt-cache

will do....when i installit

lol

just interested a guy at work uses it......

um.....do u see a point to upgrading mysql to 4.x? not really sure its worth it.
i'm learning it u see and php...

G

From the download section of www.mysql.com:

Server 4.0.17-0 9.0M Pick a mirror
MD5: 821f9cf17c1ba0e43828e4f49c93de1b
Max 4.0.17-0 1.5M Pick a mirror
MD5: da50e7086069d899a849c9684c35a016
Benchmark/test suites 4.0.17-0 1.7M Pick a mirror
MD5: c56801364ad0e70a69a92c0dcbff1e4e
Client programs 4.0.17-0 2.6M Pick a mirror
MD5: 64ff4c7fb45eb48c307e0f0e80c60d05
Libraries and header files 4.0.17-0 925.8K Pick a mirror
MD5: c26eee03c3d109337dd1bd8c0f2c8c22
Dynamic client libraries 4.0.17-0 256.6K Pick a mirror
MD5: 948b78a4c6dc6ccafd3020d1a1f13558
Embedded server 4.0.17-0 2.0M Pick a mirror
MD5: 8c179cd252d62d72a47ff9eab972390e
Dynamic client libraries
(including 3.23.x libraries) 4.0.17-0 479.4K Pick a mirror
MD5: 09af217f22374cc01a2f9964d44f6e6b

If you download the Server, Client, Header Libs, Client Llibs and Client Compat Libs (the last one) then you'll be good to go. De-install the 3.23.xx version that comes with RedHat, install these RPMs, PHP and everything else stock RedHat that uses MySQL will simply work. The last item on the download list, the -shared-compat- file is very important, it provides a 3.23.xx compatible interface to the server...

cheers

you've been a great help

Does the order in which the files appear in the rpm command matter?

If I do rpm -ivh <all the files>

rpm hangs when I try to install any of the software. Even when I use the verbose switch it doesn't print anything on screen.

It's working!

The database file was corrupt. Now everything seems ok.

Thanks a lot everyone.