Announcement

Announcement Module
Collapse
No announcement yet.

libdbd-mysql-perl / libmysqlclient16/18

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • libdbd-mysql-perl / libmysqlclient16/18

    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

  • #2
    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

    Comment


    • #3
      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

      Comment


      • #4
        schnix wrote on Fri, 23 September 2011 21:50
        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...
        Sorry my bad, what I meant was that it required an older version of the MySQL client library. Not he MySQL server itself, the backward compatibility between client library and MySQL server is as you say pretty good.

        So what happens is that you have installed MySQL 5.5 (Percona) which provides the libmysqlclient18 while your DBD package is compiled against libmysqlclient16 which was part of the MySQL 5.1 version IIRC.

        Basically I think you should be good if you just install the
        libmysqlclient16
        package and skip the mysql-common (even if your package manager complains about it).

        And yes I agree with you that package management is nicer than CPAN (especially when your behind a firewall that don't allow outward traffic, have hit that a bunch of times )

        Good luck!

        Comment


        • #5
          thanks again for your reply.

          i followed your suggest to install libmysqlclient16, ignoring the mysql-common module...

          aptitude install libmysqlclient16
          The following NEW packages will be installed:
          libmysqlclient16 mysql-common{a}
          0 packages upgraded, 2 newly installed, 0 to remove and 1 not upgraded.
          Need to get 1,982 kB of archives. After unpacking 4,296 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



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

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



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

          Install the following packages:
          1) libmysqlclient16 [5.1.57-rel12.8-233.squeeze ()]

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



          Accept this solution? [Y/n/q/?] Y
          The following NEW packages will be installed:
          libmysqlclient16
          0 packages upgraded, 1 newly installed, 0 to remove and 1 not upgraded.
          Need to get 1,992 kB of archives. After unpacking 4,604 kB will be used.
          Do you want to continue? [Y/n/?] Y
          Get:1 http://repo.percona.com/apt/ squeeze/main libmysqlclient16 i386 5.1.57-rel12.8-233.squeeze [1,992 kB]
          Fetched 1,992 kB in 4s (425 kB/s)
          Selecting previously deselected package libmysqlclient16.
          (Reading database ... 133938 files and directories currently installed.)
          Unpacking libmysqlclient16 (from .../libmysqlclient16_5.1.57-rel12.8-233.squeeze_i386.deb) ...
          Setting up libmysqlclient16 (5.1.57-rel12.8-233.squeeze) ...

          root@squeeze:/home/schnix# aptitude install libdbd-mysql-perl
          The following NEW packages will be installed:
          libdbd-mysql-perl
          0 packages upgraded, 1 newly installed, 0 to remove and 2 not upgraded.
          Need to get 138 kB of archives. After unpacking 434 kB will be used.
          Get:1 http://ftp.de.debian.org/debian/ squeeze/main libdbd-mysql-perl i386 4.016-1 [138 kB]
          Fetched 138 kB in 1s (123 kB/s)
          Selecting previously deselected package libdbd-mysql-perl.
          (Reading database ... 133945 files and directories currently installed.)
          Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.016-1_i386.deb) ...
          Processing triggers for man-db ...
          Setting up libdbd-mysql-perl (4.016-1) ...


          i hope that does not cause any further problems

          thanks again
          schnix

          Comment


          • #6
            In my case change /etc/apt/apt.conf

            APT:efault-Release "stable";
            to
            APT:efault-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

            Comment

            Working...
            X