Learn about Centmin Mod LEMP Stack today
Become a Member

Wordpress Wordpress install centmin.sh menu option 22 - MariaDB MySQL server not running message

Discussion in 'Blogs & CMS usage' started by Oleg, Nov 12, 2019.

  1. Oleg

    Oleg New Member

    3
    0
    1
    Nov 12, 2019
    Ratings:
    +0
    Local Time:
    12:19 PM
    Today I installed centmin several times. There was the same problem!

     
  2. eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    7:19 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    might be best to start a new thread of your own in bug reports forum with the initial install log asked at Possible Bugs
     
  3. Oleg

    Oleg New Member

    3
    0
    1
    Nov 12, 2019
    Ratings:
    +0
    Local Time:
    12:19 PM
    1. Install centminmod_123.09beta
    2. Reboot
    3. Centmin - enter option 22 - Error: MariaDB MySQL Server is not running
    --snipped--
    Code:
     
    --------------------------------------------------------
    Enter option [ 1 - 24 ] 22
    --------------------------------------------------------
    ------------------------------------------------------------
    Installing wpcli.sh
    ------------------------------------------------------------
    installing...
     
    Error: /usr/bin/wp not found !!! Downloading now......
    2019-11-12 07:03:58 URL:https://raw.githubusercontent.com/wp-cli/builds/gh-pages                                                                                                                                   /phar/wp-cli.phar [5542314/5542314] -> "/usr/bin/wp" [1]
    Download done.
     
    Error: /root/wpcli/wp-completion.bash not found !!! Downloading now......
    2019-11-12 07:03:59 URL:https://raw.githubusercontent.com/wp-cli/wp-cli/master/u                                                                                                                                   tils/wp-completion.bash [495/495] -> "/root/wpcli/wp-completion.bash" [1]
    Download done.
     
     
    -------------------------------------------------------------
    install wp-cli https://github.com/eriktorsner/wp-checksum
    Installing package eriktorsner/wp-checksum (dev-master)
    Updating /root/.wp-cli/packages/composer.json to require the package...
    Using Composer to install the package...
    ---
    Loading composer repositories with package information
    Updating dependencies
    Resolving dependencies through SAT
    Looking at all rules.
    Something's changed, looking at all rules again (pass #1)
     
    Dependency resolution completed in 0.022 seconds
    Analyzed 1527 packages to resolve dependencies
    Analyzed 41066 rules to resolve dependencies
    Package operations: 3 installs, 0 updates, 0 removals
    Installs: psr/container:1.0.0, pimple/pimple:v3.2.3, eriktorsner/wp-checksum:dev                                                                                                                                   -master b33125e
     - Installing psr/container (1.0.0)
     - Warning: pimple/pimple v3.2.3 requires psr/container ^1.0 -> satisfiable by p                                                                                                                                   sr/container[1.0.0, 1.0.x-dev].
     - Installing pimple/pimple (v3.2.3)
     - Warning: eriktorsner/wp-checksum dev-master requires pimple/pimple ~3.0 -> sa                                                                                                                                   tisfiable by pimple/pimple[3.2.x-dev, v3.0.0, v3.0.1, v3.0.2, v3.1.0, v3.2.0, v3                                                                                                                                   .2.1, v3.2.2, v3.2.3].
     - Installing eriktorsner/wp-checksum (dev-master b33125e)
    Writing lock file
    Generating autoload files
    ---
    Success: Package installed.
    -------------------------------------------------------------
    install wp-cli https://github.com/markri/wp-sec
    Installing package markri/wp-sec (dev-master)
    Updating /root/.wp-cli/packages/composer.json to require the package...
    Using Composer to install the package...
    ---
    Loading composer repositories with package information
    Updating dependencies
    Resolving dependencies through SAT
    Looking at all rules.
    Something's changed, looking at all rules again (pass #1)
     
    Dependency resolution completed in 0.008 seconds
    Analyzed 1536 packages to resolve dependencies
    Analyzed 41088 rules to resolve dependencies
    Package operations: 1 install, 0 updates, 0 removals
    Installs: markri/wp-sec:dev-master 2294d0a
     - Installing markri/wp-sec (dev-master 2294d0a)
    Writing lock file
    Generating autoload files
    ---
    Success: Package installed.
    -------------------------------------------------------------
    update wp-cli packages
    Using Composer to update packages...
    ---
    Loading composer repositories with package information
    Updating dependencies
    Resolving dependencies through SAT
    Looking at all rules.
    Something's changed, looking at all rules again (pass #1)
     
    Dependency resolution completed in 0.007 seconds
    Analyzed 1537 packages to resolve dependencies
    Analyzed 41090 rules to resolve dependencies
    Nothing to install or update
    Generating autoload files
    ---
    Success: Packages updated.
    -------------------------------------------------------------
    wp-cli info
    OS:     Linux 3.10.0-1062.4.1.el7.x86_64 #1 SMP Fri Oct 18 17:15:30 UTC 2019 x86                                                                                                                                   _64
    Shell:  /bin/bash
    PHP binary:     /usr/local/bin/php
    PHP version:    7.3.11
    php.ini used:   /usr/local/lib/php.ini
    WP-CLI root dir:        phar://wp-cli.phar/vendor/wp-cli/wp-cli
    WP-CLI vendor dir:      phar://wp-cli.phar/vendor
    WP_CLI phar path:       /usr/local/src/centminmod/addons
    WP-CLI packages dir:    /root/.wp-cli/packages/
    WP-CLI global config:
    WP-CLI project config:
    WP-CLI version: 2.3.0
    -------------------------------------------------------------
     
    -------------------------------------------------------------
    wp-cli install completed
    Read http://wp-cli.org/ for full usage info
     
    -------------------------------------------------------------
    Please log out of SSH session and log back in
    You can then call wp-cli via command: wp
    i.e. wp --info --allow-root
    -------------------------------------------------------------
     
    -------------------------------------------------------------
    Setup full Nginx vhost + Wordpress + WP Plugins
    -------------------------------------------------------------
     
    ---------------------------------------------------------------
    Important Information
    ---------------------------------------------------------------
     
    You are about to create an Wordpress based Nginx vhost site with
    or without HTTPS/SSL support.
    Also read the continually updated Getting Started Guide
    at centminmod.com/getstarted.html if you haven't already
    ---------------------------------------------------------------
    403 Permission denied message handling
    if after vhost site setup you encounter 403 permission denied errors,
    check https://community.centminmod.com/threads/11215/ to see if your
    site needs tools/autoprotect.sh tweaking & whitelisting
    ---------------------------------------------------------------
    [ LETSENCRYPT_DETECT is not enabled ]
    Ignore this message if you do not want HTTPS based web site otherwise
    read below carefully.
     
    Free letsencrypt SSL certificates integration is in beta testing if
    you want to obtain free letsencrypt SSL certificate for HTTPS site,
    you will need to manually enable LETSENCRYPT_DETECT='y' outlined
    at https://centminmod.com/acmetool so exit this vhost routine first
    set LETSENCRYPT_DETECT='y' and update domain DNS A record first
    then re-run vhost site creation menu option
    ---------------------------------------------------------------
     
    !!  Error: MariaDB MySQL Server is not running  !!
    Please make sure MariaDB MySQL Server is running first
    aborting centmin.sh menu option 22 run...
    --------------------------------------------------------
     
  4. eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    7:19 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Removed your install log as you didn't remove sensitive login credentials - i'd do a fresh centos 7.7 install and fresh Centmin Mod 123.09beta01 install so the login info is regenerated

    I see in initial install log that MariaDB server is started up at end of Centmin Mod initial install
    Code (Text):
    [1;32;40m**********************************************************************
    (B[m[1;32;40m* Starting Services...
    (B[m[1;32;40m**********************************************************************
    (B[mStarting nginx (via systemctl):  [  OK  ]
    Starting mysql (via systemctl):  [  OK  ]
    


    But do you mean on reboot of server, MariaDB server isn't started up ?

    ah so it's a message that MariaDB MySQL server is not running and not actual confirmation if MySQL server is running ?

    lets check first to see if MariaDB MySQL server is running or not

    can you post output for these commands below before and after a server reboot

    alias to mariadb service
    Code (Text):
    service mysql status
    

    actual mariadb server
    Code (Text):
    service mariadb status
    

    mysqladmin client check version
    Code (Text):
    mysqladmin ver
    

    and the actual command used by centmin.sh menu option 22 to check if MariaDB MySQL server is running - if running would return = 0 if not running would return value not equal to 0
    Code (Text):
    mysqladmin -s ping >/dev/null 2>&1; CHECKMYSQL_PING=$?; echo $CHECKMYSQL_PING
    
     
  5. AHTOLLlKA

    AHTOLLlKA Member

    32
    4
    8
    Dec 1, 2017
    Ratings:
    +9
    Local Time:
    12:19 PM
    many times i have same error on fresh systems
    fix: rm -rf /var/lib/mysql/ib_logfile*
    then start service mysql start
     
  6. eva2000

    eva2000 Administrator Staff Member

    53,142
    12,110
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,645
    Local Time:
    7:19 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    This thread is 2yrs old, your shouldn't be still having the issues now. If you are then start a new thread in forum at https://community.centminmod.com/forums/install-upgrades-or-pre-install-questions.8/ with your initial Centmin Mod install log for debug/troubleshooting as per sticky thread at https://community.centminmod.com/threads/how-to-troubleshoot-centmin-mod-initial-install-issues.102/