MySQL database groupinstall missing dependency on centos 5.2

sokha · 09-13-2008, 07:33 PM

I have centos 5.2 OpenVZ vps. At the moment I have problem when i run yum groupinstall "MySQL Database".

Quote:

[root@centos xxxx]# yum groupinstall "MySQL Database"
Loading "priorities" plugin
Loading "fastestmirror" plugin
Loading mirror speeds from cached hostfile
* rpmforge: apt.sw.be
* base: pubmirrors.reflected.net
* updates: mirror.raystedman.net
* centosplus: pubmirrors.reflected.net
* addons: dist1.800hosting.com
* extras: centos-distro.cavecreek.net
Excluding Packages in global exclude list
Finished
343 packages excluded due to repository priority protections
Setting up Group Process
Loading mirror speeds from cached hostfile
* rpmforge: apt.sw.be
* base: pubmirrors.reflected.net
* updates: mirror.raystedman.net
* centosplus: pubmirrors.reflected.net
* addons: dist1.800hosting.com
* extras: centos-distro.cavecreek.net
Package unixODBC - 2.2.11-7.1.i386 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package perl-DBD-MySQL.i386 0:3.0007-1.fc6 set to be updated
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: perl-DBD-MySQL
--> Processing Dependency: perl(DBI) for package: perl-DBD-MySQL
--> Processing Dependency: libmysqlclient.so.15 for package: perl-DBD-MySQL
---> Package libdbi-dbd-mysql.i386 0:0.8.1a-1.2.2 set to be updated
--> Processing Dependency: libmysqlclient.so.15 for package: libdbi-dbd-mysql
--> Processing Dependency: libdbi-drivers = 0.8.1a-1.2.2 for package: libdbi-dbd-mysql
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: libdbi-dbd-mysql
--> Running transaction check
---> Package perl-DBD-MySQL.i386 0:3.0007-1.fc6 set to be updated
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: perl-DBD-MySQL
--> Processing Dependency: libmysqlclient.so.15 for package: perl-DBD-MySQL
---> Package perl-DBI.i386 0:1.52-1.fc6 set to be updated
---> Package libdbi-dbd-mysql.i386 0:0.8.1a-1.2.2 set to be updated
--> Processing Dependency: libmysqlclient.so.15 for package: libdbi-dbd-mysql
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: libdbi-dbd-mysql
---> Package libdbi-drivers.i386 0:0.8.1a-1.2.2 set to be updated
--> Finished Dependency Resolution
Error: Missing Dependency: libmysqlclient.so.15(libmysqlclient_15) is needed by package libdbi-dbd-mysql
Error: Missing Dependency: libmysqlclient.so.15 is needed by package perl-DBD-MySQL
Error: Missing Dependency: libmysqlclient.so.15 is needed by package libdbi-dbd-mysql
Error: Missing Dependency: libmysqlclient.so.15(libmysqlclient_15) is needed by package perl-DBD-MySQL

In short, I would like to have mysql-devel installed. Unfortunately, when I tried to use yum install mysql-devel, it says No package mysql-devel available.

I searched in google and in the forum almost a whole day already and could not figure out how to find a solution yet.

Any idea how to get it solved?

Thanks,

billymayday · 09-13-2008, 07:45 PM

Are you sure it isn't installed already? Try

yum list installed mysql*

or alternatively

yum list available mysql*

sokha · 09-13-2008, 08:04 PM

Thanks billymayday for your quick respond.

Quote:

[root@centos xxx]# yum list installed mysql*
...
Error: No matching Packages to list

[root@centos xxx]# yum list available mysql*
...
Error: No matching Packages to list

[root@centos xxx]# yum list installed MySQL*
...
Installed Packages
MySQL-client.i386 5.0.37-0 installed
MySQL-server.i386 5.0.37-0 installed
mysqlclient10.i386 3.23.58-9.2.1 installed

[root@centos xxx]# yum list available MySQL*
...
Error: No matching Packages to list

[root@centos sokha]# yum install MySQL-devel
...
No package MySQL-devel available.

I still could not figure out how to have MySQL-devel yet. If I tried to install it via RPM, it required dependencies.

Quote:

[root@centos xxx]# rpm -i mysql-devel-5.0.45-7.el5.i386.rpm
error: Failed dependencies:
libmysqlclient.so.15 is needed by mysql-devel-5.0.45-7.el5.i386
libmysqlclient_r.so.15 is needed by mysql-devel-5.0.45-7.el5.i386

billymayday · 09-13-2008, 08:21 PM

It should be in base.

Can you post the content of

/etc/yum.repos.s/CentOS-Base.repo

and

/etc/yum.conf

sokha · 09-13-2008, 09:42 PM

/etc/yum.repos.d/CentOS-Base.repo is: http://pastebin.com/m152030ff
and /etc/yum.conf is: http://pastebin.com/m66c55fdd

billymayday · 09-13-2008, 10:03 PM

Code:

exclude=apache* httpd* mod_* mysql* MySQL* da_* *ftp* exim* sendmail* php* bind-chroot*

in yum.conf is your problem - you are telling yum to exclude mysql

sokha · 09-13-2008, 10:14 PM

Thank billymayday

It works now. I did not know that there is exclude in yum.conf

onyingos · 01-16-2013, 03:05 AM

This post helped me a lot after struggling for hours. Editing yum.cof does work.
My initial install of mysql was not working right, and the rpm that I found online were not working due to dependency issues.
Again. THANKS A LOT billymayday!!