Error: Missing Dependency: mysql = 5.0.24a is needed by pack

[erhnam]

I'm using plesk 8.1.1 and RHEL4 and trying to update using atomics stable; After the yum update command I get the following error: Error: Missing Dependency: mysql = 5.0.24a is needed by package mysql-compat

Code: Select all

[root@ns1 yum.repos.d]# yum update mysql
Repository base is listed more than once in the configuration
Setting up Update Process
Setting up repositories
Reading repository metadata in from local files
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package mysql.i386 0:5.0.87-1.el4.art set to be updated
--> Running transaction check
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: mysql-server
--> Processing Dependency: mysql = 5.0.24a-3.rhel4.art for package: mysql-server
--> Processing Dependency: mysql-libs = 5.0.87-1.el4.art for package: mysql
--> Processing Dependency: libmysqlclient_r.so.15(libmysqlclient_15) for package: mysql-server
--> Processing Dependency: libmysqlclient_r.so.15 for package: mysql-server
--> Processing Dependency: mysql = 5.0.24a-3.rhel4.art for package: mysql-bench
--> Processing Dependency: libmysqlclient.so.15 for package: mysql-server
--> Processing Dependency: libmysqlclient.so.15 for package: mysql
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: mysql
--> Processing Dependency: mysql = 5.0.24a-3.rhel4.art for package: mysql-devel
--> Processing Dependency: mysql = 5.0.24a for package: mysql-compat
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package mysql-devel.i386 0:5.0.87-1.el4.art set to be updated
---> Package mysql-libs.i386 0:5.0.87-1.el4.art set to be updated
---> Package mysql-server.i386 0:5.0.87-1.el4.art set to be updated
---> Package mysql-bench.i386 0:5.0.87-1.el4.art set to be updated
--> Running transaction check
--> Processing Dependency: mysql = 5.0.24a for package: mysql-compat
--> Finished Dependency Resolution
Error: Missing Dependency: mysql = 5.0.24a is needed by package mysql-compat
[root@ns1 yum.repos.d]#

Is there any way to solve this? It seems that mysql-compat is looking for 5.0.24a and not 5.0.24a-3.rhel4.art.

Code: Select all

[root@ns1 yum.repos.d]# rpm -q mysql
mysql-5.0.24a-3.rhel4.art
[root@ns1 yum.repos.d]#

[scott]

mysql-5.0.24a-3.rhel4.art <- this might be tagged .art, but its definitely not from Atomic. I would never use the label "rhel4" in a package name

[erhnam]

Thanks,

So what do you suggest? Removing the compat and all mysql packages?

I noticed that most of my packages are installed with the el4 tag (atomic), but only mysql is running rhel4 (centos4). Is there way to switch from centos4 mysql to atomic's?

[scott]

try running "yum upgrade" (not "update") and see if it cleans things up for you

[erhnam]

mysql-5.0.24a-3.rhel4.art <- this might be tagged .art, but its definitely not from Atomic. I would never use the label "rhel4" in a package name

Are you sure about this. I found this link: http://www3.atomicorp.com/channels/source/mysql/
And this one; http://www.atomicorp.com/channels/atomi ... t.i386.rpm

[scott]

Positive, "el4" is a naming convention used in [atomic] and [asl-2.0]. "rhel4" is not used at all, not even accidentally. The build system doesnt even know what "rhel4" would mean

[erhnam]

Okee thanks.

What do you advise? I tried to remove the compat package but then I ran into:

Code: Select all

[root@ns1 mysql]# rpm -e mysql-compat-5.0.24a-3.rhel4.art
error: Failed dependencies:
        libmysqlclient.so.14 is needed by (installed) psa-ruby-mysql-2.7-200610081325.i386
        libmysqlclient.so.14 is needed by (installed) psa-qmail-1.03-rhel4.build81070322.16.i586
        libmysqlclient.so.14 is needed by (installed) psa-courier-imap-add-8.1.1-rhel4.build81070322.16.i586
        libmysqlclient.so.14 is needed by (installed) psa-8.1.1-rhel4.build81070322.16.i586
        libmysqlclient.so.14 is needed by (installed) psa-hotfix3-8.1.1-rhel4.build81070423.15.i586
        libmysqlclient.so.14 is needed by (installed) php-mysql-5.2.13-1.el4.art.i386
        libmysqlclient.so.14 is needed by (installed) perl-DBD-MySQL-2.9004-3.1.centos4.i386
        libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) psa-ruby-mysql-2.7-200610081325.i386
        libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) psa-qmail-1.03-rhel4.build81070322.16.i586
        libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) psa-courier-imap-add-8.1.1-rhel4.build81070322.16.i586
        libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) psa-8.1.1-rhel4.build81070322.16.i586
        libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) psa-hotfix3-8.1.1-rhel4.build81070423.15.i586
        libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) php-mysql-5.2.13-1.el4.art.i386
        libmysqlclient_r.so.14 is needed by (installed) MySQL-python-1.2.1_p2-1.el4.1.i386
        libmysqlclient_r.so.14(libmysqlclient_14) is needed by (installed) MySQL-python-1.2.1_p2-1.el4.1.i386

When I try to upgrade:

Code: Select all

[root@ns1 mysql-5.0.90-1.el4.art]# ls
mysql-5.0.90-1.el4.art.i386.rpm        mysql-devel-5.0.90-1.el4.art.i386.rpm  mysql-server-5.0.90-1.el4.art.i386.rpm
mysql-bench-5.0.90-1.el4.art.i386.rpm  mysql-libs-5.0.90-1.el4.art.i386.rpm
[root@ns1 mysql-5.0.90-1.el4.art]# rpm -Uvh *
error: Failed dependencies:
        mysql = 5.0.24a is needed by (installed) mysql-compat-5.0.24a-3.rhel4.art.i386
[root@ns1 mysql-5.0.90-1.el4.art]#

Looks like I'm a bit blocked here...

[erhnam]

I fixed the issue with the following commands:

Code: Select all

/etc/init.d/psa stop
cp /usr/lib/libmysqlclient.so.14 /root/
cp /usr/lib/libmysqlclient.so.14.0.0 /root/
/etc/init.d/mysqld stop
rpm -e --nodeps mysql-5.0.24a-3.rhel4.art mysql-devel-5.0.24a-3.rhel4.art mysql-bench-5.0.24a-3.rhel4.art mysql-compat-5.0.24a-3.rhel4.art mysql-server-5.0.24a-3.rhel4.art
cd /root/archive/packages/mysql-5.0.90-1.el4.art/

Code: Select all

[root@ns1 mysql-5.0.90-1.el4.art]# ls
mysql-5.0.90-1.el4.art.i386.rpm        mysql-libs-5.0.90-1.el4.art.i386.rpm
mysql-bench-5.0.90-1.el4.art.i386.rpm  mysql-server-5.0.90-1.el4.art.i386.rpm
mysql-devel-5.0.90-1.el4.art.i386.rpm
[root@ns1 mysql-5.0.90-1.el4.art]#

Code: Select all

rpm -ivh *.rpm
/etc/init.d/mysqld start
cp /root/libmysqlclient.so.14 /usr/lib/
cp /root/libmysqlclient.so.14.0.0 /usr/lib/
/etc/init.d/psa start

Plesk is still working because I made a backup of the libmysqlclient.so.14 packages.

[faris]

Excellent work there.

Interesting though -- I wonder where those rhel4.art packages came from? Most mysterious.

Faris.

[scott]

yeah really, thats a weird tag. Not a lot of repos use that