mysql-devel issue

[JafferyR]

Hello,

I need mysql-devel to compile few packages on my server but looks like its not included with plesk 10.
I am running CentOS 5.6 .

I tried to install using yum but before that I added parellel's centos respository.. I am receiving following error:
yum install mysql-devel

---> Package mysql-devel.x86_64 0:5.1.59-1.el5.art set to be updated
--> Processing Dependency: libndbclient.so.3()(64bit) for package: mysql-devel
--> Processing Conflict: mysql conflicts MySQL
--> Finished Dependency Resolution
mysql-devel-5.1.59-1.el5.art.x86_64 from atomic has depsolving problems
  --> Missing Dependency: libndbclient.so.3()(64bit) is needed by package mysql-devel-5.1.59-1.el5.art.x86_64 (atomic)
mysql-5.5.14-11071510.x86_64 from installed has depsolving problems
  --> mysql conflicts with mysql
Error: mysql conflicts with mysql
Error: Missing Dependency: libndbclient.so.3()(64bit) is needed by package mysql-devel-5.1.59-1.el5.art.x86_64 (atomic)
 You could try using --skip-broken to work around the problem
 You could try running: package-cleanup --problems
                        package-cleanup --dupes
                        rpm -Va --nofiles --nodigest
The program package-cleanup is found in the yum-utils package.

Here are my questions:
1. Is it safe to install mysql-devel this way, won't it interfere with my current installation ?
2. If safe, then how to resolve above problem ?


Thank you!
PS: This is my first post here, if any mistake in then please pardon me for that !

 

[IgorG]

As I see there is mysql-devel from Atomic repository conflicts with mysql from other repo. Try to disable Atomic and install this mysq-devel from OS vendor repository.

 

[JafferyR]

I disabled atomic repository , here is output when running yum install mysql-devel

[root@abcdii yum.repos.d]# yum install mysql-devel
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.ovh.net
 * extras: mirror.ovh.net
 * updates: mirror.ovh.net
Excluding Packages in global exclude list
Finished
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql-devel.i386 0:5.0.77-4.el5_6.6 set to be updated
--> Processing Dependency: mysql = 5.0.77-4.el5_6.6 for package: mysql-devel
--> Processing Dependency: libmysqlclient.so.15 for package: mysql-devel
--> Processing Dependency: libmysqlclient_r.so.15 for package: mysql-devel
--> Processing Dependency: openssl-devel for package: mysql-devel
---> Package mysql-devel.x86_64 0:5.0.77-4.el5_6.6 set to be updated
--> Running transaction check
---> Package mysql.i386 0:5.0.77-4.el5_6.6 set to be updated
---> Package openssl-devel.x86_64 0:0.9.8e-20.el5 set to be updated
--> Processing Dependency: openssl = 0.9.8e-20.el5 for package: openssl-devel
--> Processing Dependency: zlib-devel for package: openssl-devel
--> Processing Dependency: krb5-devel for package: openssl-devel
--> Running transaction check
---> Package krb5-devel.x86_64 0:1.6.1-62.el5 set to be updated
--> Processing Dependency: krb5-libs = 1.6.1-62.el5 for package: krb5-devel
--> Processing Dependency: libselinux-devel for package: krb5-devel
--> Processing Dependency: e2fsprogs-devel for package: krb5-devel
--> Processing Dependency: keyutils-libs-devel for package: krb5-devel
---> Package openssl.i686 0:0.9.8e-20.el5 set to be updated
---> Package openssl.x86_64 0:0.9.8e-20.el5 set to be updated
---> Package zlib-devel.x86_64 0:1.2.3-4.el5 set to be updated
--> Running transaction check
---> Package e2fsprogs-devel.x86_64 0:1.39-33.el5 set to be updated
--> Processing Dependency: e2fsprogs-libs = 1.39-33.el5 for package: e2fsprogs-d                              evel
---> Package keyutils-libs-devel.x86_64 0:1.2-1.el5 set to be updated
---> Package krb5-libs.i386 0:1.6.1-62.el5 set to be updated
---> Package krb5-libs.x86_64 0:1.6.1-62.el5 set to be updated
---> Package libselinux-devel.x86_64 0:1.33.4-5.7.el5 set to be updated
--> Processing Dependency: libsepol-devel >= 1.15.2-1 for package: libselinux-de                              vel
--> Running transaction check
--> Processing Dependency: e2fsprogs-libs = 1.39-23.el5_5.1 for package: e2fspro                              gs
---> Package e2fsprogs-libs.i386 0:1.39-33.el5 set to be updated
---> Package e2fsprogs-libs.x86_64 0:1.39-33.el5 set to be updated
---> Package libsepol-devel.x86_64 0:1.15.2-3.el5 set to be updated
--> Running transaction check
---> Package e2fsprogs.x86_64 0:1.39-33.el5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package                   Arch         Version                Repository  Size
================================================================================
Installing:
 mysql-devel               i386         5.0.77-4.el5_6.6       base       2.4 M
 mysql-devel               x86_64       5.0.77-4.el5_6.6       base       2.5 M
