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

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Duplicate
    • 5.5.28a-galera
    • None
    • None
    • None
    • 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

      Attachments

        Activity

          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

          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

          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

          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

          >> 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.

          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.
          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.

          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.

          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

          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

          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.

          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.

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

          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 .

          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

          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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.