Bug #22081 MySQL-shared needs to obsolete/replace an installed "mysql-shared" RPM
Submitted: 7 Sep 2006 12:28 Modified: 30 Nov 2006 20:23
Reporter: Lenz Grimmer Email Updates:
Status: Closed
Category:Server: Packaging Severity:S3 (Non-critical)
Version:All OS:Linux (Linux (RPM-based))
Assigned to: Joerg Bruehe Target Version:
Tags: updating, rpm

[7 Sep 2006 12:28] Lenz Grimmer
Description:
SUSE Linux ships with MySQL, but the RPM names use lowercase characters. Therefore RPM
does not automatically detect that our RPMs should replace the existing ones. This causes
the installation of the MySQL-shared RPM to fail.

How to repeat:
Try to install our "MySQL-shared" RPM to install on a SUSE Linux system with
"mysql-shared" installed. Oberve the error:

# rpm -Uhv MySQL-shared-5.0.24a-0.glibc23.i386.rpm
Preparing...                ########################################### [100%]
        file /usr/lib/libmysqlclient.so.15.0.0 from install of
MySQL-shared-5.0.24a-0.glibc23 conflicts with file from package mysql-shared-5.0.18-16
        file /usr/lib/libmysqlclient_r.so.15.0.0 from install of
MySQL-shared-5.0.24a-0.glibc23 conflicts with file from package mysql-shared-5.0.18-16

Suggested fix:
The MySQL-shared subpackage needs to contain the following two lines in the RPM spec
file:

===== mysql.spec.sh 1.154 vs edited =====
--- 1.154/support-files/mysql.spec.sh   2006-09-07 14:24:47 +02:00
+++ edited/mysql.spec.sh        2006-09-07 14:24:32 +02:00
@@ -194,6 +194,8 @@
 %package shared
 Summary: MySQL - Shared libraries
 Group: Applications/Databases
+Provides: mysql-shared
+Obsoletes: mysql-shared

 %description shared
 This package contains the shared libraries (*.so*) which certain
[8 Sep 2006 2:37] Peter Laursen
I have had NO problem in installing 5.1.11 on SuSE 10.1 - Server , clients and shared
library.  Now if you are interested I can run any command on the system as you like!
[8 Sep 2006 2:41] Peter Laursen
but .. with hindsight ..

As I knew that I would not use the MySQL version shipped with SuSE 10.1, I now get in
doubt if I chose to install MySQL when installing the OS!
[12 Sep 2006 9:45] Valeriy Kravchuk
Verified, also - on SuSE 9.3. I have, for example:

openxs@suse:~/dbs/5.0> rpm -q -a | grep -i mysql
mysql-shared-4.1.10a-3
...
MySQL-shared-5.0.22-0.glibc23
[16 Nov 2006 13:01] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/15415

ChangeSet@1.2554, 2006-11-16 14:01:31+01:00, joerg@trift2. +1 -0
  support-files/mysql.spec.sh  :   Add an "Obsoletes" note relative to SuSE RPMs
(bug#22081).
[16 Nov 2006 13:33] Joerg Bruehe
Fixing it in 4.1.23, 5.0.30, and 5.1.14-beta.
[30 Nov 2006 10:34] Joerg Bruehe
Sorry about the delay, I forgot to do this step ...

Fix got pushed as listed above, is contained in 5.0.30.
[30 Nov 2006 20:23] Paul DuBois
No changelog entry needed.
[25 Nov 2009 2:38] Roel Van de Paar
Also see bug #49083