mysqlmymonlite.sh server stats gathering tool for cPanel Server

user/pass is ok, all others mysqlmymonlite switch working fine.
Just i have problem with ./mysqlmymonlite.sh mysqltuner
Im confused!

 

Problem resolved after firewall disabled! so strange and why?!

 

I think mysqltuner will be download on server after "./mysqlmymonlite.sh mysqltuner"
Its not good idea for local and intranet servers.

 

Any one who help me about the above issue.

 

What do these mean as recommendations, in relation to how my.cnf should be structured?

Code:

General recommendations:
    Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
    Increase table_open_cache gradually to avoid file descriptor limits
    Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
    Beware that open_files_limit (10000) variable
    should be greater than table_open_cache ( 256)
Variables to adjust:
    query_cache_size (> 10M)
    table_open_cache (> 256)
    innodb_buffer_pool_size (>= 3G) if possible.
    innodb_buffer_pool_instances (=1)

 

I have been trying to install mysqlmymonlite.sh on my server. When I get to the point of running the tool I get the following result:

Code:

[root@host tool]# cp centos/* /root/tool
cp: overwrite ‘/root/tool/config.ini’? y
cp: overwrite ‘/root/tool/mysqlmymonlite.sh’? y
[root@host tool]# ./mysqlmymonlite.sh
awk: fatal: cannot open file `/etc/init.d/nginx' for reading (No such file or directory)
awk: fatal: cannot open file `/etc/init.d/nginx' for reading (No such file or directory)
awk: fatal: cannot open file `/etc/init.d/nginx' for reading (No such file or directory)

The server does have the Engintron nginx installed, but there is nothing in the location specified. After those error messages the script just hangs, and requires a ctrl-c to break out. I have tried both the centos and centos_whm versions of the script with the same result. Is this script incompatible with Engintron nginx?

 

I'm getting this error when running ./mysqlmymonlite for the first time.

Code:

The content of '/home/.cpan/build/DBD-mysql-4.047-4/META.json' is not a HASH reference. Cannot use it.
Configuring C/CA/CAPTTOFU/DBD-mysql-4.047.tar.gz with Makefile.PL
Can't locate Devel/CheckLib.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at Makefile.PL line 12.
BEGIN failed--compilation aborted at Makefile.PL line 12.
No 'Makefile' created  CAPTTOFU/DBD-mysql-4.047.tar.gz
  /usr/bin/perl Makefile.PL OTHERLDFLAGS=-L/usr/lib64 LDFLAGS=-L/usr/lib64 EXTRALIBDIR=/usr/lib64 -- NOT OK
----------------------------------------------------------
Installation complete. Exiting script...
Please re-run ./mysqlmymonlite.sh again

Re-running the script gives the same error.

This is on a fresh installed server. What can I do to solve this?

 

I am no longer on the server I previously had issues on.

However, on a freshly installed server with CentOS 7 I'm again facing issues using the script.

I've downloaded the latest version, and copied centos_whm from within the ZIP file to a directory called /root/mysqlmymonlite.

First attempted run of mysqlmymonlite.sh shows errors at the end of the process.

Code:

Running make for M/MI/MICHIELB/DBD-mysql-4.048.tar.gz

cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
Running Mkbootstrap for mysql ()
chmod 644 "mysql.bs"
"/usr/bin/perl" -MExtUtils::Command::MM -e 'cp_nonempty' -- mysql.bs blib/arch/auto/DBD/mysql/mysql.bs 644
gcc -c  -I/usr/lib64/perl5/vendor_perl/auto/DBI -I/usr/include/mysql -I/usr/include/mysql/mysql -DDBD_MYSQL_WITH_SSL -g  -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic   -DVERSION=\"4.048\" -DXS_VERSION=\"4.048\" -fPIC "-I/usr/lib64/perl5/CORE"   dbdimp.c
In file included from /usr/include/mysql/mysql.h:60:0,
                 from dbdimp.h:21,
                 from dbdimp.c:15:
dbdimp.c: In function ‘mysql_dr_connect’:
/usr/include/mysql/mariadb_version.h:14:31: error: token ""mariadb-10.2"" is not valid in preprocessor expressions
 #define MARIADB_BASE_VERSION  "mariadb-10.2"
                               ^
dbdimp.c:1910:56: note: in expansion of macro ‘MARIADB_BASE_VERSION’
 #if (MYSQL_VERSION_ID >= 50723) && (MYSQL_VERSION_ID < MARIADB_BASE_VERSION)
                                                        ^
/usr/include/mysql/mariadb_version.h:14:31: error: token ""mariadb-10.2"" is not valid in preprocessor expressions
 #define MARIADB_BASE_VERSION  "mariadb-10.2"
                               ^
dbdimp.c:1917:56: note: in expansion of macro ‘MARIADB_BASE_VERSION’
 #if (MYSQL_VERSION_ID >= 50600) && (MYSQL_VERSION_ID < MARIADB_BASE_VERSION)
                                                        ^
dbdimp.c:1936:19: warning: unused variable ‘ssl_mode’ [-Wunused-variable]
      unsigned int ssl_mode;
                   ^
dbdimp.c: In function ‘mysql_st_prepare’:
dbdimp.c:3200:24: warning: assignment from incompatible pointer type [enabled by default]
           bind->is_null=      (_Bool*) &(fbind->is_null);
                        ^
gmake: *** [dbdimp.o] Error 1
  MICHIELB/DBD-mysql-4.048.tar.gz
  /usr/bin/gmake OTHERLDFLAGS=-L/usr/lib64 LDFLAGS=-L/usr/lib64 EXTRALIBDIR=/usr/lib64 OTHERLDFLAGS=-L/usr/lib64 LDFLAGS=-L/usr/lib64 EXTRALIBDIR=/usr/lib64 -- NOT OK
----------------------------------------------------------
Installation complete. Exiting script...
Please re-run ./mysqlmymonlite.sh again

Trying to run mysqlmymonlite.sh again, I get the following errors.

Code:

/usr/include/mysql/mariadb_version.h:14:31: error: token ""mariadb-10.2"" is not valid in preprocessor expressions
 #define MARIADB_BASE_VERSION  "mariadb-10.2"
                               ^
dbdimp.c:1910:56: note: in expansion of macro ‘MARIADB_BASE_VERSION’
 #if (MYSQL_VERSION_ID >= 50723) && (MYSQL_VERSION_ID < MARIADB_BASE_VERSION)
                                                        ^
/usr/include/mysql/mariadb_version.h:14:31: error: token ""mariadb-10.2"" is not valid in preprocessor expressions
 #define MARIADB_BASE_VERSION  "mariadb-10.2"
                               ^
dbdimp.c:1917:56: note: in expansion of macro ‘MARIADB_BASE_VERSION’
 #if (MYSQL_VERSION_ID >= 50600) && (MYSQL_VERSION_ID < MARIADB_BASE_VERSION)
                                                        ^
dbdimp.c:1936:19: warning: unused variable ‘ssl_mode’ [-Wunused-variable]
      unsigned int ssl_mode;
                   ^
dbdimp.c: In function ‘mysql_st_prepare’:
dbdimp.c:3200:24: warning: assignment from incompatible pointer type [enabled by default]
           bind->is_null=      (_Bool*) &(fbind->is_null);
                        ^
gmake: *** [dbdimp.o] Error 1
  MICHIELB/DBD-mysql-4.048.tar.gz
  /usr/bin/gmake OTHERLDFLAGS=-L/usr/lib64 LDFLAGS=-L/usr/lib64 EXTRALIBDIR=/usr/lib64 OTHERLDFLAGS=-L/usr/lib64 LDFLAGS=-L/usr/lib64 EXTRALIBDIR=/usr/lib64 -- NOT OK
----------------------------------------------------------
Installation complete. Exiting script...
Please re-run ./mysqlmymonlite.sh again

I am running MariaDB 10.2.18.

Are you able to point me in the right direction to what might be wrong here?

Thank you.

 

Thank you.

Mysqltuner is missing a lot of the great features in mysqlmymonlite.

I was hoping @eva2000 or someone knew how to fix this, I would like to get the script going again.

I dont know why it fails a fresh Centos 7/WHM with MariaDB.

Anyone else experiencing issues with this?

Does it require certain perl modules that I might be missing?

Any guidance would be appreciated.

 

I'm getting the error running mysqlmymonlite.sh without any options.

Instaling DBD::mysql (4.048) returns errors and fails.

Code:

In file included from /usr/include/mysql/mysql.h:60:0,
                 from dbdimp.h:21,
                 from dbdimp.c:15:
dbdimp.c: In function 'mysql_dr_connect':
/usr/include/mysql/mariadb_version.h:14:31: error: token ""mariadb-10.2"" is not valid in preprocessor expressions
 #define MARIADB_BASE_VERSION  "mariadb-10.2"
                               ^
dbdimp.c:1910:56: note: in expansion of macro 'MARIADB_BASE_VERSION'
 #if (MYSQL_VERSION_ID >= 50723) && (MYSQL_VERSION_ID < MARIADB_BASE_VERSION)
                                                        ^
/usr/include/mysql/mariadb_version.h:14:31: error: token ""mariadb-10.2"" is not valid in preprocessor expressions
 #define MARIADB_BASE_VERSION  "mariadb-10.2"
                               ^
dbdimp.c:1917:56: note: in expansion of macro 'MARIADB_BASE_VERSION'
 #if (MYSQL_VERSION_ID >= 50600) && (MYSQL_VERSION_ID < MARIADB_BASE_VERSION)
                                                        ^
dbdimp.c:1936:19: warning: unused variable 'ssl_mode' [-Wunused-variable]
      unsigned int ssl_mode;
                   ^
dbdimp.c: In function 'mysql_st_prepare':
dbdimp.c:3200:24: warning: assignment from incompatible pointer type [enabled by default]
           bind->is_null=      (_Bool*) &(fbind->is_null);
                        ^
make: *** [dbdimp.o] Error 1

FAIL
! Installing DBD::mysql failed. See /home/.cpanm/work/1540804090.13018/build.log for details. Retry with --force to force install it.
Expiring 14 work directories.
System Expect failed with non-zero exit status: 1

I can't find an option to install DBD::mysql (4.049), not sure if it's released yet.

Due to your suggestion of installing this module, is it correct to say this module is required to run mysqlmymonlite.sh?

Thank you.

 

Over the weekend I did a test to put this to rest.

1. I installed CentOS 7 and release tier of cPanel on a new VPS. After a very basic configuration of WHM/cPanel, I then proceeded to install mysqlmymonlite. Everything works fine.

2. I wiped the VPS and reinstalled CentOS and cPanel. I did the exact same configuration once again, but this around I installed/upgraded to MariaDB 10.2. I then installed mysqlmymonlite, and it fails.

I don't understand what the exact reason of why bits and pieces are failing, but to me mysqlmymonlite does not seem compatible with MariaDB 10.2 in a CentOS/cPanel enviroment.

Thats my conclusion.