Forums

Resolved
0 votes
Hello,

I installed a brand new ClearOs using AWS AMI and after adding app and updating everything using the clearos dashboard I can’t run Wordpress or Tiki.
It seems the default install installed a nearly outdated version of mariaDB - version: 5.5.64-MariaDB (https://en.wikipedia.org/wiki/MariaDB)

1/ Was something went wrong or Why ?
(what reason to not install an updated version)

2/ How to upgrade properly ?
(I upgraded a few month ago on a different server and the MariaDB Database Server app is now unusable - but mysql 10 work)

Thanks !
Friday, December 20 2019, 10:54 AM
Share this post:

Accepted Answer

Sunday, December 22 2019, 12:34 PM - #Permalink
Resolved
-1 votes
Try stopping mariadb. It is probably using the same socket.

Also do a "yum repolist". If mysql56-community is enabled, I suggest you disable it "yumconfigmanager --disable mysql56-community".
The reply is currently minimized Show
Responses (10)
  • Accepted Answer

    Friday, December 20 2019, 03:54 PM - #Permalink
    Resolved
    0 votes
    I believe wordpress will run on 5.4. Certainly the versions available from the ClearOS Wordpress app can. If you want to install a later version alongside the ClearOS/Centos version, check out the MariaDB Special Interest Group here. The apps should be available from our repos in the same way as PHP 7.x is.
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, December 21 2019, 08:41 AM - #Permalink
    Resolved
    0 votes
    Also, I don't know if it will fix your yum but have a read of this or this.

    I used to suffer from a slow yum database when doing commands line "rpm -qa | grep ....", so I also increased the size of my database by following this link. It worked wonders.
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, December 21 2019, 02:57 PM - #Permalink
    Resolved
    0 votes
    Thanks Nick and sorry for duplicate post.

    I followed the instructions to fix my yum, work fine now. ??

    I followed the instructions on the SCLO link and did a:
    yum install rh-mariadb103


    If I check from yum it seems that all should be good.
    Package rh-mariadb103-3.3-5.el7.x86_64 already installed and latest version
    Nothing to do


    However everywhere I check it show 5.5.64. :(
    # mysql -V
    mysql Ver 15.1 Distrib 5.5.64-MariaDB, for Linux (x86_64) using readline 5.1


    Server version: 5.5.64-MariaDB - MariaDB Server

    I restarted the server... same.

    Now when I do yum update I got errors (seems mysql is involved now...)

    --> Finished Dependency Resolution
    Error: Package: 1:app-mariadb-core-2.3.3-1.v7.noarch (@clearos-verified)
    Requires: mariadb-server >= 5.5.40
    Removing: 1:mariadb-server-5.5.64-1.el7.x86_64 (@clearos-centos-verified)
    mariadb-server = 1:5.5.64-1.el7
    Obsoleted By: mysql-community-server-5.6.46-2.el7.x86_64 (mysql56-community)
    Not found
    Available: 1:mariadb-server-5.5.60-1.el7_5.x86_64 (clearos-centos-verified)
    mariadb-server = 1:5.5.60-1.el7_5
    You could try using --skip-broken to work around the problem
    ** Found 1 pre-existing rpmdb problem(s), 'yum check' output follows:
    rh-mysql57-2.3-4.el7.x86_64 has missing requires of rh-mysql57-mysql-server


    ... ☠️
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, December 21 2019, 06:58 AM - #Permalink
    Resolved
    0 votes
    Thanks Nick for your help and sorry for the noob questions. ;-)

    I followed the link you posted to : Software Collections from RHSCL

    Plan A (red)
    It took me sometimes but finally found this : https://www.softwarecollections.org/en/scls/rhscl/rh-mariadb103/
    Is it what I should do to upgrade properly ?
    yum install rh-mariadb103

    I have the feeling that’s what I did on a different server were the MariaDB Database Server app is now unusable (from the dashboard).

    ---

    Plan B (blue)
    Following you second advise,
    The apps should be available from our repos in the same way as PHP 7.x is


    I tried to check packages from the default installed repo but:
    yum search mariadb
    error: rpmdb: BDB0113 Thread/process 3095/140224439965504 failed: BDB1507 Thread died in Berkeley DB library...
    (I tried other command like"list" got the same results)

    Googling, I landed at : https://pkgs.org/download/mariadb (what a jungle :-) ) and found (among many many packages) : rh-mariadb103-mariadb-10.3.13-4.el7.x86_64.rpm
    rpm -i rh-mariadb103-mariadb-10.3.13-4.el7.x86_64.rpm


    So... I cut the red wire or the blue wire ? ?????

    Thanks again for your time
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, December 21 2019, 08:25 AM - #Permalink
    Resolved
    0 votes
    Deleting your duplicate post.

    I don't know what is wrong with your yum. I've done it a lot recently without problems:
    [root@microserver ~]# yum list rh-mariadb*
    Loaded plugins: clearcenter-marketplace, fastestmirror
    ClearCenter Marketplace: fetching repositories...
    Loading mirror speeds from cached hostfile
    * clearos: mirror2-amsterdam.clearos.com
    * clearos-centos-sclo-rh: download3.clearsdn.com
    * clearos-centos-verified: mirror2-amsterdam.clearos.com
    * clearos-contribs: mirror2-amsterdam.clearos.com
    * clearos-contribs-paid: mirror2-amsterdam.clearos.com
    * clearos-epel-verified: mirror2-amsterdam.clearos.com
    * clearos-fast-updates: download3.clearsdn.com
    * clearos-infra: mirror2-amsterdam.clearos.com
    * clearos-paid: mirror2-amsterdam.clearos.com
    * clearos-verified: mirror2-amsterdam.clearos.com
    * private-clearcenter-ad: download3.clearsdn.com:80
    * private-clearcenter-business: download4.clearsdn.com:80
    * private-clearcenter-dnsthingy: download4.clearsdn.com:80
    * private-clearcenter-dyndns: download1.clearsdn.com:80
    * private-clearcenter-kaspersky-gateway: download4.clearsdn.com:80
    * private-clearcenter-kopano-basic: download1.clearsdn.com:80
    * private-clearcenter-master-slave: download3.clearsdn.com:80
    * private-clearcenter-nextcloud-business: download3.clearsdn.com:80
    * private-clearcenter-proxypass: download4.clearsdn.com:80
    * private-clearcenter-rbs: download1.clearsdn.com:80
    * private-clearcenter-static-vpn: download4.clearsdn.com:80
    * private-clearcenter-verified-updates: download3.clearsdn.com:80
    Available Packages
    rh-mariadb100.x86_64 2.0-13.el7 clearos-centos-sclo-rh
    rh-mariadb100-Judy.x86_64 1.0.5-12.el7 clearos-centos-sclo-rh
    rh-mariadb100-Judy-devel.x86_64 1.0.5-12.el7 clearos-centos-sclo-rh
    rh-mariadb100-build.x86_64 2.0-13.el7 clearos-centos-sclo-rh
    rh-mariadb100-mariadb.x86_64 1:10.0.33-3.el7 clearos-centos-sclo-rh
    rh-mariadb100-mariadb-bench.x86_64 1:10.0.33-3.el7 clearos-centos-sclo-rh
    rh-mariadb100-mariadb-common.x86_64 1:10.0.33-3.el7 clearos-centos-sclo-rh
    rh-mariadb100-mariadb-config.x86_64 1:10.0.33-3.el7 clearos-centos-sclo-rh
    rh-mariadb100-mariadb-devel.x86_64 1:10.0.33-3.el7 clearos-centos-sclo-rh
    rh-mariadb100-mariadb-errmsg.x86_64 1:10.0.33-3.el7 clearos-centos-sclo-rh
    rh-mariadb100-mariadb-oqgraph-engine.x86_64
    1:10.0.33-3.el7 clearos-centos-sclo-rh
    rh-mariadb100-mariadb-server.x86_64 1:10.0.33-3.el7 clearos-centos-sclo-rh
    rh-mariadb100-mariadb-test.x86_64 1:10.0.33-3.el7 clearos-centos-sclo-rh
    rh-mariadb100-runtime.x86_64 2.0-13.el7 clearos-centos-sclo-rh
    rh-mariadb100-scldevel.x86_64 2.0-13.el7 clearos-centos-sclo-rh
    rh-mariadb101.x86_64 2.2-3.el7 clearos-centos-sclo-rh
    rh-mariadb101-Judy.x86_64 1.0.5-12.el7 clearos-centos-sclo-rh
    rh-mariadb101-Judy-devel.x86_64 1.0.5-12.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-atomic.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-build.noarch 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-chrono.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-container.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-context.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-coroutine.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-date-time.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-devel.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-doc.noarch 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-doctools.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-examples.noarch 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-filesystem.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-graph.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-iostreams.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-jam.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-locale.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-log.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-math.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-program-options.x86_64
    1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-python.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-random.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-regex.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-serialization.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-signals.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-static.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-system.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-test.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-thread.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-timer.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-boost-wave.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb101-build.x86_64 2.2-3.el7 clearos-centos-sclo-rh
    rh-mariadb101-galera.x86_64 25.3.12-12.el7 clearos-centos-sclo-rh
    rh-mariadb101-mariadb.x86_64 1:10.1.29-3.el7 clearos-centos-sclo-rh
    rh-mariadb101-mariadb-bench.x86_64 1:10.1.29-3.el7 clearos-centos-sclo-rh
    rh-mariadb101-mariadb-common.x86_64 1:10.1.29-3.el7 clearos-centos-sclo-rh
    rh-mariadb101-mariadb-config.x86_64 1:10.1.29-3.el7 clearos-centos-sclo-rh
    rh-mariadb101-mariadb-devel.x86_64 1:10.1.29-3.el7 clearos-centos-sclo-rh
    rh-mariadb101-mariadb-errmsg.x86_64 1:10.1.29-3.el7 clearos-centos-sclo-rh
    rh-mariadb101-mariadb-oqgraph-engine.x86_64
    1:10.1.29-3.el7 clearos-centos-sclo-rh
    rh-mariadb101-mariadb-server.x86_64 1:10.1.29-3.el7 clearos-centos-sclo-rh
    rh-mariadb101-mariadb-server-galera.x86_64
    1:10.1.29-3.el7 clearos-centos-sclo-rh
    rh-mariadb101-mariadb-test.x86_64 1:10.1.29-3.el7 clearos-centos-sclo-rh
    rh-mariadb101-runtime.x86_64 2.2-3.el7 clearos-centos-sclo-rh
    rh-mariadb101-scldevel.x86_64 2.2-3.el7 clearos-centos-sclo-rh
    rh-mariadb101-scons.noarch 2.3.4-3.el7 clearos-centos-sclo-rh
    rh-mariadb102.x86_64 3.0-5.el7 clearos-centos-sclo-rh
    rh-mariadb102-Judy.x86_64 1.0.5-13.el7 clearos-centos-sclo-rh
    rh-mariadb102-Judy-devel.x86_64 1.0.5-13.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-atomic.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-build.noarch 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-chrono.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-container.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-context.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-coroutine.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-date-time.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-devel.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-doc.noarch 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-doctools.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-examples.noarch 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-filesystem.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-graph.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-iostreams.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-jam.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-locale.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-log.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-math.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-program-options.x86_64
    1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-python.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-random.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-regex.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-serialization.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-signals.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-static.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-system.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-test.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-thread.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-timer.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-boost-wave.x86_64 1.58.0-16.el7 clearos-centos-sclo-rh
    rh-mariadb102-build.x86_64 3.0-5.el7 clearos-centos-sclo-rh
    rh-mariadb102-galera.x86_64 25.3.25-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb.x86_64 1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-backup.x86_64 1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-backup-syspaths.x86_64
    1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-bench.x86_64 1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-common.x86_64 1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-config.x86_64 1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-config-syspaths.x86_64
    1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-devel.x86_64 1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-errmsg.x86_64 1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-gssapi-client.x86_64
    1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-gssapi-server.x86_64
    1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-oqgraph-engine.x86_64
    1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-server.x86_64 1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-server-galera.x86_64
    1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-server-galera-syspaths.x86_64
    1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-server-syspaths.x86_64
    1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-server-utils.x86_64 1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-server-utils-syspaths.x86_64
    1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-syspaths.x86_64 1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-mariadb-test.x86_64 1:10.2.22-1.el7 clearos-centos-sclo-rh
    rh-mariadb102-runtime.x86_64 3.0-5.el7 clearos-centos-sclo-rh
    rh-mariadb102-scldevel.x86_64 3.0-5.el7 clearos-centos-sclo-rh
    rh-mariadb102-scons.noarch 2.3.4-3.el7 clearos-centos-sclo-rh
    rh-mariadb102-syspaths.x86_64 3.0-5.el7 clearos-centos-sclo-rh
    rh-mariadb103.x86_64 3.3-5.el7 clearos-centos-sclo-rh
    rh-mariadb103-Judy.x86_64 1.0.5-14.el7 clearos-centos-sclo-rh
    rh-mariadb103-Judy-devel.x86_64 1.0.5-14.el7 clearos-centos-sclo-rh
    rh-mariadb103-build.x86_64 3.3-5.el7 clearos-centos-sclo-rh
    rh-mariadb103-galera.x86_64 25.3.25-1.el7 clearos-centos-sclo-rh
    rh-mariadb103-jna.x86_64 4.5.1-4.4.el7 clearos-centos-sclo-rh
    rh-mariadb103-jna-contrib.noarch 4.5.1-4.4.el7 clearos-centos-sclo-rh
    rh-mariadb103-jna-javadoc.noarch 4.5.1-4.4.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb.x86_64 3:10.3.13-4.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-backup.x86_64 3:10.3.13-4.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-backup-syspaths.x86_64
    3:10.3.13-4.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-common.x86_64 3:10.3.13-4.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-config.x86_64 3:10.3.13-4.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-config-syspaths.x86_64
    3:10.3.13-4.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-devel.x86_64 3:10.3.13-4.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-errmsg.x86_64 3:10.3.13-4.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-gssapi-server.x86_64
    3:10.3.13-4.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-java-client.noarch 2.4.1-2.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-java-client-javadoc.noarch
    2.4.1-2.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-oqgraph-engine.x86_64
    3:10.3.13-4.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-server.x86_64 3:10.3.13-4.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-server-galera.x86_64
    3:10.3.13-4.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-server-galera-syspaths.x86_64
    3:10.3.13-4.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-server-syspaths.x86_64
    3:10.3.13-4.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-server-utils.x86_64 3:10.3.13-4.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-server-utils-syspaths.x86_64
    3:10.3.13-4.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-syspaths.x86_64 3:10.3.13-4.el7 clearos-centos-sclo-rh
    rh-mariadb103-mariadb-test.x86_64 3:10.3.13-4.el7 clearos-centos-sclo-rh
    rh-mariadb103-runtime.x86_64 3.3-5.el7 clearos-centos-sclo-rh
    rh-mariadb103-scldevel.x86_64 3.3-5.el7 clearos-centos-sclo-rh
    rh-mariadb103-syspaths.x86_64 3.3-5.el7 clearos-centos-sclo-rh
    So a straight:
    yum install rh-mariadb103
    Should work. Installing it should not interfere with the ClearOS version but note the instructions on your SCLO link. Also note that I have never used this so I can't offer much guidance. I just knew of its existence.
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, December 21 2019, 09:57 PM - #Permalink
    Resolved
    0 votes
    Did you do step 3 of the install instructions? Also you've got a funny repo enabled (mysql56-community).
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, December 22 2019, 12:04 PM - #Permalink
    Resolved
    0 votes
    Nick Howitt wrote:

    Did you do step 3 of the install instructions? Also you've got a funny repo enabled (mysql56-community).


    Yes Nick,
    I re-follow each step and this is the output:

    # scl enable rh-mariadb103 bash


    # service rh-mariadb103-mariadb start
    Redirecting to /bin/systemctl start rh-mariadb103-mariadb.service
    Job for rh-mariadb103-mariadb.service failed because the control process exited with error code. See "systemctl status rh-mariadb103-mariadb.service" and "journalctl -xe" for details.


    # systemctl status rh-mariadb103-mariadb.service
    ● rh-mariadb103-mariadb.service - MariaDB 10.3 database server
    Loaded: loaded (/usr/lib/systemd/system/rh-mariadb103-mariadb.service; disabled; vendor preset: disabled)
    Active: failed (Result: exit-code) since Sun 2019-12-22 07:39:21 CET; 14s ago
    Docs: man:mysqld(8)
    https://mariadb.com/kb/en/library/systemd/
    Process: 395 ExecStartPre=/usr/bin/scl enable $RH_MARIADB103_SCLS_ENABLED -- /opt/rh/rh-mariadb103/root/usr/libexec/mysql-check-socket (code=exited, status=1/FAILURE)
    Process: 389 ExecStartPre=/usr/bin/scl enable $RH_MARIADB103_SCLS_ENABLED -- /usr/bin/scl_enabled rh-mariadb103 (code=exited, status=0/SUCCESS)
    ...
    Dec 22 07:39:21 ip-172..... scl[395]: Socket file /var/lib/mysql/mysql.sock exists.
    Dec 22 07:39:21 ip-172..... scl[395]: Is another MySQL daemon already running with the same unix socket?
    Dec 22 07:39:21 ip-172..... scl[395]: Please, stop the process using the socket /var/lib/mysql/mysql.sock or remove the file manually to start the service.
    Dec 22 07:39:21 ip-172..... systemd[1]: rh-mariadb103-mariadb.service: control process exited, code=exited status=1
    Dec 22 07:39:21 ip-172..... systemd[1]: Failed to start MariaDB 10.3 database server.
    Dec 22 07:39:21 ip-172.....systemd[1]: Unit rh-mariadb103-mariadb.service entered failed state.
    Dec 22 07:39:21 ip-172..... systemd[1]: rh-mariadb103-mariadb.service failed.


    I attached a screenshot of the services running (deamons ?)

    Something to do with this "funny repo enabled (mysql56-community)" ?

    Bernard
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, December 22 2019, 07:43 PM - #Permalink
    Resolved
    0 votes
    Try stopping mariadb. It is probably using the same socket.


    Thanks, this worked !
    However it leaves me confused... (but that’s a bit normal, I’m not a real server admin ?)

    I understand I had (have) more than one version of mariadb and the older one was running.
    Now I started 10.3 and it’s good.

    However how can I be sure it stays that way (if server reboot or...) ?

    My services page show (see attachement) 2 mariadb.
    I guess I still have to clean a bit. :)

    Bernard

    PS: To clean my repo I did (thanks for showing the way):
    yum-config-manager --disable mysql56-community
    The reply is currently minimized Show
  • Accepted Answer

    Monday, December 23 2019, 08:52 AM - #Permalink
    Resolved
    0 votes
    If you started and stopped the services through the webconfig service manager, then you should be ok. You can check with:
    systemctl is-enabled mariadb rh-mariadb103
    To enable autostart:
    systemctl enable rh-mariadb103
    And to disable it:
    systemctl disabled mariadb
    The reply is currently minimized Show
  • Accepted Answer

    Monday, December 23 2019, 08:53 AM - #Permalink
    Resolved
    0 votes
    (crossposting...) ;-)

    Many thanks Nick.


    # systemctl is-enabled mariadb rh-mariadb103-mariadb
    disabled
    disabled

    # systemctl enable rh-mariadb103-mariadb
    Created symlink from /etc/systemd/system/mysql.service to /usr/lib/systemd/system/rh-mariadb103-mariadb.service.
    Created symlink from /etc/systemd/system/mysqld.service to /usr/lib/systemd/system/rh-mariadb103-mariadb.service.
    Created symlink from /etc/systemd/system/multi-user.target.wants/rh-mariadb103-mariadb.service to /usr/lib/systemd/system/rh-mariadb103-mariadb.service.

    # systemctl disabled mariadb
    Unknown operation 'disabled'.


    Hope this is good now.
    (I understand I can also enable/disable from the Services app)

    Have a great day, Merry Christmas, Happy Hanukah and happy underdog day ! ;-)
    The reply is currently minimized Show
Your Reply