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 Impact on me:
None 
Category:MySQL Server: Packaging Severity:S3 (Non-critical)
Version:All OS:Linux (Linux (RPM-based))
Assigned to: Joerg Bruehe CPU Architecture:Any
Tags: rpm, updating

[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