Join the community today
Register Now

MariaDB AXIVO MariaDB10 Install

Discussion in 'MariaDB & General MySQL news & discussions' started by Matt, Jun 12, 2014.

  1. Matt

    Matt Well-Known Member

    903
    408
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +655
    Local Time:
    1:43 PM
    1.5.15
    MariaDB 10.2
    Just having a play with a test VPS:


    Code:
    [root@test centmin-v1.2.3mod]# yum --disablerepo=* --enablerepo=axivo list available | grep -i maria
    libmariadbclient16.x86_64                      5.2.14-1.el6                axivo
    libmariadbclient16-devel.x86_64                5.2.14-1.el6                axivo
    libmariadbclient18.x86_64                      1:10.0.11-1.el6             axivo
    libmariadbclient18-devel.x86_64                1:10.0.11-1.el6             axivo
    [root@test centmin-v1.2.3mod]# 
    But on my server:
    Code:
    [root@host ~]# yum --disablerepo=* --enablerepo=axivo list available | grep -i maria
    libmariadbclient16.x86_64                      5.2.14-1.el6                axivo
    libmariadbclient16-devel.x86_64                5.2.14-1.el6                axivo
    libmariadbclient18.x86_64                      1:10.0.11-1.el6             axivo
    libmariadbclient18-devel.x86_64                1:10.0.11-1.el6             axivo
    mariadb.x86_64                                 1:10.0.11-1.el6             axivo
    mariadb-bench.x86_64                           1:10.0.11-1.el6             axivo
    mariadb-devel.x86_64                           1:10.0.11-1.el6             axivo
    mariadb-embedded.x86_64                        1:10.0.11-1.el6             axivo
    mariadb-embedded-devel.x86_64                  1:10.0.11-1.el6             axivo
    mariadb-libs.x86_64                            1:10.0.11-1.el6             axivo
    mariadb-server.x86_64                          1:10.0.11-1.el6             axivo
    mariadb-test.x86_64                            1:10.0.11-1.el6             axivo
    Any idea why they'd be missing from the test VPS?
     
  2. eva2000

    eva2000 Administrator Staff Member

    50,452
    11,658
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,077
    Local Time:
    10:43 PM
    Nginx 1.25.x
    MariaDB 10.x
    @Matt, that's because Centmin Mod's default YUM priorities function (yumprioraxivo) also adds an exclude line to axivo.repo to make sure things don't get mixed up ;)

    Code:
    priority=13
    exclude=nginx* php* mariadb* memcached* xtrabackup
     
  3. Matt

    Matt Well-Known Member

    903
    408
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +655
    Local Time:
    1:43 PM
    1.5.15
    MariaDB 10.2
    Ah! That will be why. The dedicated server has the axivo added manually, where the test VPS is using the pre-installed one. (y)
     
  4. Matt

    Matt Well-Known Member

    903
    408
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +655
    Local Time:
    1:43 PM
    1.5.15
    MariaDB 10.2
    Code:
    [root@test yum.repos.d]# yum --disablerepo=* --enablerepo=axivo install mariadb.x86_64 mariadb-devel.x86_64 mariadb-server.x86_64 mariadb-test.x86_64
    Loaded plugins: downloadonly, fastestmirror, priorities
    Loading mirror speeds from cached hostfile
    Setting up Install Process
    Resolving Dependencies
    --> Running transaction check
    ---> Package mariadb.x86_64 1:10.0.11-1.el6 will be installed
    --> Processing Dependency: libjemalloc.so.1()(64bit) for package: 1:mariadb-10.0.11-1.el6.x86_64
    ---> Package mariadb-devel.x86_64 1:10.0.11-1.el6 will be installed
    ---> Package mariadb-server.x86_64 1:10.0.11-1.el6 will be installed
    --> Processing Dependency: libpcre.so.1()(64bit) for package: 1:mariadb-server-10.0.11-1.el6.x86_64
    --> Processing Dependency: libodbc.so.2()(64bit) for package: 1:mariadb-server-10.0.11-1.el6.x86_64
    ---> Package mariadb-test.x86_64 1:10.0.11-1.el6 will be installed
    --> Running transaction check
    ---> Package jemalloc.x86_64 0:3.6.0-1.el6 will be installed
    ---> Package mariadb-server.x86_64 1:10.0.11-1.el6 will be installed
    --> Processing Dependency: libodbc.so.2()(64bit) for package: 1:mariadb-server-10.0.11-1.el6.x86_64
    ---> Package pcre.x86_64 0:7.8-6.el6 will be updated
    --> Processing Dependency: libpcre.so.0()(64bit) for package: pcre-devel-7.8-6.el6.x86_64
    --> Processing Dependency: libpcre.so.0()(64bit) for package: less-436-10.el6.x86_64
    --> Processing Dependency: libpcre.so.0()(64bit) for package: grep-2.6.3-4.el6_5.1.x86_64
    --> Processing Dependency: libpcre.so.0()(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64
    --> Processing Dependency: pcre = 7.8-6.el6 for package: pcre-devel-7.8-6.el6.x86_64
    ---> Package pcre.x86_64 0:8.35-1.el6 will be an update
    --> Running transaction check
    ---> Package libpcre.x86_64 0:8.21-1.el6 will be installed
    ---> Package mariadb-server.x86_64 1:10.0.11-1.el6 will be installed
    --> Processing Dependency: libodbc.so.2()(64bit) for package: 1:mariadb-server-10.0.11-1.el6.x86_64
    ---> Package pcre-devel.x86_64 0:7.8-6.el6 will be updated
    ---> Package pcre-devel.x86_64 0:8.35-1.el6 will be an update
    ---> Package postfix.x86_64 2:2.6.6-6.el6_5 will be updated
    --> Processing Dependency: postfix = 2:2.6.6-6.el6_5 for package: 2:postfix-perl-scripts-2.6.6-6.el6_5.x86_64
    ---> Package postfix.x86_64 2:2.11.1-1.el6 will be an update
    --> Processing Dependency: libpq.so.5()(64bit) for package: 2:postfix-2.11.1-1.el6.x86_64
    --> Running transaction check
    ---> Package mariadb-server.x86_64 1:10.0.11-1.el6 will be installed
    --> Processing Dependency: libodbc.so.2()(64bit) for package: 1:mariadb-server-10.0.11-1.el6.x86_64
    ---> Package postfix.x86_64 2:2.11.1-1.el6 will be an update
    --> Processing Dependency: libpq.so.5()(64bit) for package: 2:postfix-2.11.1-1.el6.x86_64
    ---> Package postfix-perl-scripts.x86_64 2:2.6.6-6.el6_5 will be updated
    ---> Package postfix-perl-scripts.x86_64 2:2.11.1-1.el6 will be an update
    --> Finished Dependency Resolution
    Error: Package: 1:mariadb-server-10.0.11-1.el6.x86_64 (axivo)
               Requires: libodbc.so.2()(64bit)
    Error: Package: 2:postfix-2.11.1-1.el6.x86_64 (axivo)
               Requires: libpq.so.5()(64bit)
    You could try using --skip-broken to work around the problem
    You could try running: rpm -Va --nofiles --nodigest
    [root@test yum.repos.d]# yum --enablerepo=axivo install mariadb.x86_64 mariadb-devel.x86_64 mariadb-server.x86_64 mariadb-test.x86_64
    Loaded plugins: downloadonly, fastestmirror, priorities
    Loading mirror speeds from cached hostfile
    * base: centos.mirror1.spango.com
    * epel: nl.mirror.eurid.eu
    * extras: centos.mirror1.spango.com
    * rpmforge: nl.mirror.eurid.eu
    * updates: mirror.amsiohosting.net
    1632 packages excluded due to repository priority protections
    Setting up Install Process
    Resolving Dependencies
    --> Running transaction check
    ---> Package mariadb.x86_64 1:10.0.11-1.el6 will be installed
    --> Processing Dependency: libjemalloc.so.1()(64bit) for package: 1:mariadb-10.0.11-1.el6.x86_64
    ---> Package mariadb-devel.x86_64 1:10.0.11-1.el6 will be installed
    ---> Package mariadb-server.x86_64 1:10.0.11-1.el6 will be installed
    --> Processing Dependency: libpcre.so.1()(64bit) for package: 1:mariadb-server-10.0.11-1.el6.x86_64
    --> Processing Dependency: libodbc.so.2()(64bit) for package: 1:mariadb-server-10.0.11-1.el6.x86_64
    ---> Package mariadb-test.x86_64 1:10.0.11-1.el6 will be installed
    --> Running transaction check
    ---> Package jemalloc.x86_64 0:3.6.0-1.el6 will be installed
    ---> Package mariadb-server.x86_64 1:10.0.11-1.el6 will be installed
    --> Processing Dependency: libpcre.so.1()(64bit) for package: 1:mariadb-server-10.0.11-1.el6.x86_64
    ---> Package unixODBC.x86_64 0:2.2.14-12.el6_3 will be installed
    --> Finished Dependency Resolution
    Error: Package: 1:mariadb-server-10.0.11-1.el6.x86_64 (axivo)
               Requires: libpcre.so.1()(64bit)
    You could try using --skip-broken to work around the problem
    You could try running: rpm -Va --nofiles --nodigest
    [root@test yum.repos.d]# yum --disablerepo=* --enablerepo=axivo list available | grep pcre
    libpcre.x86_64                                 8.21-1.el6                  axivo
    libpcre-devel.x86_64                           8.21-1.el6                  axivo
    pcre.x86_64                                    8.35-1.el6                  axivo
    pcre-devel.x86_64                              8.35-1.el6                  axivo
    pcre-static.x86_64                             8.35-1.el6                  axivo
    pcre-tools.x86_64                              8.35-1.el6                  axivo
    [root@test yum.repos.d]# yum list installed | grep pcre
    pcre.x86_64            7.8-6.el6        @anaconda-CentOS-201311272149.x86_64/6.5
    pcre-devel.x86_64      7.8-6.el6        @base                                  
    [root@test yum.repos.d]# yum --disablerepo=* --enablerepo=axivo install libpcre.x86_64 libpcre-devel.x86_64
    Loaded plugins: downloadonly, fastestmirror, priorities
    Loading mirror speeds from cached hostfile
    Setting up Install Process
    Resolving Dependencies
    --> Running transaction check
    ---> Package libpcre.x86_64 0:8.21-1.el6 will be installed
    ---> Package libpcre-devel.x86_64 0:8.21-1.el6 will be installed
    --> Finished Dependency Resolution
    
    Dependencies Resolved
    
    ==============================================================================================================
    Package                       Arch                   Version                     Repository             Size
    ==============================================================================================================
    Installing:
    libpcre                       x86_64                 8.21-1.el6                  axivo                 443 k
    libpcre-devel                 x86_64                 8.21-1.el6                  axivo                 170 k
    
    Transaction Summary
    ==============================================================================================================
    Install       2 Package(s)
    
    Total download size: 613 k
    Installed size: 1.6 M
    Is this ok [y/N]: y
    Downloading Packages:
    (1/2): libpcre-8.21-1.el6.x86_64.rpm                                                   | 443 kB     00:00    
    (2/2): libpcre-devel-8.21-1.el6.x86_64.rpm                                             | 170 kB     00:00    
    --------------------------------------------------------------------------------------------------------------
    Total                                                                         446 kB/s | 613 kB     00:01    
    Running rpm_check_debug
    Running Transaction Test
    
    
    Transaction Check Error:
      file /lib64/libpcre.so.0.0.1 from install of libpcre-8.21-1.el6.x86_64 conflicts with file from package pcre-7.8-6.el6.x86_64
      file /usr/share/man/man1/pcre-config.1.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-7.8-6.el6.x86_64
      file /usr/bin/pcre-config from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/include/pcre.h from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/include/pcre_scanner.h from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/include/pcre_stringpiece.h from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/include/pcrecpp.h from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/include/pcrecpparg.h from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/include/pcreposix.h from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/lib64/pkgconfig/libpcre.pc from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/lib64/pkgconfig/libpcrecpp.pc from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_compile.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_compile2.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_config.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_copy_named_substring.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_copy_substring.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_dfa_exec.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_exec.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_free_substring.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_free_substring_list.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_fullinfo.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_get_named_substring.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_get_stringnumber.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_get_stringtable_entries.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_get_substring.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_get_substring_list.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_info.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_maketables.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_refcount.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_study.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcre_version.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcreapi.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcrebuild.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcrecallout.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcrecompat.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcrecpp.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcrematching.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcrepartial.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcrepattern.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcreperform.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcreposix.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcreprecompile.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcresample.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcrestack.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
      file /usr/share/man/man3/pcresyntax.3.gz from install of libpcre-devel-8.21-1.el6.x86_64 conflicts with file from package pcre-devel-7.8-6.el6.x86_64
    
    Error Summary
    -------------
    
    [root@test yum.repos.d]# yum list installed | grep pcre
    pcre.x86_64            7.8-6.el6        @anaconda-CentOS-201311272149.x86_64/6.5
    pcre-devel.x86_64      7.8-6.el6        @base                                  
    [root@test yum.repos.d]# yum --disablerepo=* --enablerepo=axivo update pcre
    Loaded plugins: downloadonly, fastestmirror, priorities
    Loading mirror speeds from cached hostfile
    Setting up Update Process
    Resolving Dependencies
    --> Running transaction check
    ---> Package pcre.x86_64 0:7.8-6.el6 will be updated
    --> Processing Dependency: libpcre.so.0()(64bit) for package: pcre-devel-7.8-6.el6.x86_64
    --> Processing Dependency: libpcre.so.0()(64bit) for package: less-436-10.el6.x86_64
    --> Processing Dependency: libpcre.so.0()(64bit) for package: grep-2.6.3-4.el6_5.1.x86_64
    --> Processing Dependency: libpcre.so.0()(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64
    --> Processing Dependency: pcre = 7.8-6.el6 for package: pcre-devel-7.8-6.el6.x86_64
    ---> Package pcre.x86_64 0:8.35-1.el6 will be an update
    --> Running transaction check
    ---> Package libpcre.x86_64 0:8.21-1.el6 will be installed
    ---> Package pcre-devel.x86_64 0:7.8-6.el6 will be updated
    ---> Package pcre-devel.x86_64 0:8.35-1.el6 will be an update
    ---> Package postfix.x86_64 2:2.6.6-6.el6_5 will be updated
    --> Processing Dependency: postfix = 2:2.6.6-6.el6_5 for package: 2:postfix-perl-scripts-2.6.6-6.el6_5.x86_64
    ---> Package postfix.x86_64 2:2.11.1-1.el6 will be an update
    --> Processing Dependency: libpq.so.5()(64bit) for package: 2:postfix-2.11.1-1.el6.x86_64
    --> Running transaction check
    ---> Package postfix.x86_64 2:2.11.1-1.el6 will be an update
    --> Processing Dependency: libpq.so.5()(64bit) for package: 2:postfix-2.11.1-1.el6.x86_64
    ---> Package postfix-perl-scripts.x86_64 2:2.6.6-6.el6_5 will be updated
    ---> Package postfix-perl-scripts.x86_64 2:2.11.1-1.el6 will be an update
    --> Finished Dependency Resolution
    Error: Package: 2:postfix-2.11.1-1.el6.x86_64 (axivo)
               Requires: libpq.so.5()(64bit)
    You could try using --skip-broken to work around the problem
    You could try running: rpm -Va --nofiles --nodigest
    [root@test yum.repos.d]# 
     
  5. Matt

    Matt Well-Known Member

    903
    408
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +655
    Local Time:
    1:43 PM
    1.5.15
    MariaDB 10.2
    Got there in the end:
    Code:
    [root@test yum.repos.d]# mysql -v
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 8
    Server version: 10.0.11-MariaDB AXIVO
    
    Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
    
    Reading history-file /root/.mysql_history
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
     
  6. rdan

    rdan Well-Known Member

    5,419
    1,386
    113
    May 25, 2014
    Ratings:
    +2,167
    Local Time:
    8:43 PM
    Mainline
    10.2
    Can you please show the complete list of command to fix all those error dependencies?
    Thanks Matt!
     
  7. Matt

    Matt Well-Known Member

    903
    408
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +655
    Local Time:
    1:43 PM
    1.5.15
    MariaDB 10.2
    Code:
       35  yum --disablerepo=* --enablerepo=axivo install mariadb-server.x86_64
       36  yum --disablerepo=* --enablerepo=axivo list available
       37  yum --disablerepo=* --enablerepo=axivo update
       38  yum list installed | grep ^mysql
       39  yum list installed | grep ^Maria
       40  yum --disablerepo=* --enablerepo=axivo list available
       41  yum clean all
       42  yum --disablerepo=* --enablerepo=axivo clean all
       43  yum --disablerepo=* --enablerepo=axivo list available
       44  yum --disablerepo=* --enablerepo=axivo list available | grep - maria
       45  yum --disablerepo=* --enablerepo=axivo list available | grep -i maria
       46  vim /etc/yum.conf
       47  cd /etc/yum.repos.d/
       48  ls
       49  vim axivo.repo
       50  yum --disablerepo=* --enablerepo=axivo list available
       51  yum list installed | grep jemalloc
       52  vim axivo.repo
       53  yum --disablerepo=* --enablerepo=axivo list available
       54  yum list installed | grep -i Maria
       55  yum remove MariaDB-client.x86_64 MariaDB-common.x86_64  MariaDB-devel.x86_64 MariaDB-server.x86_64 MariaDB-shared.x86_64
       56  rpm -qa | grep -i maria
       57  rpm -e --nodeps MariaDB-client-10.0.11-1.el6.x86_64 MariaDB-compat-10.0.11-1.el6.x86_64 MariaDB-shared-10.0.11-1.el6.x86_64 MariaDB-devel-10.0.11-1.el6.x86_64 MariaDB-server-10.0.11-1.el6.x86_64
       58  rpm -qa | grep -i mysql
       59  yum --enablerepo=axivo install libmariadbclient16
       60  yum --disablerepo=* --enablerepo=axivo install libmariadbclient16
       61  yum --enablerepo=axivo install libmariadbclient16
       62  yum --enablerepo=axivo install mariadb-libs
       63  yum list intalled | grep -i maria
       64  yum --disablerepo=* --enablerepo=axivo install mariadb-libs
       65  yum list installed | grep mysql
       66  yum list installed | grep ^mysql
       67  yum list installed | grep -i maria
       68  yum remove MariaDB-common.x86_64
       69  yum --disablerepo=* --enablerepo=axivo install mariadb-libs
       70  yum --disablerepo=* --enablerepo=axivo list available | grep maria
       71  yum --disablerepo=* --enablerepo=axivo install mariadb.x86_64 mariadb-devel.x86_64 mariadb-server.x86_64 mariadb-test.x86_64
       72  yum --enablerepo=axivo install mariadb.x86_64 mariadb-devel.x86_64 mariadb-server.x86_64 mariadb-test.x86_64
       73  yum --disablerepo=* --enablerepo=axivo list available | grep pcre
       74  yum list installed | grep pcre
       75  yum --disablerepo=* --enablerepo=axivo install libpcre.x86_64 libpcre-devel.x86_64
       76  yum list installed | grep pcre
       77  yum --disablerepo=* --enablerepo=axivo update pcre
       78  yum list *libpq*
       79  yum list *postgre*
       80  yum install postgresql-libs.x86_64
       81  yum --disablerepo=* --enablerepo=axivo update pcre
       82  yum --disablerepo=* --enablerepo=axivo install libpcre.x86_64 libpcre-devel.x86_64
       83  ps -ef
       84  yum --enablerepo=axivo install mariadb.x86_64 mariadb-devel.x86_64 mariadb-server.x86_64 mariadb-test.x86_64
       85  service mysql restart
       86  service mysqld restart
     
  8. rdan

    rdan Well-Known Member

    5,419
    1,386
    113
    May 25, 2014
    Ratings:
    +2,167
    Local Time:
    8:43 PM
    Mainline
    10.2
    That is a long list :D
    I'm afraid I might encounter another error, so I'm not touching anything for now, Thanks for the list Matt!
     
  9. Matt

    Matt Well-Known Member

    903
    408
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +655
    Local Time:
    1:43 PM
    1.5.15
    MariaDB 10.2
    This was on a test VPS, so I didn't mind breaking things to get it working.

    Ultimately:

    Uninstall the existing MariaDB setup:

    Code:
    rpm -e --nodeps MariaDB-client-10.0.11-1.el6.x86_64 MariaDB-compat-10.0.11-1.el6.x86_64 MariaDB-shared-10.0.11-1.el6.x86_64 MariaDB-devel-10.0.11-1.el6.x86_64 MariaDB-server-10.0.11-1.el6.x86_64 MariaDB-common-10.0.11-1.el6.x86_64
    Initial errors were due to libraries needed that are provided by postgresql

    Code:
    yum install postgresql-libs.x86_64
    Update PCRE to the AXIVO version
    Code:
    yum --disablerepo=* --enablerepo=axivo update pcre
    yum --disablerepo=* --enablerepo=axivo install libpcre.x86_64 libpcre-devel.x86_64
    and then install the new MariaDB
    Code:
    yum --enablerepo=axivo install mariadb.x86_64 mariadb-devel.x86_64 mariadb-server.x86_64 mariadb-test.x86_64
     
  10. rdan

    rdan Well-Known Member

    5,419
    1,386
    113
    May 25, 2014
    Ratings:
    +2,167
    Local Time:
    8:43 PM
    Mainline
    10.2
    I'm tempted to do it live but MariaDb 10.0.12 is coming today :)
     
  11. Matt

    Matt Well-Known Member

    903
    408
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +655
    Local Time:
    1:43 PM
    1.5.15
    MariaDB 10.2
    I've moved these posts into their own Thread.
     
  12. Floren

    Floren Active Member

    148
    77
    28
    Jun 6, 2014
    Ratings:
    +77
    Local Time:
    8:43 AM
    @Matt, you get those errors because you disable the default CentOS repositories, why do you do that? As I explained in my tutorial, you should have all external repos disabled by default and enable them when you need them only. Like you do with --enablerepo=axivo. You should NEVER disable the official repositories, unless you have a local repo synced and you deploy from it the packages to multiple servers (i.e. update 100 servers from local repo to save bandwidth).
    Code:
    # yum --enablerepo=axivo clean all
    # yum --enablerepo=axivo install mariadb-server
    That's all you need, it will add automatically all deps for you. These errors you get are related to postgresql-libs and unixODBC missing packages, which are available into default CentOS repo:
    Code:
    Error: Package: 1:mariadb-server-10.0.11-1.el6.x86_64 (axivo)
               Requires: libodbc.so.2()(64bit)
    Error: Package: 2:postfix-2.11.1-1.el6.x86_64 (axivo)
               Requires: libpq.so.5()(64bit)
    Also, read this tutorial how to properly upgrade to MariaDB 10 in a RHEL6 based distribution.

    Edit: I enabled OQGraph support in MariaDB 10.0.12. :)
     
    Last edited: Jun 22, 2014
  13. rdan

    rdan Well-Known Member

    5,419
    1,386
    113
    May 25, 2014
    Ratings:
    +2,167
    Local Time:
    8:43 PM
    Mainline
    10.2
    Now I got this:
     
  14. eva2000

    eva2000 Administrator Staff Member

    50,452
    11,658
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,077
    Local Time:
    10:43 PM
    Nginx 1.25.x
    MariaDB 10.x
  15. rdan

    rdan Well-Known Member

    5,419
    1,386
    113
    May 25, 2014
    Ratings:
    +2,167
    Local Time:
    8:43 PM
    Mainline
    10.2
  16. eva2000

    eva2000 Administrator Staff Member

    50,452
    11,658
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,077
    Local Time:
    10:43 PM
    Nginx 1.25.x
    MariaDB 10.x
    doh forgot you need this line too as it's excluded by default so as to not conflict and mess up the default MariaDB YUM repo and installs ;) @Floren might need to update his guide for Centmin Mod folks :)

    Code:
    --disableexcludes=axivo
    as I see the mariadb-server package fine

    Code:
    yum --disablerepo=* --enablerepo=axivo list available --disableexcludes=axivo | grep mariadb
    libmariadbclient16.x86_64    5.2.14-1.el6    axivo
    libmariadbclient16-devel.x86_64    5.2.14-1.el6    axivo
    libmariadbclient18.x86_64    1:10.0.12-1.el6 axivo
    libmariadbclient18-devel.x86_64    1:10.0.12-1.el6 axivo
    mariadb.x86_64   1:10.0.12-1.el6 axivo
    mariadb-bench.x86_64   1:10.0.12-1.el6 axivo
    mariadb-devel.x86_64   1:10.0.12-1.el6 axivo
    mariadb-embedded.x86_641:10.0.12-1.el6 axivo
    mariadb-embedded-devel.x86_641:10.0.12-1.el6 axivo
    mariadb-libs.x86_64    1:10.0.12-1.el6 axivo
    mariadb-server.x86_64  1:10.0.12-1.el6 axivo
    mariadb-test.x86_64    1:10.0.12-1.el6 axivo
     
  17. rdan

    rdan Well-Known Member

    5,419
    1,386
    113
    May 25, 2014
    Ratings:
    +2,167
    Local Time:
    8:43 PM
    Mainline
    10.2
    Yes, I saw it also on my server, looks like my command lately was wrong :)
    Thanks!
    For now I'll stick to default mariadb repo as my forum is already using it live.
     
  18. Floren

    Floren Active Member

    148
    77
    28
    Jun 6, 2014
    Ratings:
    +77
    Local Time:
    8:43 AM
    I think is best you post a note in your setup procedure? Thanks George.
     
  19. eva2000

    eva2000 Administrator Staff Member

    50,452
    11,658
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,077
    Local Time:
    10:43 PM
    Nginx 1.25.x
    MariaDB 10.x
    indeed indeed :)