Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4079

MariaDB Galera server 5.5 installation issue on fresh precise Ubuntu distro (wrong dependencies)

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Duplicate
    • Affects Version/s: 5.5.28a-galera
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      fresh Ubuntu 12.04.1 precise distro

      Description

      After setting-up a new fresh precise Ubuntu distro with the minimum package, I'm not able to install the mariadb-galera-server by the command :

      aptitude -y install mariadb-galera-server galera

      here are the error messages :

      The following packages have unmet dependencies:
      mysql-common : Breaks: mysql-client-5.1 which is a virtual package.
      Breaks: mysql-client-core-5.1 which is a virtual package.
      Breaks: mysql-server-core-5.1 which is a virtual package.
      libmariadbclient18 : Depends: libmysqlclient18 (= 5.5.28-mariadb-a1~precise) but 5.5.29-0ubuntu0.12.04.1 is to be installed.
      The following actions will resolve these dependencies:

      Keep the following packages at their current version:
      1) libmariadbclient18 [Not Installed]
      2) mariadb-client-5.5 [Not Installed]
      3) mariadb-client-core-5.5 [Not Installed]
      4) mariadb-galera-server [Not Installed]
      5) mariadb-galera-server-5.5 [Not Installed]

      I've read some posts on the mysql-common issue but I've never seen any solution. As this distro is a fresh one and I did not install any extra packages, I do not understand why it is blocking with the dependencies...

      Is there any good tricks I've missed ?

      Thanks for your help

      Nicolas

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            elenst Elena Stepanova added a comment -

            For libmysqlclient 5.5.28 vs 5.5.29 part, there is work in progress in MDEV-3882 and some discussion and explanation here https://lists.launchpad.net/maria-discuss/msg00699.html

            Show
            elenst Elena Stepanova added a comment - For libmysqlclient 5.5.28 vs 5.5.29 part, there is work in progress in MDEV-3882 and some discussion and explanation here https://lists.launchpad.net/maria-discuss/msg00699.html
            Hide
            nmenoux Nicolas MENOUX added a comment -

            Thanks Elena ro the reference but at the time beeing it seems not possible to run mariaDB-galera server on ubuntu,
            I've tested on a CentOS 6 box and installation process is successful. I try to follow some tutorial for setting up a cluster with 2 nodes but as it was done on ubunutu server, I'm quite confused with the cnf files. In CentOS, the my.cnf includes files within my.cnf.d. There, I do not know exactly where to put directives into the server.cnf file as there is different section, do I have to put the galera directive for the cluster within the mysql section or maria-db or mariadb-5.5... I'm quite confused.

            Thanks.

            Nicolas

            Show
            nmenoux Nicolas MENOUX added a comment - Thanks Elena ro the reference but at the time beeing it seems not possible to run mariaDB-galera server on ubuntu, I've tested on a CentOS 6 box and installation process is successful. I try to follow some tutorial for setting up a cluster with 2 nodes but as it was done on ubunutu server, I'm quite confused with the cnf files. In CentOS, the my.cnf includes files within my.cnf.d. There, I do not know exactly where to put directives into the server.cnf file as there is different section, do I have to put the galera directive for the cluster within the mysql section or maria-db or mariadb-5.5... I'm quite confused. Thanks. Nicolas
            Hide
            elenst Elena Stepanova added a comment -

            >> at the time beeing it seems not possible to run mariaDB-galera server on ubuntu,

            I'm checking installation on a fresh precise right now, will update when done.

            Show
            elenst Elena Stepanova added a comment - >> at the time beeing it seems not possible to run mariaDB-galera server on ubuntu, I'm checking installation on a fresh precise right now, will update when done.
            Hide
            elenst Elena Stepanova added a comment - - edited

            It looks like the only real problem is the one about libmysqlclient18, which is the same as MDEV-3882, and has the same workaround, see or example https://lists.launchpad.net/maria-discuss/msg00698.html
            With aptitude, the following command works for me:

            sudo aptitude -y install mariadb-galera-server-5.5 libmysqlclient18=5.5.28-mariadb-a1~precise mysql-common=5.5.28-mariadb-a1~precise

            (assuming the galera library was already installed by the previous attempt)

            Please try it out.

            In regard to CentOS configs, it only uses ones from /etc/my.cnf.d/ because the top config /etc/my.cnf says to do so (it has includedir). You can add your galera configuration to any server-only section, be it mysqld, mariadb, mysqld-5.5, mariadb-5.5, into any cnf file, or create one of your own.

            Show
            elenst Elena Stepanova added a comment - - edited It looks like the only real problem is the one about libmysqlclient18, which is the same as MDEV-3882 , and has the same workaround, see or example https://lists.launchpad.net/maria-discuss/msg00698.html With aptitude, the following command works for me: sudo aptitude -y install mariadb-galera-server-5.5 libmysqlclient18=5.5.28-mariadb-a1~precise mysql-common=5.5.28-mariadb-a1~precise (assuming the galera library was already installed by the previous attempt) Please try it out. In regard to CentOS configs, it only uses ones from /etc/my.cnf.d/ because the top config /etc/my.cnf says to do so (it has includedir). You can add your galera configuration to any server-only section, be it mysqld, mariadb, mysqld-5.5, mariadb-5.5, into any cnf file, or create one of your own.
            Hide
            nmenoux Nicolas MENOUX added a comment -

            Thanks a lot Elena, your last aptitude command line is working on my new Ubunutu. I will now work on the cluster configuration. BTW, is there any good tutorial to set up a MariaDB galera cluster from scratch ?

            Thanks.

            Nicolas

            Show
            nmenoux Nicolas MENOUX added a comment - Thanks a lot Elena, your last aptitude command line is working on my new Ubunutu. I will now work on the cluster configuration. BTW, is there any good tutorial to set up a MariaDB galera cluster from scratch ? Thanks. Nicolas
            Hide
            elenst Elena Stepanova added a comment -

            There is Codership wiki for Galera http://www.codership.com/wiki/doku.php which has a lot of useful information, unfortunately its structure is not very obvious so it might be difficult to find what you're looking for.

            Here is a presentation from Codership, IIRC it has configuration steps inside: http://www.slideshare.net/henrikingo/introduction-to-galera

            Some time ago I ran onto this blog article http://www.sebastien-han.fr/blog/2012/04/01/mysql-multi-master-replication-with-galera/ which I found very good back then. It might be a little outdated by now (or maybe not, I didn't check), but I think it's still a useful read.

            Show
            elenst Elena Stepanova added a comment - There is Codership wiki for Galera http://www.codership.com/wiki/doku.php which has a lot of useful information, unfortunately its structure is not very obvious so it might be difficult to find what you're looking for. Here is a presentation from Codership, IIRC it has configuration steps inside: http://www.slideshare.net/henrikingo/introduction-to-galera Some time ago I ran onto this blog article http://www.sebastien-han.fr/blog/2012/04/01/mysql-multi-master-replication-with-galera/ which I found very good back then. It might be a little outdated by now (or maybe not, I didn't check), but I think it's still a useful read.
            Hide
            elenst Elena Stepanova added a comment -

            Since installation worked with the workaround for MDEV-3882, I'm closing this report as a duplicate of MDEV-3882.

            Show
            elenst Elena Stepanova added a comment - Since installation worked with the workaround for MDEV-3882 , I'm closing this report as a duplicate of MDEV-3882 .
            Hide
            nmenoux Nicolas MENOUX added a comment -

            Thanks Helena for all these useful links and information, I've found another one which could be interesting also : http://edin.no-ip.com/blog/hswong3i/mariadb-galera-mastermaster-replication-ubuntu-12-04-howto

            Regards,

            Nicolas

            Show
            nmenoux Nicolas MENOUX added a comment - Thanks Helena for all these useful links and information, I've found another one which could be interesting also : http://edin.no-ip.com/blog/hswong3i/mariadb-galera-mastermaster-replication-ubuntu-12-04-howto Regards, Nicolas

              People

              • Assignee:
                Unassigned
                Reporter:
                nmenoux Nicolas MENOUX
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: