Bug #39966 Install Mysql 5.1.26 failed
Submitted: 9 Oct 2008 22:08 Modified: 14 Oct 2008 17:56
Reporter: Thomas Lee Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Installing Severity:S1 (Critical)
Version:Red Hat ES 4.7 or 4 OS:Linux
Assigned to: CPU Architecture:Any
Tags: Installing Issue

[9 Oct 2008 22:08] Thomas Lee
Description:
Some similar bug report said RPM compat Lib first but didnt work in my
case.

[root@mastero2 linux-mysql-rpm-new]# rpm -iv MySQL-shared-compat-5.1.26-0.rhel4.i386.rpm
warning: MySQL-shared-compat-5.1.26-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing packages for installation...
        package MySQL-shared-compat-5.1.26-0.rhel4 is already installed
[root@mastero2 linux-mysql-rpm-new]# rpm -iv MySQL-server-community-5.1.26-0.rhel4.i386.rpm
warning: MySQL-server-community-5.1.26-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
        MySQL conflicts with mysql-4.1.22-2.el4.i386

How to repeat:
simply download Mysql web site and run it
[10 Oct 2008 3:21] Valeriy Kravchuk
Thank you for a problem report. This is not a bug though, as you have older version installed as RPM, you should either remove it first or install ignoring dependencies.
[13 Oct 2008 16:55] Thomas Lee
Installed it without dependence still have same message.

[root@mastero2 linux-mysql-rpm-new]# rpm -iv --nodeps MySQL-server-community-5.1.26-0.rhel4.i386.rpm
warning: MySQL-server-community-5.1.26-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing packages for installation...
        file /etc/my.cnf from install of MySQL-server-community-5.1.26-0.rhel4 conflicts with file from package mysql-4.1.22-2.el4
        file /usr/bin/mysqldumpslow from install of MySQL-server-community-5.1.26-0.rhel4 conflicts with file from package mysql-4.1.22-2.el4
        file /usr/share/info/mysql.info.gz from install of MySQL-server-community-5.1.26-0.rhel4 conflicts with file from package mysql-4.1.22-2.el4
        file /usr/share/mysql/charsets/Index.xml from install of MySQL-server-community-5.1.26-0.rhel4 conflicts with file from package mysql-4.1.22-2.el4
        file /usr/share/mysql/charsets/armscii8.xml from install of MySQL-server-community-5.1.26-0.rhel4 conflicts with file from package mysql-4.1.22-2.el4
        file /usr/share/mysql/charsets/ascii.xml from install of MySQL-server-community-5.1.26-0.rhel4 conflicts with file from package mysql-4.1.22-2.el4
        file /usr/share/mysql/charsets/cp1250.xml from install of MySQL-server-community-5.1.26-0.rhel4 conflicts with file from package mysql-4.1.22-2.el4
        file /usr/share/mysql/charsets/cp1251.xml from install of MySQL-server-community-5.1.26-0.rhel4 conflicts with file from package mysql-4.1.22-2.el4
        file /usr/share/mysql/charsets/cp1256.xml from install of MySQL-server-community-5.1.26-0.rhel4 conflicts with file from package mysql-4.1.22-2.el4
        file /usr/share/mysql/charsets/cp1257.xml from install of MySQL-server-community-5.1.26-0.rhel4 conflicts with file from package mysql-4.1.22-2.el4
[13 Oct 2008 17:01] Thomas Lee
Removed mysql-4.1.22 related files and re-installed had same problem

[root@mastero2 linux-mysql-rpm-new]# find / | grep mysql-4.1.22 /usr/share/doc/mysql-4.1.22
/usr/share/doc/mysql-4.1.22/README
/usr/share/doc/mysql-4.1.22/COPYING
/usr/share/doc/mysql-4.1.22/EXCEPTIONS-CLIENT
[root@mastero2 linux-mysql-rpm-new]# rm -rf /usr/share/doc/mysql-4.1.22
[root@mastero2 linux-mysql-rpm-new]# find / | grep mysql-4.1.22
[root@mastero2 linux-mysql-rpm-new]# rpm -iv --nodeps MySQL-server-community-5.1.26-0.rhel4.i386.rpm
warning: MySQL-server-community-5.1.26-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing packages for installation...
        file /etc/my.cnf from install of MySQL-server-community-5.1.26-0.rhel4 conflicts with file from package mysql-4.1.22-2.el4
        file /usr/bin/mysqldumpslow from install of MySQL-server-community-5.1.26-0.rhel4 conflicts with file from package mysql-4.1.22-2.el4
        file /usr/share/info/mysql.info.gz from install of MySQL-server-community-5.1.26-0.rhel4 conflicts with file from package mysql-4.1.22-2.el4
        file /usr/share/mysql/charsets/Index.xml from install of MySQL-server-community-5.1.26-0.rhel4 conflicts with file from package mysql-4.1.22-2.el4
        file /usr/share/mysql/charsets/armscii8.xml from install of MySQL-server-community-5.1.26-0.rhel4 conflicts with file from package mysql-4.1.22-2.el4
        file /usr/share/mysql/charsets/ascii.xml from install of MySQL-server-community-5.1.26-0.rhel4 conflicts with file from package mysql-4.1.22-2.el4
        file /usr/share/mysql/charsets/cp1250.xml from install of MySQL-server-community-5.1.26-0.rhel4 conflicts with file from package mysql-4.1.22-2.el4
[13 Oct 2008 18:04] Thomas Lee
I am very sure that I didnt install old release, The Mysql 5.1.26 is the only
one I insrtalled.
[13 Oct 2008 18:59] Valeriy Kravchuk
Please, send the results of:

rpm -q -a | grep -i mysql

