libdbd-mysql-perl / libmysqlclient16/18

[schnix]

hello,

i try to install libdbd-mysql-perl, because i frequently use that modul and it is really common for perl mysql communication, but it actually conflicts with percona-server-server 5.5.

i am not very familiar with all the libdbd, perl-dbi, libdbd, perl-dbd, but i can provide the aptitude log for the installation. it seems like libmysqlclient16 is needed, but percona provides the libmysqlclient18… what to do?

aptitude install libdbd-mysql-perl
The following NEW packages will be installed:
libdbd-mysql-perl libmysqlclient16{a} mysql-common{a}
0 packages upgraded, 3 newly installed, 0 to remove and 5 not upgraded.
Need to get 2,120 kB of archives. After unpacking 4,730 kB will be used.
The following packages have unmet dependencies:
percona-server-common-5.5: Conflicts: mysql-common but 5.1.58-1~dotdeb.1 is to be installed.
Conflicts: mysql-common-4.1 which is a virtual package.
The following actions will resolve these dependencies:

Remove the following packages:

1. percona-server-client-5.5
2. percona-server-common-5.5
3. percona-server-server
4. percona-server-server-5.5

Here is my installed percona server:
aptitude show percona-server-server
Package: percona-server-server
New: yes
State: installed
Automatically installed: no
Version: 5.5.15-rel21.0-158.squeeze
Priority: extra
Section: database
…

forgot to say: debian squeeze…

thanks
schnix

[sterin71]

I don’t do Debian but I think you should be able to find a libdbd-mysql-perl package for mysql 5 instead. Since that package required and older version of MySQL than what you have installed.

Or if that fails try installing directly from CPAN instead:
DBD Installation with CPAN

[schnix]

thanks for your answer.

you said: the package requires an older version of mysql. i am pretty sure, that i read a changelog where a far older version supported mysql 5.5
anyway, upward incompatibility sounds very strange to me…

i am really no expert, but for me it looks like the libdbd-mysql-perl package does not know about percona and its compensate for mysql-common.
and i fear many others won’t, maybe i am wrong, but i wanted to ask here…

installing the module via cpan is only my last option, every other module that depends on dbd::mysql has to be installed via cpan later…
thats not very admin friendly, i like to stick with aptitude at all…

thanks
schnix

[brad22]

In my case change /etc/apt/apt.conf

APT::Default-Release “stable”;
to
APT::Default-Release “squeeze”;

look at /etc/apt/sources.list and /etc/apt/apt.conf

change any line containing stable to squeeze.

Explanation:
If you mix squeeze and stable. libmysqlclient16 ist stalled from the debian repo and not the percona repo. Therefore dependencies get mixed up.

Problem:
apt-get install libdbd-mysql-perl
Reading package lists… Done
Building dependency tree
Reading state information… Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
libdbd-mysql-perl : Depends: libmysqlclient16 (>= 5.1.21-1) but it is not going to be installed
E: Broken packages