Page 1 of 1

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

Posted: Mon Nov 16, 2009 11:03 am
by 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]#

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

Posted: Mon Nov 16, 2009 11:14 am
by 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

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

Posted: Mon Nov 16, 2009 11:20 am
by 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?

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

Posted: Tue Nov 17, 2009 9:29 am
by scott
try running "yum upgrade" (not "update") and see if it cleans things up for you

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

Posted: Tue Mar 23, 2010 12:11 pm
by erhnam
scott wrote: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

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

Posted: Tue Mar 23, 2010 1:55 pm
by 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

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

Posted: Wed Mar 24, 2010 2:00 pm
by 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...

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

Posted: Thu Mar 25, 2010 10:17 am
by 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.

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

Posted: Fri Mar 26, 2010 11:22 am
by faris
Excellent work there.

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

Faris.

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

Posted: Fri Mar 26, 2010 1:42 pm
by scott
yeah really, thats a weird tag. Not a lot of repos use that