Want more timely Centmin Mod News Updates?
Become a Member

MariaDB AXIVO MariaDB10 Install

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

  1. Matt

    Matt Well-Known Member

    932
    415
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +671
    Local Time:
    3:57 AM
    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

    54,906
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,811
    Local Time:
    1:57 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    @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

    932
    415
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +671
    Local Time:
    3:57 AM
    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

    932
    415
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +671
    Local Time:
    3:57 AM
    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

    932
    415
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +671
    Local Time:
    3:57 AM
    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,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    11:57 AM
    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

    932
    415
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +671
    Local Time:
    3:57 AM
    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,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    11:57 AM
    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

    932
    415
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +671
    Local Time:
    3:57 AM
    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,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    11:57 AM
    Mainline
    10.2
    I'm tempted to do it live but MariaDb 10.0.12 is coming today :)
     
  11. Matt

    Matt Well-Known Member

    932
    415
    63
    May 25, 2014
    Rotherham, UK
    Ratings:
    +671
    Local Time:
    3:57 AM
    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:
    11:57 PM
    @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,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    11:57 AM
    Mainline
    10.2
    Now I got this:
     
  14. eva2000

    eva2000 Administrator Staff Member

    54,906
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,811
    Local Time:
    1:57 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  15. rdan

    rdan Well-Known Member

    5,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    11:57 AM
    Mainline
    10.2
  16. eva2000

    eva2000 Administrator Staff Member

    54,906
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,811
    Local Time:
    1:57 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    11:57 AM
    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:
    11:57 PM
    I think is best you post a note in your setup procedure? Thanks George.
     
  19. eva2000

    eva2000 Administrator Staff Member

    54,906
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,811
    Local Time:
    1:57 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    indeed indeed :)