Many MySQL-related RPMs comes with stock RHES...
[13 Oct 2008 21:15] Thomas Lee
Found some 4.1.22 stuff but cant remove it!!

[root@mastero2 linux-mysql-rpm-new]# rpm -qa | grep -i mysql
perl-DBD-MySQL-2.9004-3.1
mysql-4.1.22-2.el4
MySQL-shared-community-5.1.28-0.rhel4
[root@mastero2 linux-mysql-rpm-new]# rpm -evv mysql-4.1.22-2.el4
D: opening  db environment /var/lib/rpm/Packages joinenv
D: opening  db index       /var/lib/rpm/Packages rdonly mode=0x0
D: locked   db index       /var/lib/rpm/Packages
D: opening  db index       /var/lib/rpm/Name rdonly mode=0x0
D: opening  db index       /var/lib/rpm/Pubkeys rdonly mode=0x0
D:  read h#    1250 Header sanity check: OK
D: ========== DSA pubkey id 219180cddb42a60e
D:  read h#     998 Header V3 DSA signature: OK, key ID db42a60e
D: ========== --- mysql-4.1.22-2.el4 i386/linux 0x1
D: opening  db index       /var/lib/rpm/Requirename rdonly mode=0x0
D:  read h#     307 Header V3 DSA signature: OK, key ID db42a60e
D: opening  db index       /var/lib/rpm/Depends create mode=0x0
D: opening  db index       /var/lib/rpm/Providename rdonly mode=0x0
D:  Requires: libmysqlclient.so.14                          NO
D: package perl-DBD-MySQL-2.9004-3.1.i386 has unsatisfied Requires: libmysqlclient.so.14
D:  read h#    1234 Header V3 DSA signature: OK, key ID db42a60e
D:  Requires: libmysqlclient.so.14                          NO  (cached)
D: package dovecot-0.99.11-9.EL4.i386 has unsatisfied Requires: libmysqlclient.so.14
D:  Requires: libmysqlclient.so.14(libmysqlclient_14)       NO
D: package dovecot-0.99.11-9.EL4.i386 has unsatisfied Requires: libmysqlclient.so.14(libmysqlclient_14)
D: closed   db index       /var/lib/rpm/Depends
error: Failed dependencies:
        libmysqlclient.so.14 is needed by (installed) perl-DBD-MySQL-2.9004-3.1.i386
        libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-9.EL4.i386        libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) dovecot-0.99.11-9.EL4.i386
D: closed   db index       /var/lib/rpm/Pubkeys
D: closed   db index       /var/lib/rpm/Providename
D: closed   db index       /var/lib/rpm/Requirename
D: closed   db index       /var/lib/rpm/Name
D: closed   db index       /var/lib/rpm/Packages
D: closed   db environment /var/lib/rpm/Packages
[root@mastero2 linux-mysql-rpm-new]#
[14 Oct 2008 4:08] Valeriy Kravchuk
Try rpm -e ... --nodeps
[14 Oct 2008 14:00] Thomas Lee
The RPM -e --nodeps work, install server ok but mysqladmin missing

[root@mastero2 linux-mysql-rpm-new]# mysqladmin -u root password 'system'
bash: /usr/bin/mysqladmin: No such file or directory
[root@mastero2 linux-mysql-rpm-new]# service mysql restart 
MySQL manager or server PID file could not be found!       [FAILED]
Starting MySQL....................................................................................................Manager of pid-file quit without updating file.                                                          [FAILED]
[root@mastero2 linux-mysql-rpm-new]# /usr/bin/mysqladmin -u root password 'system'
bash: /usr/bin/mysqladmin: No such file or directory
[14 Oct 2008 14:35] Valeriy Kravchuk
Please, send the results of:

rpm -q -a | grep -i mysql
find / -name mysqladmin -print 2>/dev/null
[14 Oct 2008 16:45] Thomas Lee
It finally show up for mysqladmin but mysql not ok 

[root@mastero2 linux-mysql-rpm-new]# rpm -qa  | grep -i mysql
perl-DBD-MySQL-2.9004-3.1
MySQL-client-community-5.1.25-0.rhel4
MySQL-shared-community-5.1.28-0.rhel4
MySQL-devel-community-5.1.25-0.rhel4
MySQL-server-community-5.1.26-0.rhel4

[root@mastero2 linux-mysql-rpm-new]# find / -name mysqladmin -print 2>/dev/null
/usr/bin/mysqladmin
[root@mastero2 linux-mysql-rpm-new]# /usr/bin/mysqladmin -u root -h mastero2 password 'system'
[root@mastero2 linux-mysql-rpm-new]# service mysql start
Starting MySQL....................................................................................................Manager of pid-file quit without updating file.                                                          [FAILED]
[root@mastero2 linux-mysql-rpm-new]#
[14 Oct 2008 16:57] Valeriy Kravchuk
Please, replace these:

MySQL-client-community-5.1.25-0.rhel4
MySQL-devel-community-5.1.25-0.rhel4
MySQL-server-community-5.1.26-0.rhel4

with the same RPMs of a newer version, 5.1.28. rpm -Uv should work. Inform about the results.
[14 Oct 2008 17:00] Thomas Lee
try the command 2nd time dont work

[root@mastero2 linux-mysql-rpm-new]# /usr/bin/mysqladmin -u root -h mastero2 password 'system'
/usr/bin/mysqladmin: connect to server at 'mastero2' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

[root@mastero2 linux-mysql-rpm-new]# /usr/bin/mysqladmin -u root password 'system'
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
[14 Oct 2008 17:56] Valeriy Kravchuk
Now it looks like a duplicate of bug #39208. Please, check.