Installing for dependencies:
 e2fsprogs-devel           x86_64       1.39-33.el5            base       637 k
 keyutils-libs-devel       x86_64       1.2-1.el5              base        27 k
 krb5-devel                x86_64       1.6.1-62.el5           base       1.9 M
 libselinux-devel          x86_64       1.33.4-5.7.el5         base       149 k
 libsepol-devel            x86_64       1.15.2-3.el5           base       192 k
 mysql                     i386         5.0.77-4.el5_6.6       base       4.8 M
 openssl-devel             x86_64       0.9.8e-20.el5          base       1.9 M
 zlib-devel                x86_64       1.2.3-4.el5            base       103 k
Updating for dependencies:
 e2fsprogs                 x86_64       1.39-33.el5            base       844 k
 e2fsprogs-libs            i386         1.39-33.el5            base       120 k
 e2fsprogs-libs            x86_64       1.39-33.el5            base       120 k
 krb5-libs                 i386         1.6.1-62.el5           base       668 k
 krb5-libs                 x86_64       1.6.1-62.el5           base       680 k
 openssl                   i686         0.9.8e-20.el5          base       1.4 M
 openssl                   x86_64       0.9.8e-20.el5          base       1.4 M

Transaction Summary
================================================================================
Install      10 Package(s)
Upgrade       7 Package(s)

Total size: 20 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
ERROR with rpm_check_debug vs depsolve:
mysql is needed by (installed) mysql-server-5.5.14-11071510.x86_64
mysql is needed by (installed) plesk-mysql-5.5-11053114.x86_64
Complete!
(1, [u'Please report this error in http://bugs.centos.org/set_project.php?projec                              t_id=16&ref=http://bugs.centos.org/bug_report_page.php?category=yum'])

I have mysql installed as it running and see output:

[root@abcidii yum.repos.d]# rpm -q mysql
mysql-5.5.14-11071510/code]

Kindly guide

PS: here is list of install mysql package :
[code] rpm -qa | grep mysql
mysql-connector-odbc-3.51.26r1127-1.el5
mysql-5.5.14-11071510
php53-mysql-5.3.3-1.el5_6.1
plesk-mysql-5.5-11053114
mysql-libs-5.5.14-11071510
mysql-server-5.5.14-11071510
libmysqlclient15-5.0.77-4.el5_5.4.11062011
ruby-mysql-2.7-200705221357

 

[PaulC]

Jaffery,

It looks like yum is trying to install version 5.0 of mysql-devel which failing because you have the Parallels build of MySQL 5.5 installed.

You should be able to install the RPM using the following command (all on one line):

rpm -i http://autoinstall.plesk.com/MYSQL_5.5/dist-rpm-RedHat-el5-x86_64/contrib/mysql-devel-5.5.14-11071510.x86_64.rpm

That should download the RPM you need and install it for you.

Paul

 

[JafferyR]

I think it can be resolved if I disable atomic STABLE repository and enable other one..

I have question then..
So, if I simply install mysql-devel using atomic repository, it will also install other depndencies.. will it effect current installation in any manner / like I need to update anything manually ? (I am new to plesk actually as in cPanel we have customapache and we are not supposed to install things directly from yum )

 

[PaulC]

Personally I would simply install the RPM using the command I posted above.

You currently have MySQL 5.5 installed using Parallels RPM.

The installation of mysql-devel from the atomic repository is "5.1.59-1.el5.art", so version 5.1 of MySQL. This does not match the current installation you have and so you should be using the matching mysql-devel which is the RPM above.

Paul