mysqlmymonlite.sh server stats gathering tool for cPanel Server

wonder_wonder

Well-Known Member
Jan 16, 2019
108
40
28
Spain
cPanel Access Level
Root Administrator
Hi,

I have this problem, can't install mysqlmymonlite...
In others servers, without problems, install perfect, but yesterday I migrate one server, after configured I go to install mysqlmymonline and I can't.
I have 2 erros, one, I was can solved, but now I have this:
Code:
[[email protected] ~]# ./mysqlmymonlite.sh
----------------------------------------------------------
Detected missing perl Devel::CheckLib module
Installing missing perl module...
----------------------------------------------------------
perl -MCPAN -e 'install Devel::CheckLib'
Can't locate CPAN.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 .).
BEGIN failed--compilation aborted.
----------------------------------------------------------
Detected missing perl DBD::mysql module
Installing missing perl module...
----------------------------------------------------------
perl -MCPAN -e 'install DBD::mysql'
Can't locate CPAN.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 .).
BEGIN failed--compilation aborted.
----------------------------------------------------------
Installation complete. Exiting script...
Please re-run ./mysqlmymonlite.sh again
[[email protected] ~]#
I search...but...I don't view how solved this...

Thanks in advance.
 
  • Like
Reactions: Emonkdzuu

wonder_wonder

Well-Known Member
Jan 16, 2019
108
40
28
Spain
cPanel Access Level
Root Administrator
Hi @eva2000 , I know at you of others forums (in the others forum I have other username, in this I can't because my username is to short in letters).
I have install you mysqlmymonlite for some time ago, all good, I use for mysqltunner and optimize the database.
Yesterday I execute again, and I view this about my version installed:
Code:
[[email protected] ~]# ./mysqlmymonlite.sh mysqltuner

-------------------------------------------------------------
System MySQL monitoring stats
mysqlmymonlite.sh - 0.5.7 WHM mysqlmymon.com
compiled by George Liu (eva2000) centminmod.com
-------------------------------------------------------------

Report Generated:
Thu Feb 20 03:29:46 CET 2020

-------------------------------------------------
mysqltuner output
-------------------------------------------------
mysqltuner.pl [found]
 >>  MySQLTuner 1.7.14 - Major Hayden <[email protected]>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Modified by George Liu (eva2000) at https://centminmod.com/
 >>  Run with '--help' for additional options and output filtering
I view version of mysqlmymonlite.sh are 0.5.7 but of mysql tuner are 1.7.14.
I go to the urls that indicate this script, in centminmond.com I view the centminmod but not onlye the mysqlmymonlite.sh (only need this) and then go to mysqltuner.com and I view that, are a other version more new, the 1.7.19.

My doubt: Its possible update mysqltuner under your mysqlmymonlite.sh? I think we have the latest version of mysqlmymonlite.sh (0.5.7) in the site for download, are this version, but like indicate, mysqltuner have or are a newer version in the mysqltuner site.

I wait explained well.

And congratulations for all your work since a lot years ago, I know at you when you start with this in the vb forums :)

Have a cordial greeting!!!
 

wonder_wonder

Well-Known Member
Jan 16, 2019
108
40
28
Spain
cPanel Access Level
Root Administrator
Hi,
I don't edit my post for if help to other people or some are vew and if I edit, not view the change...

Curious case, it is not the first time it has happened to me.
I have some doubt or problem, I look for information, it can take me some day or several or it depends, whatever, finally, when I see that I can't solve it and find the necessary info, I ask the question in the corresponding forum ... shortly after post the query, I see the option and find the necessary info ... and this time, this has happened to me ...
And it's not the first time...

Well, if it works for someone, after installing mysqlmymonlite.sh, it creates a file in the same directory called mysqltuner.pl.
We go to the url indicated in the script to see updates, in this case: http://mysqltuner.com/
It takes us to a page with the content (as of today) of said file, as simple as picking up said content and replacing it with the content of our mysqltuner.pl (it is always advisable to backup before it could happen).

And we have mysqlmymonlite.sh and its updated mysqltuner option.

Greetings.