Where is mysql-libs gone???

Richard G

Verified User
Joined
Jul 6, 2008
Messages
13,524
Location
Maastricht
Am I going crazy or what? I'm trying to install mysql-libs.
I got 3 exactly the same servers (only 1 has a faster cpu):
Server A:
Linux serverA.mydomain.nl 2.6.32-358.6.2.el6.x86_64 #1 SMP Thu May 16 20:59:36 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux

Server B:
Linux serverB.othername.com 2.6.32-358.6.2.el6.x86_64 #1 SMP Thu May 16 20:59:36 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux

Server C:
Same as B.

As you can see exactly the same kernel and Centos version. On both servers then newest epel and rpmforce 64-bit repository's are installed.

When I do yum list mysql-libs on server A it says:
Code:
Installed Packages
mysql-libs.x86_64                                              5.1.69-1.el6_4                                               @updates
Available Packages
mysql-libs.i686                                                5.1.69-1.el6_4                                               updates

When I do yum list mysql-libs on server B or C it says:
Error: No matching Packages to list

How is this possible that one Centos 6 yum has it, and 2 others don't?
 
AAAARGGHHH!!! Stupid that I didn't think of that.:(

However, seems it's better not to install them, because then I get these kind of errors:
Transaction Check Error:
file /usr/share/mysql/charsets/Index.xml from install of mysql-libs-5.1.69-1.el6_4.x86_64 conflicts with file from package MySQL-server-5.5.31-1.linux2.6.x86_64
file /usr/share/mysql/charsets/README from install of mysql-libs-5.1.69-1.el6_4.x86_64 conflicts with file from package MySQL-server-5.5.31-1.linux2.6.x86_64
file /usr/share/mysql/charsets/armscii8.xml from install of mysql-libs-5.1.69-1.el6_4.x86_64 conflicts with file from package MySQL-server-5.5.31-1.linux2.6.x86_64

I only wanted to update mytop, because the epel repository seems to have a newer version.
But when I try (at least on 2 servers) I get this:
---> Package mytop.noarch 0:1.4-2.el6.rf will be updated
---> Package mytop.noarch 0:1.7-3.b737f60.el6 will be an update
--> Processing Dependency: perl(DBD::mysql) >= 1 for package: mytop-1.7-3.b737f60.el6.noarch
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Finished Dependency Resolution
Error: Package: perl-DBD-MySQL-4.013-3.el6.x86_64 (base)
Requires: libmysqlclient.so.16()(64bit)
Error: Package: perl-DBD-MySQL-4.013-3.el6.x86_64 (base)
Requires: libmysqlclient.so.16(libmysqlclient_16)(64bit)
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest

I got the libmysqlclient.so.18, would it be safe to symlink to that one, to be able to upgrade?
Code:
lcd /usr/local/mysql/lib
ln -s libmysqlclient.so.18 libmysqlclient.so.16
ldconfig
 
Last edited:
Unfortunately it won't help. The same errors occur.:(
Als tried doing this in the /usr/lib64 directory (it's Centos 6).
 
It is strange that the symlink did not fix it. If I was you, I would then try to fix it by installing perl-DBD-mysql in cpan instead of yum. I have a feeling that would solve the problem for you.

If you already have installed perl-DBD-mysql in yum, then first remove it:
Code:
yum remove perl-DBD-mysql

Then install it in cpan:
Code:
cpan
install DBD::mysql
reload cpan
q
 
Thank you for the tip but I already had removed perl-DBD-mysql and installed it in Cpan.
I had to do this to be able to install Mytop from the rpmforge repo in the first place. But you could not know this. Anyway, the yum version is not present and the DBD::mysql is installed from cpan.

But I've seen that when updating mytop via the epel repository, yum tries to install perl-DBD-MySQL which caused part of the error.
So I excluded the perl-DBD-MySQL in yum.conf but still an error occurs:

Resolving Dependencies
--> Running transaction check
---> Package mytop.noarch 0:1.4-2.el6.rf will be updated
---> Package mytop.noarch 0:1.7-3.b737f60.el6 will be an update
--> Processing Dependency: perl(DBD::mysql) >= 1 for package: mytop-1.7-3.b737f60.el6.noarch
--> Finished Dependency Resolution
Error: Package: mytop-1.7-3.b737f60.el6.noarch (epel)
Requires: perl(DBD::mysql) >= 1
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest

And it is installed in cpan, i just checked:
cpan[1]> install DBD::mysql
CPAN: Storable loaded ok (v2.20)
Reading '/root/.cpan/Metadata'
Database was generated on Thu, 30 May 2013 10:41:03 GMT
CPAN: Module::CoreList loaded ok (v2.85)
DBD::mysql is up to date (4.023).

I was able to install the newer mytop version from the epel repository on another server right before of after installing directadmin, can't remember unfortunately.
 
On the two servers wich have this problem, do you have perl-DBD-MySQL-* in /etc/yum.conf on them? If so, maybe try to remove that and see if the problems is solved. I am only guessing now, and don't know if it would matter or not.
 
Thank you for thinking with me. But I think you misunderstood what I was trying to say.
On the two servers with the problem, I just put perl-DBD-MySQL in there, to reduce the number of errors.

If I don't exclude perl-DBD-MySQL in yum.conf these errors will be added:
--> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Finished Dependency Resolution

I think I might have an idea what's causing it. In yum only mysql-server 5.1 is available, but mysql-server 5.5 is installed.
That's why I get the errors about conflicts when I tried to install mysql-libs:
Transaction Check Error:
file /usr/share/mysql/charsets/Index.xml from install of mysql-libs-5.1.69-1.el6_4.x86_64 conflicts with file from package MySQL-server-5.5.31-1.linux2.6.x86_64

Maybe that's why I don't have any problem installing the older mytop version 1.4-2.
 
Last edited:
Yes but that's a workaround.
I'm just wondering why it's saying:
Code:
Requires: perl(DBD::mysql) >= 1
when DBD::mysql is fact installed. If that could be due to the mysql 5.1/5.5 difference, then I'm satisfied.
 
Back
Top