libdbd-mysql-perl woes on Ubuntu 9.04 (Jaunty) 64bit

[Morgan]

Hi,

I'm stuck trying to install Percona 5.1 on 64bit Jaunty in such a way
that I can't actually get libdbd-mysql-perl installed alongside it.
Ultimately I seem to keep getting stuck on an unmet dependency for
libmysqlclient15off.

I have seen various postings about similar issues on the group, but
nothing that specifically works for me. I'm doing the installation
using apt, with the appropriate repositories set in my sources.list

deb http://repo.percona.com/apt jaunty main
deb-src http://repo.percona.com/apt jaunty main

The previous thread here (from 2009)
http://groups.google.com/group/percona-discussion/browse_thread/thread/2c479fcbebc3f7db/54d258880df99f5b?lnk=gst&q=perl#54d258880df99f5b
had some suggestions to install things in a certain order. I have
tried this (using apt and the current Percona versions) but it didn't
resolve the issue.

Could anyone recommend a method to get this working, or at least
confirm that it can't be done using straightforward .deb packages on
my OS/Percona combination?

Thanks,
Morgan

[Haidong Ji]

Morgan,

I think there is a package called Percona-Server-shared-compat, which has all the library and header files to satisfy DBI and DBD::MySQL. Install that should take care of things, in my experience.

Haidong "Alex" Ji

--
You received this message because you are subscribed to the Google Groups "Percona Discussion" group.
To post to this group, send email to percona-d...@googlegroups.com.
To unsubscribe from this group, send email to percona-discuss...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/percona-discussion?hl=en.

[Morgan]

Hi Ji,

Thanks for the reply. I originally thought the same thing, but when I
researched it this package does not exist on Debian/Ubuntu systems
(it's a RedHat/yum package only). Apparently it's not supposed to be
needed. This is discussed here:
http://groups.google.com/group/percona-discussion/browse_thread/thread/f6971b15b9baee8c/7a3524b39e73eca6?hl=en&lnk=gst&q=perl#7a3524b39e73eca6

Regards,
Morgan

On Apr 29, 12:40 pm, Haidong Ji <haidong...@gmail.com> wrote:
> Morgan,
>
> I think there is a package called Percona-Server-shared-compat, which has
> all the library and header files to satisfy DBI and DBD::MySQL. Install that
> should take care of things, in my experience.
>
> Haidong "Alex" Ji
>

> On Thu, Apr 28, 2011 at 7:10 PM, Morgan <morgan.p...@gmail.com> wrote:
> > Hi,
>
> > I'm stuck trying to install Percona 5.1 on 64bit Jaunty in such a way
> > that I can't actually get libdbd-mysql-perl installed alongside it.
> > Ultimately I seem to keep getting stuck on an unmet dependency for
> > libmysqlclient15off.
>
> > I have seen various postings about similar issues on the group, but
> > nothing that specifically works for me. I'm doing the installation
> > using apt, with the appropriate repositories set in my sources.list
>
> > debhttp://repo.percona.com/aptjaunty main

> > deb-srchttp://repo.percona.com/aptjaunty main

>
> > The previous thread here (from 2009)
>

> >http://groups.google.com/group/percona-discussion/browse_thread/threa...

[Haidong Ji]

Morgan,

I was speaking from the experience on CentOS, you are right.

But you got me curious, so I fired up a brand-new Karmic (Janty is not available). After following instructions here, http://www.percona.com/docs/wiki/repositories:apt

I did

apt-cache search "percona"

to have some general idea of what Percona repository has. I then installed the following without problems (libdbi-perl is part of percona-server-client):

root@karmic:~# apt-get install percona-server-client
root@karmic:~# apt-get install libdbd-mysql-perl

Regards,
Haidong "Alex" Ji

[Morgan]

I managed to get this installed and working. I just fired up a brand-
new 9.04 64-bit VM to test it again since I hate threads on the
internet that hang without resolution, so I'll post the steps I took.

Switching from apt to aptitude and using some of it's suggestions seem
to have fixed the problem.

Step 1:

aptitude install percona-server-common

Step 2:

aptitude install maatkit


This will then complain as follows:

Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading extended state information
Initializing package states... Done
The following packages are BROKEN:
percona-server-common
The following NEW packages will be installed:
libdbd-mysql-perl{a} libdbi-perl{a} libmysqlclient15off{a} libnet-
daemon-perl{a} libplrpc-perl{a} maatkit mysql-common{a}
0 packages upgraded, 7 newly installed, 0 to remove and 59 not
upgraded.
Need to get 4450kB of archives. After unpacking 12.5MB will be used.
The following packages have unmet dependencies:
percona-server-common: Conflicts: mysql-common but
5.1.30really5.0.75-0ubuntu10.5 is to be installed.
The following actions will resolve these dependencies:

Remove the following packages:
percona-server-common

Score is 119


Accept this solution? [Y/n/q/?] n
The following actions will resolve these dependencies:

Install the following packages:
libmysqlclient15off [5.0.91-percona-b22.jaunty.5 (<NULL>)]

Keep the following packages at their current version:
mysql-common [Not Installed]

Score is 29

Accept this solution? [Y/n/q/?] y



Once I accepted the second offered solution, the rest of the pieces
installed without problem and I could complete my installation with
the rest of these packages and have a working Perl DBI, Maatkit etc:

$ aptitude install percona-server-client
$ aptitude install percona-server-server
$ aptitude install xtrabackup


Hope this help somebody.