MySQL Bugs: #17397: Dependency conflicts on RHEL4 with 5.0 RPMS

Bug #17397	Dependency conflicts on RHEL4 with 5.0 RPMS
Submitted:	14 Feb 2006 20:18	Modified:	23 Mar 2006 7:57
Reporter:	John Mathew	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	MySQL 5.0	OS:	Linux (RedHat)
Assigned to:		CPU Architecture:	Any

Description:
Ater reading Bug #17035, I successfully installed "MySQL-shared-compat-4.0.13-0.i386.rpm" (the only "shared-compat" file I found) and attempted again to install 5.0.18.  Failure messages remain the same.

How to repeat:
Install MySQL 5.0.18 after installing latest RedHat v4.

Suggested fix:
Assuming recommended fix in Bug #17035 works, identify how to find correct "shared-compat" .rpm file.

Thank you for a problem report. Please, try to use http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-shared-compat-5.0.18-0.i386.rpm/from/pi... and inform about the results.

Nice to get a "shared-compat" file that says "5.0.18-0", thank you.  But I get the same "error: Failed dependencies:" complaint.  I tried amending the filename you sent to match the naming convention used in the upgrade files I have been using: (http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-shared-compat-5.0.18-0.rhe14.ia64.rpm/f...), but got a message, "That file does not exist on our download mirrors."

I downloaded the second file you directed me to, but it is identical to the first (both content and filename).  I ran it again anyway, and here is the result:

[root@mako src]# rpm -Uvh MySQL-shared-compat-5.0.18-0.i386.rpm
warning: MySQL-shared-compat-5.0.18-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
        package MySQL-shared-compat-5.0.18-0 is already installed
[root@mako src]# rpm -Uvh MySQL-server-standard-5.0.18-0.rhel4.ia64.rpm
warning: MySQL-server-standard-5.0.18-0.rhel4.ia64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
        libc.so.6.1()(64bit) is needed by MySQL-server-standard-5.0.18-0.rhel4.ia64
        libc.so.6.1(GLIBC_2.2)(64bit) is needed by MySQL-server-standard-5.0.18-0.rhel4.ia64
        libc.so.6.1(GLIBC_2.3)(64bit) is needed by MySQL-server-standard-5.0.18-0.rhel4.ia64
        libcrypt.so.1(GLIBC_2.0)(64bit) is needed by MySQL-server-standard-5.0.18-0.rhel4.ia64
        libdl.so.2(GLIBC_2.0)(64bit) is needed by MySQL-server-standard-5.0.18-0.rhel4.ia64
        libdl.so.2(GLIBC_2.1)(64bit) is needed by MySQL-server-standard-5.0.18-0.rhel4.ia64
        libm.so.6.1()(64bit) is needed by MySQL-server-standard-5.0.18-0.rhel4.ia64
        libpthread.so.0(GLIBC_2.2)(64bit) is needed by MySQL-server-standard-5.0.18-0.rhel4.ia64
        MySQL conflicts with mysql-4.1.12-3.RHEL4.1.i386
        libmysqlclient.so.14()(64bit) is needed by (installed) perl-DBD-MySQL-2.9004-3.1.x86_64
[root@mako src]# rpm -Uvh MySQL-client-standard-5.0.18-0.rhel4.ia64.rpm
warning: MySQL-client-standard-5.0.18-0.rhel4.ia64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
        libc.so.6.1()(64bit) is needed by MySQL-client-standard-5.0.18-0.rhel4.ia64
        libc.so.6.1(GLIBC_2.2)(64bit) is needed by MySQL-client-standard-5.0.18-0.rhel4.ia64
        libc.so.6.1(GLIBC_2.3)(64bit) is needed by MySQL-client-standard-5.0.18-0.rhel4.ia64
        libm.so.6.1()(64bit) is needed by MySQL-client-standard-5.0.18-0.rhel4.ia64
        libpthread.so.0(GLIBC_2.2)(64bit) is needed by MySQL-client-standard-5.0.18-0.rhel4.ia64
[root@mako src]#

Please, send the results of the following command from your Linux box:

uname -a
rpm -q -a | grep -i mysql

Here is the transaction history for the two commands you asked for:

[root@mako hnmadm]# uname -a
Linux mako.operations.gci.com 2.6.9-22.0.2.ELsmp #1 SMP Thu Jan 5 17:11:56 EST 2006 x86_64 x86_64 x86_64 GNU/Linux
[root@mako hnmadm]# rpm -q -a | grep -i mysql
MySQL-python-1.0.0-1.RHEL4.1
mysqlclient10-3.23.58-4.RHEL4.1
mysql-4.1.12-3.RHEL4.1
libdbi-dbd-mysql-0.6.5-10.RHEL4.1
mysql-devel-4.1.12-3.RHEL4.1
mysqlclient10-3.23.58-4.RHEL4.1
perl-DBD-MySQL-2.9004-3.1
MySQL-shared-compat-5.0.18-0
mysql-4.1.12-3.RHEL4.1
[root@mako hnmadm]#

It's been almost 3 weeks since the last update on this Bug.  Can you tell us what progress is being made?  We have two unuseable servers, and the unavailability is increasing the impact.

I hope your results (uname -a) gave you an obvious hint: x86_64 is NOT ia64, it's a different architecture, and you should download and install different RPMs.

Now it's a good time to give 5.0.19 a try. So, please, try to download and install http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-server-standard-5.0.19-0.rhel4.x86_64.r... and inform about the results.

I tried the file indicated and got this result:

[hnmadm@shark src]$ rpm -Uvh MySQL-server-standard-5.0.19-0.rhel4.x86_64.rpm
warning: MySQL-server-standard-5.0.19-0.rhel4.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
        MySQL conflicts with mysql-4.1.12-3.RHEL4.1.i386
        libmysqlclient.so.14()(64bit) is needed by (installed) perl-DBD-MySQL-2.9004-3.1.x86_64

Assuming the ~x86_64.rpm files are what I need, I tried to install "mysql-4.1.12-0.rhe14.x86_64.rpm", but got the same error message (the 2 failed dependencies).

I also looked for a "~shared-compat-5.0.19-0.x86_64.rpm" file, but could only find a ~i386.rpm version. This failed with:
error: MySQL-shared-compat-5.0.19-0.i386.rpm: V3 DSA signature: BAD, key ID 5072e1f5
error: MySQL-shared-compat-5.0.19-0.i386.rpm cannot be installed

Please, deinstall all the older RPMs and just install new ones, for proper architecture, x86_64. Inform about the results or any problems.

Success.  Thank you for the help.

Just proper RPMs should be used.