Welcome to Centmin Mod Community
Become a Member

Error: MariaDB MySQL Server is not running

Discussion in 'System Administration' started by adamus007p, Feb 5, 2022.

  1. adamus007p

    adamus007p Member

    283
    17
    18
    Feb 8, 2019
    Ratings:
    +29
    Local Time:
    12:37 PM
    Hello, I have new fresh installation. I wanted to install Wordpress- option 22

    Reboot after the install

    Code (Text):
    Installing wpcli.sh
    ------------------------------------------------------------
    installing...
    
    Error: /usr/bin/wp not found !!! Downloading now......
    2022-02-04 20:05:18 URL:https://raw.githubusercontent.com/wp-cli/builds/gh-pages/phar/wp-cli.phar [6494444/6494444] -> "/usr/bin/wp" [1]
    Download done.
    
    Error: /root/wpcli/wp-completion.bash not found !!! Downloading now......
    2022-02-04 20:05:18 URL:https://raw.githubusercontent.com/wp-cli/wp-cli/master/utils/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-main || dev-master || dev-trunk)
    Updating /root/.wp-cli/packages/composer.json to require the package...
    Using Composer to install the package...
    ---
    Loading composer repositories with package information
    Found 139 package versions referenced in your dependency graph. 12 (9%) were optimized away.
    Updating dependencies
    Generating rules
    Resolving dependencies through SAT
    Looking at all rules.
    Something's changed, looking at all rules again (pass #1)
    
    Dependency resolution completed in 0.000 seconds
    Analyzed 127 packages to resolve dependencies
    Analyzed 137 rules to resolve dependencies
    Lock file operations: 3 installs, 0 updates, 0 removals
    Installs: psr/container:2.0.2, pimple/pimple:v3.5.0, eriktorsner/wp-checksum:dev-master b33125e
    - Locking eriktorsner/wp-checksum (dev-master b33125e)
    - Locking pimple/pimple (v3.5.0)
    - Locking psr/container (2.0.2)
    Writing lock file
    Installing dependencies from lock file
    Package operations: 3 installs, 0 updates, 0 removals
    Installs: psr/container:2.0.2, pimple/pimple:v3.5.0, eriktorsner/wp-checksum:dev-master b33125e
     - Installing <info>psr/container</info> (<comment>2.0.2</comment>)
     - Installing <info>pimple/pimple</info> (<comment>v3.5.0</comment>)
     - Installing <info>eriktorsner/wp-checksum</info> (<comment>dev-master b33125e</comment>)
    Generating autoload files
    ---
    Success: Package installed.
    -------------------------------------------------------------
    install wp-cli https://github.com/markri/wp-sec
    Installing package markri/wp-sec (dev-main || dev-master || dev-trunk)
    Updating /root/.wp-cli/packages/composer.json to require the package...
    Using Composer to install the package...
    ---
    Loading composer repositories with package information
    Found 141 package versions referenced in your dependency graph. 12 (9%) were optimized away.
    Updating dependencies
    Generating rules
    Resolving dependencies through SAT
    Looking at all rules.
    Something's changed, looking at all rules again (pass #1)
    
    Dependency resolution completed in 0.000 seconds
    Analyzed 129 packages to resolve dependencies
    Analyzed 140 rules to resolve dependencies
    Lock file operations: 1 install, 0 updates, 0 removals
    Installs: markri/wp-sec:dev-master 31c0c39
    - Locking markri/wp-sec (dev-master 31c0c39)
    Writing lock file
    Installing dependencies from lock file
    Package operations: 1 install, 0 updates, 0 removals
    Installs: markri/wp-sec:dev-master 31c0c39
     - Installing <info>markri/wp-sec</info> (<comment>dev-master 31c0c39</comment>)
    Generating autoload files
    ---
    Success: Package installed.
    -------------------------------------------------------------
    update wp-cli packages
    Using Composer to update packages...
    ---
    Loading composer repositories with package information
    Found 141 package versions referenced in your dependency graph. 12 (9%) were optimized away.
    Updating dependencies
    Generating rules
    Resolving dependencies through SAT
    Looking at all rules.
    Something's changed, looking at all rules again (pass #1)
    
    Dependency resolution completed in 0.000 seconds
    Analyzed 129 packages to resolve dependencies
    Analyzed 140 rules to resolve dependencies
    Nothing to modify in lock file
    Installing dependencies from lock file
    Nothing to install, update or remove
    Generating autoload files
    ---
    Success: Packages updated.
    -------------------------------------------------------------
    wp-cli info
    OS:     Linux 3.10.0-1160.53.1.el7.x86_64 #1 SMP Fri Jan 14 13:59:45 UTC 2022 x86_64
    Shell:  /bin/bash
    PHP binary:     /usr/local/bin/php
    PHP version:    7.4.27
    php.ini used:   /usr/local/lib/php.ini
    MySQL binary:   /bin/mysql
    MySQL version:  mysql  Ver 15.1 Distrib 10.3.32-MariaDB, for Linux (x86_64) using readline 5.1
    SQL modes:
    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.6.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
    ---------------------------------------------------------------
    
    !!  Error: MariaDB MySQL Server is not running  !!
    Please make sure MariaDB MySQL Server is running first
    aborting centmin.sh menu option 22 run...
    


    then I run


    Code (Text):
    service mysql status
     ERROR! MariaDB is not running
    [20:07][root@hosttest.domain.com ~]# service mariadb status
    Redirecting to /bin/systemctl status mariadb.service
    ● mariadb.service - MariaDB 10.3.32 database server
       Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
      Drop-In: /etc/systemd/system/mariadb.service.d
               └─migrated-from-my.cnf-settings.conf, openfileslimit.conf, protecthome.conf
       Active: failed (Result: exit-code) since Fri 2022-02-04 20:03:05 UTC; 4min 33s ago
         Docs: man:mysqld(8)
               https://mariadb.com/kb/en/library/systemd/
     Main PID: 1574 (code=exited, status=1/FAILURE)
       Status: "MariaDB server is down"
    
    Feb 04 20:03:05 hosttest.domain.com mysqld[1574]: 2022-02-04 20:03:05 0 [Note] InnoDB: Starting shutdown...
    Feb 04 20:03:05 hosttest.domain.com mysqld[1574]: 2022-02-04 20:03:05 0 [ERROR] Plugin 'InnoDB' init function returned error.
    Feb 04 20:03:05 hosttest.domain.com mysqld[1574]: 2022-02-04 20:03:05 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    Feb 04 20:03:05 hosttest.domain.com mysqld[1574]: 2022-02-04 20:03:05 0 [Note] Plugin 'FEEDBACK' is disabled.
    Feb 04 20:03:05 hosttest.domain.com mysqld[1574]: 2022-02-04 20:03:05 0 [ERROR] Unknown/unsupported storage engine: InnoDB
    Feb 04 20:03:05 hosttest.domain.com mysqld[1574]: 2022-02-04 20:03:05 0 [ERROR] Aborting
    Feb 04 20:03:05 hosttest.domain.com systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
    Feb 04 20:03:05 hosttest.domain.com systemd[1]: Failed to start MariaDB 10.3.32 database server.
    Feb 04 20:03:05 hosttest.domain.com systemd[1]: Unit mariadb.service entered failed state.
    Feb 04 20:03:05 hosttest.domain.com systemd[1]: mariadb.service failed.
    [20:07][root@hosttest.domain.com ~]# mysqladmin ver
    mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
    Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
    [20:07][root@hosttest.domain.com ~]# mysqladmin -s ping >/dev/null 2>&1; CHECKMYSQL_PING=$?; echo $CHECKMYSQL_PING
    1
    [20:08][root@hosttest.domain.com ~]#



    Code (Text):
    CF_DNSAPI_GLOBAL='y'
    CF_Token="aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"
    CF_Account_ID="aaaaaaaaaaaaaaaaaaaaaa"
    NGINX_SSLCACHE_ALLOWOVERRIDE='y'
    NGINX_STAPLE_CACHE_OVERRIDE='y'
    NGINX_STAPLE_CACHE_TTL='86400'
    SET_DEFAULT_MYSQLCHARSET='utf8mb4'
    AUTOHARDTUNE_NGINXBACKLOG='y'
    ZSTD_LOGROTATE_NGINX='y'
    ZSTD_LOGROTATE_PHPFPM='y'
    NGINX_LIBBROTLI='y'
    NGXDYNAMIC_BROTLI='y'
    PHP_PGO='y'
    PHP_BROTLI='y'
    PHP_LZFOUR='y'
    PHP_LZF='y'
    PHP_ZSTD='y'
    MARCH_TARGETNATIVE='n'
    LETSENCRYPT_DETECT='y'
    DUALCERTS='y'
    AUDITD_ENABLE='y'
    PHPINTL='y'
    PHPFINFO='y'
    LIBRESSL_SWITCH='n'
    DMOTD_PHPCHECK='y'
    WPCLI_CE_QUERYSTRING_INCLUDED='y'
    NGINX_ZERODT='y'



    Code (Text):
    cat /etc/centos-release
    CentOS Linux release 7.9.2009 (Core)
    
    php 7.4
    
    
    yum -y update; curl -O https://centminmod.com/betainstaller74.sh && chmod 0700 betainstaller74.sh && bash betainstaller74.sh



    How to fix it?
     
  2. eva2000

    eva2000 Administrator Staff Member

    48,986
    11,227
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,477
    Local Time:
    8:37 PM
    Nginx 1.21.x
    MariaDB 10.x
  3. adamus007p

    adamus007p Member

    283
    17
    18
    Feb 8, 2019
    Ratings:
    +29
    Local Time:
    12:37 PM
    Hello @eva2000 I am sending all logs:

    I have upload it via zip to dropbox.
     
    Last edited by a moderator: Feb 5, 2022
  4. eva2000

    eva2000 Administrator Staff Member

    48,986
    11,227
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,477
    Local Time:
    8:37 PM
    Nginx 1.21.x
    MariaDB 10.x
    I removed the link as you uploaded all centmin mod logs and not just initial install log which isn't recommended as some of the logs have sensitive info i.e. log copy of your /etc/centminmod/custom_config.inc persistent config file contains your Cloudflare DNS API Token and Account ID. I would regenerate that API Tokens key so it revokes the old one.

    The initial install log shows MariaDB failed to start after initial install stage
    Code (Text):
    Starting mariadb (via systemctl): [ Failed ]

    So I'd try reloading/fresh CentOS 7 install and try a new Centmin Mod 123.09beta01 install
     
  5. adamus007p

    adamus007p Member

    283
    17
    18
    Feb 8, 2019
    Ratings:
    +29
    Local Time:
    12:37 PM
    OMG I did not noticet that. I have changed API Tokens. Thank you @eva2000


    OK I can use snapshot and install centmin mode again.
     
    Last edited: Feb 5, 2022
  6. adamus007p

    adamus007p Member

    283
    17
    18
    Feb 8, 2019
    Ratings:
    +29
    Local Time:
    12:37 PM
    One thing what I have noticed that there was no info about time of insallation, while usual is.
     
  7. adamus007p

    adamus007p Member

    283
    17
    18
    Feb 8, 2019
    Ratings:
    +29
    Local Time:
    12:37 PM
    @eva2000 reinstall of the centminmod and the same error

    Code (Text):
    service mysql status
     ERROR! MariaDB is not running


    Code (Text):
    Starting mariadb (via systemctl): [ Failed ]


    what to do?
     
  8. adamus007p

    adamus007p Member

    283
    17
    18
    Feb 8, 2019
    Ratings:
    +29
    Local Time:
    12:37 PM
    now I follow only with

    this

    Code (Text):
    # create initial persistent config file to override centmin.sh defaults
    # https://centminmod.com/upgrade.html#persistent
    mkdir -p /etc/centminmod
    touch /etc/centminmod/custom_config.inc
    
    # dynamically tune nginx ssl_session_cache in /usr/local/nginx/conf/ssl_include.conf based on system detected memory
    # https://community.centminmod.com/posts/76615/
    echo "NGINX_SSLCACHE_ALLOWOVERRIDE='y'" >> /etc/centminmod/custom_config.inc
    
    # SET_DEFAULT_MYSQLCHARSET='utf8mb4' to override MariaDB MySQL
    # default characterset and collation from default utf8 to utf8mb4
    # https://community.centminmod.com/threads/17949/
    echo "SET_DEFAULT_MYSQLCHARSET='utf8mb4'" >> /etc/centminmod/custom_config.inc
    
    # enable nginx backlog override https://community.centminmod.com/threads/17620/
    echo "AUTOHARDTUNE_NGINXBACKLOG='y'" >> /etc/centminmod/custom_config.inc
    
    # enable zstd compressed logrotation for nginx & php-fpm https://community.centminmod.com/threads/16374/
    echo "ZSTD_LOGROTATE_NGINX='y'" >> /etc/centminmod/custom_config.inc
    echo "ZSTD_LOGROTATE_PHPFPM='y'" >> /etc/centminmod/custom_config.inc
    
    # enable nginx zero downtime on the fly nginx binary upgrades https://community.centminmod.com/threads/8000/
    #echo "NGINX_ZERODT='y'" >> /etc/centminmod/custom_config.inc
    
    # enable brotli compression https://community.centminmod.com/threads/10688/
    echo "NGINX_LIBBROTLI='y'" >> /etc/centminmod/custom_config.inc
    echo "NGXDYNAMIC_BROTLI='y'" >> /etc/centminmod/custom_config.inc
    
    # boost PHP 7 performance by enabling Profile Guided Optimisation flag
    # https://centminmod.com/perf/
    echo "PHP_PGO='y'" >> /etc/centminmod/custom_config.inc
    
    # php compression extensions https://community.centminmod.com/posts/70777/
    echo "PHP_BROTLI='y'" >> /etc/centminmod/custom_config.inc
    echo "PHP_LZFOUR='y'" >> /etc/centminmod/custom_config.inc
    echo "PHP_LZF='y'" >> /etc/centminmod/custom_config.inc
    echo "PHP_ZSTD='y'" >> /etc/centminmod/custom_config.inc
    
    # install centmin mod latest beta with php-fpm 7.3 default
    # https://community.centminmod.com/threads/centmin-mod-09-beta-branch-testing.4128/
    yum -y update; curl -O https://centminmod.com/betainstaller74.sh && chmod 0700 betainstaller74.sh && bash betainstaller74.sh
    



    and the error is

    Code (Text):
    service mysql status
     ERROR! MariaDB is running but PID file could not be found
    [root@host222 ~]# service mariadb status
    Redirecting to /bin/systemctl status mariadb.service
    ● mariadb.service - MariaDB 10.3.32 database server
       Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
      Drop-In: /etc/systemd/system/mariadb.service.d
               └─migrated-from-my.cnf-settings.conf, openfileslimit.conf, protecthome.conf
       Active: active (running) since Fri 2022-02-04 23:54:31 UTC; 9min ago
         Docs: man:mysqld(8)
               https://mariadb.com/kb/en/library/systemd/
     Main PID: 41311 (mysqld)
       Status: "Taking your SQL requests now..."
       CGroup: /system.slice/mariadb.service
               └─41311 /usr/sbin/mysqld
    
    Feb 04 23:54:31 hos1.domain.com systemd[1]: Starting MariaDB 10.3.32 database server...
    Feb 04 23:54:31 hos1.domain.com mysqld[41311]: 2022-02-04 23:54:31 0 [Note] /usr/sbin/mysqld (mysqld 10.3.32-MariaDB) starting as process 41311 ...
    Feb 04 23:54:31 hos1.domain.com systemd[1]: Started MariaDB 10.3.32 database server.
    [root@host222 ~]# mysqladmin ver
    mysqladmin  Ver 9.1 Distrib 10.3.32-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.3.32-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 9 min 56 sec
    
    Threads: 4  Questions: 1  Slow queries: 0  Opens: 18  Flush tables: 1  Open tables: 11  Queries per second avg: 0.001
    [root@host222 ~]# mysqladmin -s ping >/dev/null 2>&1; CHECKMYSQL_PING=$?; echo $CHECKMYSQL_PING
    0
    [root@host222 ~]#
    
    




    Code (Text):
    service mysql status
     ERROR! MariaDB is running but PID file could not be found

    is it an error?


    my current config is

    Code (Text):
    NGINX_SSLCACHE_ALLOWOVERRIDE='y'
    SET_DEFAULT_MYSQLCHARSET='utf8mb4'
    AUTOHARDTUNE_NGINXBACKLOG='y'
    ZSTD_LOGROTATE_NGINX='y'
    ZSTD_LOGROTATE_PHPFPM='y'
    NGINX_LIBBROTLI='y'
    NGXDYNAMIC_BROTLI='y'
    PHP_PGO='y'
    PHP_BROTLI='y'
    PHP_LZFOUR='y'
    PHP_LZF='y'
    PHP_ZSTD='y'
    
    MARCH_TARGETNATIVE='n'
    



    Maybe that I copy and paste everything at the begining caused the problem?

    Now I will add rest and recompile the nginx.


    I followed:
    https://community.centminmod.com/th...-install-setup-your-centmin-mod-server.14736/

    then I add rest of my config.


    I can confirm that the problem is solved.
    The config caused the problem (when I have paste everything at once), but when I add it step by step, it seems be OK.


    @eva2000 thank you for help :)
    Just one question is this is correct:

    Code (Text):
    service mysql status
     ERROR! MariaDB is running but PID file could not be found

    ?
     
    Last edited: Feb 5, 2022