MySQL Bugs: #29978: Unable to install MySQL Packages due to never ending dependencies

Bug #29978	Unable to install MySQL Packages due to never ending dependencies
Submitted:	23 Jul 2007 14:40	Modified:	30 Jul 2007 5:15
Reporter:	paul sanz	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	5.0	OS:	Linux
Assigned to:		CPU Architecture:	Any
Tags:	(fedora 7)Unable to install any MySQL packages server, client, libs etc. due to dependencies!!! need help !!

Description:
Hi everyone ; mayor problem just set up a fedora 7 server dell power edge 840 64 bit. Set up the vsftpd and samba all aok and now on mysql and having mayor problems.

Fedora 7 comes with MySQL 5.0.41 preinstalled from system installation and I've been having problems as i found that i was unable to connect, had no client installed and no administrator or manager as you call it; and as yum and pirut for some odd reason stopped working so ive downloaded the following packages to install them using rpm commands.

MySQL-server-5.0.45-0.glibc23.ia64.rpm
MySQL-client-5.0.45-0.glibc23.ia64.rpm
MySQL-bench-5.0.45-0.glibc23.ia64.rpm
MySQL-devel-5.0.45-0.glibc23.ia64.rpm
MySQL-shared-5.0.45-0.glibc23.ia64.rpm
MySQL-shared-compat-5.0.45-0.glibc23.ia64.rpm

Had more problems and this is when i decided to uninstall the server i had 5.041  using yum remove  and started to try to install the latest mysql server 5.0.45 but had no luck 
	
	see what i did and what errors i get;

#rpm -qa |grep mysql 
null
#locate mysql
i get a large list of rc.d k36 and s64mysql 
/usr/bin mysql and its corresponding files
/var/lib/mysql and its corresponding files
/var/log/mysqld.log
/var/lock/subsys/mysql

proceeding with new installation...
# rpm -i MySQL-server-5.0.45-0.glibc23.ia64.rpm 
error: Failed dependencies: 
        libc.so.6.1()(64bit) is needed by MySQL-server-5.0.45-0.glibc23.ia64 
        libc.so.6.1(GLIBC_2.2)(64bit) is needed by MySQL-server-5.0.45-0.glibc23.ia64 
        libc.so.6.1(GLIBC_2.3)(64bit) is needed by MySQL-server-5.0.45-0.glibc23.ia64 
        libcrypt.so.1(GLIBC_2.0)(64bit) is needed by MySQL-server-5.0.45-0.glibc23.ia64 
        libdl.so.2(GLIBC_2.0)(64bit) is needed by MySQL-server-5.0.45-0.glibc23.ia64 
        libdl.so.2(GLIBC_2.1)(64bit) is needed by MySQL-server-5.0.45-0.glibc23.ia64 
        libm.so.6.1()(64bit) is needed by MySQL-server-5.0.45-0.glibc23.ia64 
        libm.so.6.1(GLIBC_2.2)(64bit) is needed by MySQL-server-5.0.45-0.glibc23.ia64 
        libmysqlclient.so.15()(64bit) is needed by MySQL-server-5.0.45-0.glibc23.ia64 
        libmysqlclient.so.15(libmysqlclient_15)(64bit) is needed by MySQL-server-5.0.45-0.glibc23.ia64 
        libpthread.so.0(GLIBC_2.2)(64bit) is needed by MySQL-server-5.0.45-0.glibc23.ia64 

I proceed to add dependencies...

rpm -i glibc-2.3.3-12.7.100mdk.ia64.rpm 
warning: glibc-2.3.3-12.7.100mdk.ia64.rpm: Header V3 DSA signature: NOKEY, key ID 26752624 
error: Failed dependencies: 
        glibc > 2.6 conflicts with glibc-common-2.6-4.x86_64 

what is this all about so i ... 
rpm -qa | grep glibc 
glibc-common-2.6-4 
glibc-2.6-4 
glibc-2.6-4 

tried erasing those depending files and retry to install but same error message conflicts.

So i proceed with the list to see if i can install other lib...

