Learn about Centmin Mod LEMP Stack today
Become a Member

cminfo not compatible with MariaDB 10.1?

Discussion in 'Bug Reports' started by RoldanLT, Dec 2, 2015.

  1. RoldanLT

    RoldanLT Well-Known Member

    3,982
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    12:50 AM
    1.11
    10.2
    I got this output:
    Code:
     System Up Since:     2015-11-17 07:59:10
    System Uptime:     up 2 weeks, 16 hours, 50 minutes
    MySQL Server Started     not running
    MySQL Uptime:         not running
    MySQL Uptime (secs):     not running
    Server Type:         kvm
    CentOS Version:     7.1
    Centmin Mod:         1.2.3-eva2000.09
    Nginx PageSpeed:     OFF
    Nginx Version:     1.9.7
    PHP-FPM Version:     5.6.16
    MariaDB Version:     10.1.9
    CSF Firewall:         v8.08
    Memcached Server:     1.4.24
    NSD Version:         61:
    Siege Version:     3.1.0
    Maldet Version:     not installed
    ClamAV Version:     not installed
    ElasticSearch:     2.1.0
    
    Seems not detecting for this value:

     
    • Informative Informative x 1
  2. eva2000

    eva2000 Administrator Staff Member

    31,027
    6,928
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,434
    Local Time:
    2:50 AM
    Nginx 1.13.x
    MariaDB 5.5
    Ah variables changed i think in MariaDB 10.1. Thanks for bug report !

    on MariaDB 10.0.x
    Code:
    rpm -qa | grep -i MariaDB-server | head -n1 | cut -d '-' -f3
    10.0.22
    Code:
    mysqladmin ext | awk '/Uptime|Uptime_since_flush_status/ { print $4 }' | head -n1
    4271
    Code:
    mysqladmin ver | awk '/Uptime/ { print $2, $3, $4, $5, $6, $7, $8, $9 }'
    1 hour 11 min 43 sec  
    Code:
    mysql -e "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP() - variable_value) AS server_start FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE variable_name='Uptime';" | egrep -Ev '+--|server_start'
    2015-12-01 16:07:08
     
    • Like Like x 1
  3. eva2000

    eva2000 Administrator Staff Member

    31,027
    6,928
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,434
    Local Time:
    2:50 AM
    Nginx 1.13.x
    MariaDB 5.5
    let's see what MariaDB 10.1.9 shows for these commands

    on MariaDB 10.1.9
    Code:
    rpm -qa | grep -i MariaDB-server | head -n1 | cut -d '-' -f3
    10.1.9
    why ? the full name without cut is
    Code:
    rpm -qa | grep -i MariaDB-server
    MariaDB-server-10.1.9-1.el7.centos.x86_64
    Code:
    mysqladmin ext | awk '/Uptime|Uptime_since_flush_status/ { print $4 }' | head -n1
    614
    
    Code:
    mysqladmin ver | awk '/Uptime/ { print $2, $3, $4, $5, $6, $7, $8, $9 }'
    10 min 30 sec    
    
    Code:
    mysql -e "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP() - variable_value) AS server_start FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE variable_name='Uptime';" | egrep -Ev '+--|server_start'
    2015-12-01 17:23:14
    
    all work fine.. so it's probably because you're using mysql remote database server ? There's no provisions in cminfo for remote mysql database servers right now, so it's normal to have what you see
     
  4. RoldanLT

    RoldanLT Well-Known Member

    3,982
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    12:50 AM
    1.11
    10.2
    No, just local server.
     
  5. eva2000

    eva2000 Administrator Staff Member

    31,027
    6,928
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,434
    Local Time:
    2:50 AM
    Nginx 1.13.x
    MariaDB 5.5
    strange then.. what do you get when you run those listed above commands manually on MariaDB 10.1 ?
     
  6. eva2000

    eva2000 Administrator Staff Member

    31,027
    6,928
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,434
    Local Time:
    2:50 AM
    Nginx 1.13.x
    MariaDB 5.5
    Ah might be related to my code in cminfo and fact on CentOS7 only MariaDB service name changed from mysql to mariadb !

    see code centminmod/cminfo.sh at master · centminmod/centminmod · GitHub

    strangely MariaDB 10.1. has both service names in use
    Code:
    service mysql status
     ERROR! MySQL is running but PID file could not be found
    
    Code:
    service mariadb status
    Redirecting to /bin/systemctl status  mariadb.service
    mariadb.service - MariaDB database server
       Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
      Drop-In: /etc/systemd/system/mariadb.service.d
               └─migrated-from-my.cnf-settings.conf
       Active: active (running) since Tue 2015-12-01 17:23:15 UTC; 24min ago
    Main PID: 907 (mysqld)
       Status: "Taking your SQL requests now..."
       CGroup: /system.slice/mariadb.se
     
  7. RoldanLT

    RoldanLT Well-Known Member

    3,982
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    12:50 AM
    1.11
    10.2
    All work fine, hmmm.
    [​IMG]
     
  8. eva2000

    eva2000 Administrator Staff Member

    31,027
    6,928
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,434
    Local Time:
    2:50 AM
    Nginx 1.13.x
    MariaDB 5.5
    • Like Like x 1
  9. eva2000

    eva2000 Administrator Staff Member

    31,027
    6,928
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,434
    Local Time:
    2:50 AM
    Nginx 1.13.x
    MariaDB 5.5
    • Like Like x 1
    • Informative Informative x 1