rpm -i glibc-2.4-8mdv2008.0.sparc64.rpm
glibc-2.4-8mdv2008.0.sparc64.rpm: Header V3 DSA signature: NOKEY, key ID 26752624 
error: Failed dependencies: 
        ash >= 0.3.8-7mdk is needed by glibc-2.4-8mdv2008.0.sparc64 
        /bin/ash is needed by glibc-2.4-8mdv2008.0.sparc64 
        glibc > 2.6 conflicts with glibc-common-2.6-4.x86_64

i proceed and download ash shell the latest version 

rpm -i ash-0.4.0-9.i386.rpm 
# locate /*/ash 
# rpm -qa | grep ash 
sash-3.6-1 
bash-3.2-9.fc7 
nash-6.0.9-7.1 
ash-0.4.0-9 

Succesfull  download of ash !

For 
MySQL-client-5.0.45-0.glibc23.ia64.rpm  needed;
        libc.so.6.1()(64bit) 
        libc.so.6.1(GLIBC_2.3)(64bit)
        libm.so.6.1()(64bit)
        libmysqlclient.so.15()(64bit)
        libpthread.so.0(GLIBC_2.2)(64bit)

MySQL-bench-5.0.45-0.glibc23.ia64.rpm needed ;
        MySQL-client is needed by MySQL-bench-5.0.45-0.glibc23.ia64

MySQL-devel-5.0.45-0.glibc23.ia64.rpm needed;
        libc.so.6.1()(64bit)
        libc.so.6.1(GLIBC_2.2)(64bit) 
        libm.so.6.1()(64bit)
        libpthread.so.0(GLIBC_2.2)(64bit)

MySQL-shared-5.0.45-0.glibc23.ia64.rpm needed;
        libc.so.6.1()(64bit) i 
        libc.so.6.1(GLIBC_2.2)(64bit) 
        libc.so.6.1(GLIBC_2.3)(64bit) 
        libm.so.6.1()(64bit) 
        libm.so.6.1(GLIBC_2.2)(64bit)
        libpthread.so.0(GLIBC_2.2)(64bit) 
	
 MySQL-shared-compat-5.0.45-0.glibc23.ia64.rpm
        libc.so.6.1()(64bit) 
        libc.so.6.1(GLIBC_2.2)(64bit) 
        libc.so.6.1(GLIBC_2.3)(64bit) 
        libm.so.6.1()(64bit) 
        libm.so.6.1(GLIBC_2.2)(64bit) 
        libpthread.so.0(GLIBC_2.2)(64bit) 

So what am i doing wrong?

Note
some times i get this error  message

rpmdb: Lock table is out of available locker entries
rpmdb: Unknown locker ID: 7da
error: db4 error(22) from db->close: Argumento inválido
error: cannot open Packages index using db3 - No se pudo asignar memoria (12)
error: cannot open Packages database in /var/lib/rpm

How to repeat:
can any one help .. please

Thank you for a problem report. Please, send the results of 

uname -a

from your system.

uname -a
Linux logos 2.6.21-1.3228.fc7 #1 SMP Tue Jun 12 14:56:37 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux

thanks

paul

So, you have x86_64 box, why you are installing RPMs for ia64 on it? Remove them, install correct RPMs, and inform about the results. But this does NOT look like a bug in a mysql code...

Sorry my fault didnt realise, I managed to fix up2date and used that to install mysql.

Big help though thanks very much.

Paul
Systems Admin

I seem to be having the same problem - trying to install 64bit MySQL on RedHat 4

i copied down the rhel4.ia64.rpm and have the same dependencies errors - what RPM should I download? I am currently running Community as I await a support contract

uname -a returns Linux x86_64 x86_64 x86_64 GNU/Linux

thanks

All reporters,

If you are on x86_64 machine, you have to install RPMs for x86_64, not for ia64 (Itaniums). Whatever problem lead you to get ia64 binaries installed, it is NOT a bug in MySQL code or in our binaries.

hi, 

in my machine, uname output is like this,
$uname -a 
Linux sc-s2-204-1.needle.com 2.4.27-20070628_1628smp #1 SMP Thu Jun 28 16:35:10 PDT 2007 i686 unknown

$cat  /etc/redhat-release
Red Hat Linux release 7.1 (Seawolf)

which mysql rpm package i should install to not to get all the dependency as paul reported..

I got confusion in choosing the correct mysql package, kindly help me out.

regds
sasikala.