mysqlmymonlite.sh server stats gathering tool for cPanel Server

eva2000

Well-Known Member
Aug 14, 2001
339
16
318
Brisbane, Australia
cPanel Access Level
Root Administrator
Twitter
Hello eva2000,

Thank you so much for this.

Guys at cpanel, I have now installed the software: mysqlmonlite.sh - I am wondering if I can pay someone at cpanel to look at my VPS, can come up with some solutions to reduce the intermittent high server loads that occurs.

Can someone buzz me back how I can engage your services?

Kind regards,
Anthony
Yes I only provide the script, what you do with the outputted stats and info is left up to you.


Just heads up 0.4.8 version was just released :)
 

jette

Registered
May 24, 2013
1
0
1
cPanel Access Level
Root Administrator
Hi,
I keep getting errors when creating cron job
mmysqlmymonlite.sh run 2>/dev/null | mail -s "`hostname` Monitoring Stats: `date`" emailaddress
Can you help me if I need to change hostname or add a date, and how to format a date?
There is no clear instructions in the readme.txt when it got to the cron job which is what is important to me.
It is installed but I can make it to email me the stats every hour.
Thanks
 

PPNSteve

Well-Known Member
Mar 13, 2003
413
3
168
Somewhere in Ilex Forest
cPanel Access Level
Root Administrator
Twitter
seeing a problerm with this script:

Code:
]# ./mysqlmymonlite.sh mysqltuner

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

Report Generated:
Sun Oct 27 06:46:18 UTC 2013

-------------------------------------------------
mysqltuner output
-------------------------------------------------
mysqltuner.pl [found]

 >>  MySQLTuner 1.2.1 mod - Major Hayden <[email protected]>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Modified by George Liu (eva2000) at http://vbtechsupport.com/
 >>  Run with '--help' for additional options and output filtering
[!!] The --forcemem option is required for remote connections

Report Complete:
Sun Oct 27 06:46:19 UTC 2013
----------------------------
 

xman888

Well-Known Member
Nov 23, 2005
61
1
158
Hello,

I have the same issue as PPNSteve - does any on have any suggestions?

I get the same error:

Code:
[!!] The --forcemem option is required for remote connections
I have tried running the command with --forcemem option, but is still showing the error.

It is cpanel (VPS): CLOUDLINUX 5.10 x86_64 xenpv – server11 WHM 11.38.2 (build 12)

Any hep would be appreciated.

Kind regards,
Anthony

My config.ini file is:

Code:
#######################################################
# Copyright (C) 2011-2013
# Program: mysqlmymonlite.sh
# Lite version of extensive featured mysqlmymon.sh
# MySQL and system monitoring script 
# by George Liu (eva2000) vbtechsupport.com
# Updated: August 8th, 2013 AEST 
MYSQLMYMONVER='0.5.0 WHM'
MYSQLMYMONURL='mysqlmymon.com'
#######################################################
# Usage is free just keep the credits intact
#######################################################
# NO SUPPORT PROVIDED, script is provided as is
# To understand mysqlreport, mysqltuner.pl,
# read their respective documentation
#######################################################
# Command options below:
#######################################################
# ./mysqlmymonlite.sh --help
# ./mysqlmymonlite.sh check
# ./mysqlmymonlite.sh run
# ./mysqlmymonlite.sh mysql
# ./mysqlmymonlite.sh vmstat
# ./mysqlmymonlite.sh showcreate
# ./mysqlmymonlite.sh showindex
# ./mysqlmymonlite.sh vbshowtables
# ./mysqlmymonlite.sh dblist
# ./mysqlmymonlite.sh mysqlreport
# ./mysqlmymonlite.sh mysqlfullreport
# ./mysqlmymonlite.sh mysqltuner
# ./mysqlmymonlite.sh psmem
#######################################################
# Create mysqlusername/password with following privileges
# GRANT ALL PRIVILEGES ON *.* TO 'vbuserinfo'@'localhost' IDENTIFIED BY 'enteryourpassword';
#######################################################
# Edit variables below
#######################################################

DT=`date +"%d%m%y-%H%M%S"`

MYCNF='/root/.my.cnf'
USER='root'
PASS='(*** my password at /root/.my.cnf ***)'

# change from localhost if your have a remote 
# mysql server with dedicated ip address
# if you set MYSQLHOST to remote server ip please set
# FORCEMEM and FORCESWAP values below in megabytes
# which relate to how much memory and swap space your
# remote MySQL server has i.e. 512MB & 512MB
MYSQLHOST='localhost'
FORCEMEM='4096'
FORCESWAP='4096'
# change from n to y if this server is dedicated
# mysql server with no apache, nginx, php installed
MYSQLSERVERONLY='n'

# MySQL database per table details output setting to 'y' will show per database 
# table's name, storage engine type, number of table rows, index and data and 
# total size per table
# if you have alot of databases/tables ALOT of text will be outputted
SHOWPERTABLE='n'

# If set to yes = 'y', per database table list has
# database name partially masked to protect privacy
MASKDB='y'

# If you use nginx web server and have an non-standard path to where your
# nginx.conf is located, you can define it in this variable to override the scripts
# detection for nginx.conf path i.e. /etc/nginx/nginx.conf or /usr/local/nginx/nginx.conf
NGINXCONFPATHOVERRIDE=''
#######################################################
# Excludb databases list from per Table listing
# You can hide all other database names from having
# their database table names listed leaving just
# your vBulletin databasenames to display the per
# Table listing which is needed for optimisation
# tuning to see which tables are innodb or myisam
# to see their index and data sizes per table
#######################################################
# to get a full list of database names type:
# ./mysqlmymonlite.sh dblist
# single spacing between each databasename
#######################################################
EXCLUDEDB="test information_schema mysql"
 

xman888

Well-Known Member
Nov 23, 2005
61
1
158
Re: mysqlmymonlite.sh & mysqltuner option

Hello Chae,

I get the same issue:

The --forcemem option is required for remote connections

Were you able to sort out?

Kind regards,
Anthony
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Re: mysqlmymonlite.sh & mysqltuner option

Is MySQL running on a remote server? If so, try running the tuner on the remote MySQL server itself.

Thank you.
 

xman888

Well-Known Member
Nov 23, 2005
61
1
158
Hello eva2000,

Thank you for the reply.

The mysql server is on localhost.

I have 'localhost' set.

Can you please advise?

Kind regards,
Anthony
 

JaredR.

Well-Known Member
Feb 25, 2010
1,834
23
143
Houston, TX
cPanel Access Level
Root Administrator
If you would like to see this tool distributed with cPanel, please submit a feature request here:

cPanel Feature Requests

Our developers use feature requests to plan and prioritize changes to the product, so the more votes and comments a feature receives, the more likely it is to be included in a future version of cPanel.
 

beninfl

Member
May 23, 2014
5
0
1
cPanel Access Level
Root Administrator
This is what I get when I run it.............

Code:
#./mysqlmonlite.sh

----------------------------------------------------------
Detected missing perl DBD::mysql module
Installing missing perl module...
----------------------------------------------------------
perl -MCPAN -e 'install DBD::mysql'
CPAN: Storable loaded ok (v2.20)
Reading '/home/.cpan/Metadata'
  Database was generated on Mon, 26 May 2014 02:06:08 GMT
Running install for module 'DBD::mysql'
CPAN: Digest::SHA loaded ok (v5.47)
CPAN: Compress::Zlib loaded ok (v2.021)
Checksum for /home/.cpan/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.027.tar.gz ok
CPAN: Archive::Tar loaded ok (v1.58)
DBD-mysql-4.027/
DBD-mysql-4.027/ChangeLog
DBD-mysql-4.027/constants.h
DBD-mysql-4.027/dbdimp.c
DBD-mysql-4.027/dbdimp.h
DBD-mysql-4.027/eg/
DBD-mysql-4.027/lib/
DBD-mysql-4.027/Makefile.PL
DBD-mysql-4.027/Makefile.PL.embedded
DBD-mysql-4.027/MANIFEST
DBD-mysql-4.027/MANIFEST.SKIP
DBD-mysql-4.027/META.json
DBD-mysql-4.027/META.yml
DBD-mysql-4.027/myld
DBD-mysql-4.027/mysql.xs
DBD-mysql-4.027/README.pod
DBD-mysql-4.027/t/
DBD-mysql-4.027/TODO
DBD-mysql-4.027/t/00base.t
DBD-mysql-4.027/t/10connect.t
DBD-mysql-4.027/t/15reconnect.t
DBD-mysql-4.027/t/20createdrop.t
DBD-mysql-4.027/t/25lockunlock.t
DBD-mysql-4.027/t/29warnings.t
DBD-mysql-4.027/t/30insertfetch.t
DBD-mysql-4.027/t/31insertid.t
DBD-mysql-4.027/t/32insert_error.t
DBD-mysql-4.027/t/35limit.t
DBD-mysql-4.027/t/35prepare.t
DBD-mysql-4.027/t/40bindparam.t
DBD-mysql-4.027/t/40bindparam2.t
DBD-mysql-4.027/t/40blobs.t
DBD-mysql-4.027/t/40catalog.t
DBD-mysql-4.027/t/40keyinfo.t
DBD-mysql-4.027/t/40listfields.t
DBD-mysql-4.027/t/40nulls.t
DBD-mysql-4.027/t/40nulls_prepare.t
DBD-mysql-4.027/t/40numrows.t
DBD-mysql-4.027/t/40server_prepare.t
DBD-mysql-4.027/t/40server_prepare_error.t
DBD-mysql-4.027/t/40types.t
DBD-mysql-4.027/t/41bindparam.t
DBD-mysql-4.027/t/41blobs_prepare.t
DBD-mysql-4.027/t/42bindparam.t
DBD-mysql-4.027/t/43count_params.t
DBD-mysql-4.027/t/50chopblanks.t
DBD-mysql-4.027/t/50commit.t
DBD-mysql-4.027/t/51bind_type_guessing.t
DBD-mysql-4.027/t/52comment.t
DBD-mysql-4.027/t/53comment.t
DBD-mysql-4.027/t/55utf8.t
DBD-mysql-4.027/t/60leaks.t
DBD-mysql-4.027/t/65segfault.t
DBD-mysql-4.027/t/65types.t
DBD-mysql-4.027/t/70takeimp.t
DBD-mysql-4.027/t/71impdata.t
DBD-mysql-4.027/t/75supported_sql.t
DBD-mysql-4.027/t/76multi_statement.t
DBD-mysql-4.027/t/80procs.t
DBD-mysql-4.027/t/81procs.t
DBD-mysql-4.027/t/85init_command.t
DBD-mysql-4.027/t/86_bug_36972.t
DBD-mysql-4.027/t/87async.t
DBD-mysql-4.027/t/88async-multi-stmts.t
DBD-mysql-4.027/t/89async-method-check.t
DBD-mysql-4.027/t/90no-async.t
DBD-mysql-4.027/t/91errcheck.t
DBD-mysql-4.027/t/99_bug_server_prepare_blob_null.t
DBD-mysql-4.027/t/lib.pl
DBD-mysql-4.027/t/manifest.t
DBD-mysql-4.027/t/mysql.dbtest
DBD-mysql-4.027/t/mysql.mtest
DBD-mysql-4.027/t/pod.t
DBD-mysql-4.027/t/rt25389-bin-case.t
DBD-mysql-4.027/t/rt50304-column_info_parentheses.t
DBD-mysql-4.027/t/rt83494-quotes-comments.t
DBD-mysql-4.027/t/rt85919-fetch-lost-connection.t
DBD-mysql-4.027/t/rt86153-reconnect-fail-memory.t
DBD-mysql-4.027/t/rt91715.t
DBD-mysql-4.027/lib/Bundle/
DBD-mysql-4.027/lib/DBD/
DBD-mysql-4.027/lib/DBD/mysql/
DBD-mysql-4.027/lib/DBD/mysql.pm
DBD-mysql-4.027/lib/DBD/mysql/GetInfo.pm
DBD-mysql-4.027/lib/DBD/mysql/INSTALL.pod
DBD-mysql-4.027/lib/Bundle/DBD/
DBD-mysql-4.027/lib/Bundle/DBD/mysql.pm
DBD-mysql-4.027/eg/bigint_quotes.pl
DBD-mysql-4.027/eg/bug14979.pl
DBD-mysql-4.027/eg/bug21028.pl
DBD-mysql-4.027/eg/bug30033.pl
DBD-mysql-4.027/eg/bug30033pg.pl
DBD-mysql-4.027/eg/decimal_test.pl
DBD-mysql-4.027/eg/issue21946.pl
DBD-mysql-4.027/eg/prepare_memory_usage.pl
DBD-mysql-4.027/eg/proc_example1.pl
DBD-mysql-4.027/eg/proc_example2.pl
DBD-mysql-4.027/eg/proc_example2a.pl
DBD-mysql-4.027/eg/proc_example2b.pl
DBD-mysql-4.027/eg/proc_example3.pl
DBD-mysql-4.027/eg/proc_example4.pl
CPAN: File::Temp loaded ok (v0.22)
'YAML' not installed, will not store persistent state
CPAN: Parse::CPAN::Meta loaded ok (v1.4405)
CPAN: CPAN::Meta loaded ok (v2.120351)
CPAN: Module::CoreList loaded ok (v2.18)
Configuring C/CA/CAPTTOFU/DBD-mysql-4.027.tar.gz with Makefile.PL


PLEASE NOTE:

For 'make test' to run properly, you must ensure that the
database user 'root' can connect to your MySQL server
and has the proper privileges that these tests require such
as 'drop table', 'create table', 'drop procedure', 'create procedure'
as well as others.

mysql> grant all privileges on test.* to 'root'@'localhost' identified by 's3kr1t';

You can also optionally set the user to run 'make test' with:

perl Makefile.PL --testuser=username

I will use the following settings for compiling and testing:

  cflags        (mysql_config) = -I/usr/include/mysql -g -fPIC -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FASTMUTEX=1
  embedded      (mysql_config) = 
  ldflags       (mysql_config) = 
  libs          (mysql_config) = -L/usr/lib -lmysqlclient -lpthread -lm -lrt -ldl
  mysql_config  (guessed     ) = mysql_config
  nocatchstderr (default     ) = 0
  nofoundrows   (default     ) = 0
  ssl           (guessed     ) = 0
  testdb        (default     ) = test
  testhost      (default     ) = 
  testpassword  (default     ) = 
  testport      (default     ) = 
  testsocket    (default     ) = 
  testuser      (guessed     ) = root

To change these settings, see 'perl Makefile.PL --help' and
'perldoc DBD::mysql::INSTALL'.

Checking if your kit is complete...
Looks good
Using DBI 1.631 (for perl 5.010001 on i386-linux-thread-multi) installed in /usr/local/lib/perl5/auto/DBI/
Generating a Unix-style Makefile
Writing Makefile for DBD::mysql
Writing MYMETA.yml and MYMETA.json
  CAPTTOFU/DBD-mysql-4.027.tar.gz
  /usr/bin/perl Makefile.PL -- OK
Running make for C/CA/CAPTTOFU/DBD-mysql-4.027.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 README.pod blib/lib/DBD/README.pod
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 DBD::mysql ()
chmod 644 mysql.bs
gcc -c  -I/usr/local/lib/perl5/auto/DBI -I/usr/include/mysql -g -fPIC -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FASTMUTEX=1 -DDBD_MYSQL_INSERT_ID_IS_GOOD -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 --param=ssp-buffer-size=4 -m32 -march=i686 -mtune=atom -fasynchronous-unwind-tables   -DVERSION=\"4.027\" -DXS_VERSION=\"4.027\" -fPIC "-I/usr/lib/perl5/CORE"   dbdimp.c
dbdimp.c: In function ‘dbd_discon_all’:
dbdimp.c:2241: warning: unused variable ‘imp_xxh’
dbdimp.c: In function ‘mysql_db_STORE_attrib’:
dbdimp.c:2417: warning: value computed is not used
dbdimp.c: In function ‘mysql_db_FETCH_attrib’:
dbdimp.c:2530: warning: value computed is not used
dbdimp.c:2537: warning: value computed is not used
dbdimp.c: In function ‘mysql_st_prepare’:
dbdimp.c:2660: warning: unused variable ‘limit_flag’
dbdimp.c: In function ‘mysql_st_next_results’:
dbdimp.c:3096: warning: value computed is not used
dbdimp.c:3097: warning: value computed is not used
dbdimp.c:3098: warning: value computed is not used
dbdimp.c:3099: warning: value computed is not used
dbdimp.c:3100: warning: value computed is not used
dbdimp.c:3101: warning: value computed is not used
dbdimp.c:3102: warning: value computed is not used
dbdimp.c:3103: warning: value computed is not used
dbdimp.c:3104: warning: value computed is not used
dbdimp.c:3105: warning: value computed is not used
dbdimp.c:3106: warning: value computed is not used
dbdimp.c:3107: warning: value computed is not used
dbdimp.c:3108: warning: value computed is not used
dbdimp.c:3109: warning: value computed is not used
dbdimp.c:3110: warning: value computed is not used
dbdimp.c:3111: warning: value computed is not used
dbdimp.c:3112: warning: value computed is not used
dbdimp.c:3113: warning: value computed is not used
dbdimp.c: In function ‘mysql_st_FETCH_attrib’:
dbdimp.c:4508: warning: value computed is not used
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/local/lib/perl5/auto/DBI/Driver.xst > mysql.xsi
/usr/bin/perl /usr/share/perl5/ExtUtils/xsubpp  -typemap /usr/share/perl5/ExtUtils/typemap  mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 242
Warning: duplicate function definition 'rows' detected in mysql.xs, line 754
gcc -c  -I/usr/local/lib/perl5/auto/DBI -I/usr/include/mysql -g -fPIC -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FASTMUTEX=1 -DDBD_MYSQL_INSERT_ID_IS_GOOD -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 --param=ssp-buffer-size=4 -m32 -march=i686 -mtune=atom -fasynchronous-unwind-tables   -DVERSION=\"4.027\" -DXS_VERSION=\"4.027\" -fPIC "-I/usr/lib/perl5/CORE"   mysql.c
mysql.xs: In function ‘XS_DBD__mysql__db_do’:
mysql.xs:309: warning: value computed is not used
mysql.xs:260: warning: unused variable ‘statement_ptr’
mysql.xs: In function ‘XS_DBD__mysql__st_more_results’:
mysql.xs:691: warning: unused variable ‘retval’
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/lib" /usr/bin/perl myld gcc  -shared -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i686 -mtune=atom -fasynchronous-unwind-tables -L/usr/local/lib dbdimp.o mysql.o  -o blib/arch/auto/DBD/mysql/mysql.so        \
           -L/usr/lib -lmysqlclient -lpthread -lm -lrt -ldl     \
          
chmod 755 blib/arch/auto/DBD/mysql/mysql.so
/usr/bin/perl -MExtUtils::Command::MM -e 'cp_nonempty' -- mysql.bs blib/arch/auto/DBD/mysql/mysql.bs 644
Manifying blib/man3/DBD::README.3pm
Manifying blib/man3/Bundle::DBD::mysql.3pm
Manifying blib/man3/DBD::mysql.3pm
Manifying blib/man3/DBD::mysql::INSTALL.3pm
  CAPTTOFU/DBD-mysql-4.027.tar.gz
  /usr/bin/gmake -- OK
Running make test
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base.t ........................... ok   
t/10connect.t ........................ Bailout called.  Further testing stopped:  ERROR: Access denied for user 'root'@'localhost' (using password: NO)
FAILED--Further testing stopped: ERROR: Access denied for user 'root'@'localhost' (using password: NO)
gmake: *** [test_dynamic] Error 255
  CAPTTOFU/DBD-mysql-4.027.tar.gz
  /usr/bin/gmake test -- NOT OK
//hint// to see the cpan-testers results for installing this module, try:
  reports CAPTTOFU/DBD-mysql-4.027.tar.gz
----------------------------------------------------------
Installation complete. Exiting script...
Please re-run ./mysqlmymonlite.sh again
So I run it again, and it does the exact same thing. :)

Any ideas on how to make it work?
 

david.cocos

Member
May 19, 2014
19
0
1
cPanel Access Level
Root Administrator
This is what I get when I run it.............

Code:
#./mysqlmonlite.sh

----------------------------------------------------------
Detected missing perl DBD::mysql module
Installing missing perl module...
----------------------------------------------------------
perl -MCPAN -e 'install DBD::mysql'
CPAN: Storable loaded ok (v2.20)
Reading '/home/.cpan/Metadata'
  Database was generated on Mon, 26 May 2014 02:06:08 GMT
Running install for module 'DBD::mysql'
CPAN: Digest::SHA loaded ok (v5.47)
CPAN: Compress::Zlib loaded ok (v2.021)
Checksum for /home/.cpan/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.027.tar.gz ok
CPAN: Archive::Tar loaded ok (v1.58)
DBD-mysql-4.027/
DBD-mysql-4.027/ChangeLog
DBD-mysql-4.027/constants.h
DBD-mysql-4.027/dbdimp.c
DBD-mysql-4.027/dbdimp.h
DBD-mysql-4.027/eg/
DBD-mysql-4.027/lib/
DBD-mysql-4.027/Makefile.PL
DBD-mysql-4.027/Makefile.PL.embedded
DBD-mysql-4.027/MANIFEST
DBD-mysql-4.027/MANIFEST.SKIP
DBD-mysql-4.027/META.json
DBD-mysql-4.027/META.yml
DBD-mysql-4.027/myld
DBD-mysql-4.027/mysql.xs
DBD-mysql-4.027/README.pod
DBD-mysql-4.027/t/
DBD-mysql-4.027/TODO
DBD-mysql-4.027/t/00base.t
DBD-mysql-4.027/t/10connect.t
DBD-mysql-4.027/t/15reconnect.t
DBD-mysql-4.027/t/20createdrop.t
DBD-mysql-4.027/t/25lockunlock.t
DBD-mysql-4.027/t/29warnings.t
DBD-mysql-4.027/t/30insertfetch.t
DBD-mysql-4.027/t/31insertid.t
DBD-mysql-4.027/t/32insert_error.t
DBD-mysql-4.027/t/35limit.t
DBD-mysql-4.027/t/35prepare.t
DBD-mysql-4.027/t/40bindparam.t
DBD-mysql-4.027/t/40bindparam2.t
DBD-mysql-4.027/t/40blobs.t
DBD-mysql-4.027/t/40catalog.t
DBD-mysql-4.027/t/40keyinfo.t
DBD-mysql-4.027/t/40listfields.t
DBD-mysql-4.027/t/40nulls.t
DBD-mysql-4.027/t/40nulls_prepare.t
DBD-mysql-4.027/t/40numrows.t
DBD-mysql-4.027/t/40server_prepare.t
DBD-mysql-4.027/t/40server_prepare_error.t
DBD-mysql-4.027/t/40types.t
DBD-mysql-4.027/t/41bindparam.t
DBD-mysql-4.027/t/41blobs_prepare.t
DBD-mysql-4.027/t/42bindparam.t
DBD-mysql-4.027/t/43count_params.t
DBD-mysql-4.027/t/50chopblanks.t
DBD-mysql-4.027/t/50commit.t
DBD-mysql-4.027/t/51bind_type_guessing.t
DBD-mysql-4.027/t/52comment.t
DBD-mysql-4.027/t/53comment.t
DBD-mysql-4.027/t/55utf8.t
DBD-mysql-4.027/t/60leaks.t
DBD-mysql-4.027/t/65segfault.t
DBD-mysql-4.027/t/65types.t
DBD-mysql-4.027/t/70takeimp.t
DBD-mysql-4.027/t/71impdata.t
DBD-mysql-4.027/t/75supported_sql.t
DBD-mysql-4.027/t/76multi_statement.t
DBD-mysql-4.027/t/80procs.t
DBD-mysql-4.027/t/81procs.t
DBD-mysql-4.027/t/85init_command.t
DBD-mysql-4.027/t/86_bug_36972.t
DBD-mysql-4.027/t/87async.t
DBD-mysql-4.027/t/88async-multi-stmts.t
DBD-mysql-4.027/t/89async-method-check.t
DBD-mysql-4.027/t/90no-async.t
DBD-mysql-4.027/t/91errcheck.t
DBD-mysql-4.027/t/99_bug_server_prepare_blob_null.t
DBD-mysql-4.027/t/lib.pl
DBD-mysql-4.027/t/manifest.t
DBD-mysql-4.027/t/mysql.dbtest
DBD-mysql-4.027/t/mysql.mtest
DBD-mysql-4.027/t/pod.t
DBD-mysql-4.027/t/rt25389-bin-case.t
DBD-mysql-4.027/t/rt50304-column_info_parentheses.t
DBD-mysql-4.027/t/rt83494-quotes-comments.t
DBD-mysql-4.027/t/rt85919-fetch-lost-connection.t
DBD-mysql-4.027/t/rt86153-reconnect-fail-memory.t
DBD-mysql-4.027/t/rt91715.t
DBD-mysql-4.027/lib/Bundle/
DBD-mysql-4.027/lib/DBD/
DBD-mysql-4.027/lib/DBD/mysql/
DBD-mysql-4.027/lib/DBD/mysql.pm
DBD-mysql-4.027/lib/DBD/mysql/GetInfo.pm
DBD-mysql-4.027/lib/DBD/mysql/INSTALL.pod
DBD-mysql-4.027/lib/Bundle/DBD/
DBD-mysql-4.027/lib/Bundle/DBD/mysql.pm
DBD-mysql-4.027/eg/bigint_quotes.pl
DBD-mysql-4.027/eg/bug14979.pl
DBD-mysql-4.027/eg/bug21028.pl
DBD-mysql-4.027/eg/bug30033.pl
DBD-mysql-4.027/eg/bug30033pg.pl
DBD-mysql-4.027/eg/decimal_test.pl
DBD-mysql-4.027/eg/issue21946.pl
DBD-mysql-4.027/eg/prepare_memory_usage.pl
DBD-mysql-4.027/eg/proc_example1.pl
DBD-mysql-4.027/eg/proc_example2.pl
DBD-mysql-4.027/eg/proc_example2a.pl
DBD-mysql-4.027/eg/proc_example2b.pl
DBD-mysql-4.027/eg/proc_example3.pl
DBD-mysql-4.027/eg/proc_example4.pl
CPAN: File::Temp loaded ok (v0.22)
'YAML' not installed, will not store persistent state
CPAN: Parse::CPAN::Meta loaded ok (v1.4405)
CPAN: CPAN::Meta loaded ok (v2.120351)
CPAN: Module::CoreList loaded ok (v2.18)
Configuring C/CA/CAPTTOFU/DBD-mysql-4.027.tar.gz with Makefile.PL


PLEASE NOTE:

For 'make test' to run properly, you must ensure that the
database user 'root' can connect to your MySQL server
and has the proper privileges that these tests require such
as 'drop table', 'create table', 'drop procedure', 'create procedure'
as well as others.

mysql> grant all privileges on test.* to 'root'@'localhost' identified by 's3kr1t';

You can also optionally set the user to run 'make test' with:

perl Makefile.PL --testuser=username

I will use the following settings for compiling and testing:

  cflags        (mysql_config) = -I/usr/include/mysql -g -fPIC -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FASTMUTEX=1
  embedded      (mysql_config) = 
  ldflags       (mysql_config) = 
  libs          (mysql_config) = -L/usr/lib -lmysqlclient -lpthread -lm -lrt -ldl
  mysql_config  (guessed     ) = mysql_config
  nocatchstderr (default     ) = 0
  nofoundrows   (default     ) = 0
  ssl           (guessed     ) = 0
  testdb        (default     ) = test
  testhost      (default     ) = 
  testpassword  (default     ) = 
  testport      (default     ) = 
  testsocket    (default     ) = 
  testuser      (guessed     ) = root

To change these settings, see 'perl Makefile.PL --help' and
'perldoc DBD::mysql::INSTALL'.

Checking if your kit is complete...
Looks good
Using DBI 1.631 (for perl 5.010001 on i386-linux-thread-multi) installed in /usr/local/lib/perl5/auto/DBI/
Generating a Unix-style Makefile
Writing Makefile for DBD::mysql
Writing MYMETA.yml and MYMETA.json
  CAPTTOFU/DBD-mysql-4.027.tar.gz
  /usr/bin/perl Makefile.PL -- OK
Running make for C/CA/CAPTTOFU/DBD-mysql-4.027.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 README.pod blib/lib/DBD/README.pod
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 DBD::mysql ()
chmod 644 mysql.bs
gcc -c  -I/usr/local/lib/perl5/auto/DBI -I/usr/include/mysql -g -fPIC -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FASTMUTEX=1 -DDBD_MYSQL_INSERT_ID_IS_GOOD -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 --param=ssp-buffer-size=4 -m32 -march=i686 -mtune=atom -fasynchronous-unwind-tables   -DVERSION=\"4.027\" -DXS_VERSION=\"4.027\" -fPIC "-I/usr/lib/perl5/CORE"   dbdimp.c
dbdimp.c: In function ‘dbd_discon_all’:
dbdimp.c:2241: warning: unused variable ‘imp_xxh’
dbdimp.c: In function ‘mysql_db_STORE_attrib’:
dbdimp.c:2417: warning: value computed is not used
dbdimp.c: In function ‘mysql_db_FETCH_attrib’:
dbdimp.c:2530: warning: value computed is not used
dbdimp.c:2537: warning: value computed is not used
dbdimp.c: In function ‘mysql_st_prepare’:
dbdimp.c:2660: warning: unused variable ‘limit_flag’
dbdimp.c: In function ‘mysql_st_next_results’:
dbdimp.c:3096: warning: value computed is not used
dbdimp.c:3097: warning: value computed is not used
dbdimp.c:3098: warning: value computed is not used
dbdimp.c:3099: warning: value computed is not used
dbdimp.c:3100: warning: value computed is not used
dbdimp.c:3101: warning: value computed is not used
dbdimp.c:3102: warning: value computed is not used
dbdimp.c:3103: warning: value computed is not used
dbdimp.c:3104: warning: value computed is not used
dbdimp.c:3105: warning: value computed is not used
dbdimp.c:3106: warning: value computed is not used
dbdimp.c:3107: warning: value computed is not used
dbdimp.c:3108: warning: value computed is not used
dbdimp.c:3109: warning: value computed is not used
dbdimp.c:3110: warning: value computed is not used
dbdimp.c:3111: warning: value computed is not used
dbdimp.c:3112: warning: value computed is not used
dbdimp.c:3113: warning: value computed is not used
dbdimp.c: In function ‘mysql_st_FETCH_attrib’:
dbdimp.c:4508: warning: value computed is not used
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/local/lib/perl5/auto/DBI/Driver.xst > mysql.xsi
/usr/bin/perl /usr/share/perl5/ExtUtils/xsubpp  -typemap /usr/share/perl5/ExtUtils/typemap  mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 242
Warning: duplicate function definition 'rows' detected in mysql.xs, line 754
gcc -c  -I/usr/local/lib/perl5/auto/DBI -I/usr/include/mysql -g -fPIC -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DMY_PTHREAD_FASTMUTEX=1 -DDBD_MYSQL_INSERT_ID_IS_GOOD -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 --param=ssp-buffer-size=4 -m32 -march=i686 -mtune=atom -fasynchronous-unwind-tables   -DVERSION=\"4.027\" -DXS_VERSION=\"4.027\" -fPIC "-I/usr/lib/perl5/CORE"   mysql.c
mysql.xs: In function ‘XS_DBD__mysql__db_do’:
mysql.xs:309: warning: value computed is not used
mysql.xs:260: warning: unused variable ‘statement_ptr’
mysql.xs: In function ‘XS_DBD__mysql__st_more_results’:
mysql.xs:691: warning: unused variable ‘retval’
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/lib" /usr/bin/perl myld gcc  -shared -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i686 -mtune=atom -fasynchronous-unwind-tables -L/usr/local/lib dbdimp.o mysql.o  -o blib/arch/auto/DBD/mysql/mysql.so        \
           -L/usr/lib -lmysqlclient -lpthread -lm -lrt -ldl     \
          
chmod 755 blib/arch/auto/DBD/mysql/mysql.so
/usr/bin/perl -MExtUtils::Command::MM -e 'cp_nonempty' -- mysql.bs blib/arch/auto/DBD/mysql/mysql.bs 644
Manifying blib/man3/DBD::README.3pm
Manifying blib/man3/Bundle::DBD::mysql.3pm
Manifying blib/man3/DBD::mysql.3pm
Manifying blib/man3/DBD::mysql::INSTALL.3pm
  CAPTTOFU/DBD-mysql-4.027.tar.gz
  /usr/bin/gmake -- OK
Running make test
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base.t ........................... ok   
t/10connect.t ........................ Bailout called.  Further testing stopped:  ERROR: Access denied for user 'root'@'localhost' (using password: NO)
FAILED--Further testing stopped: ERROR: Access denied for user 'root'@'localhost' (using password: NO)
gmake: *** [test_dynamic] Error 255
  CAPTTOFU/DBD-mysql-4.027.tar.gz
  /usr/bin/gmake test -- NOT OK
//hint// to see the cpan-testers results for installing this module, try:
  reports CAPTTOFU/DBD-mysql-4.027.tar.gz
----------------------------------------------------------
Installation complete. Exiting script...
Please re-run ./mysqlmymonlite.sh again
So I run it again, and it does the exact same thing. :)

Any ideas on how to make it work?
I have the exact same problem. Some help would be very appreciated.

Thanks
 

luigidelgado

Well-Known Member
Nov 6, 2010
119
5
68
Mexico
cPanel Access Level
Root Administrator
Twitter
Having exactly same issue... installed some modules b ut still unable to start the script. I think it comes from the root password in mysql as it says th script is not trying to use it but it does have one.

FAILED--Further testing stopped: ERROR: Access denied for user 'root'@'localhost' (using password: NO)
 

eva2000

Well-Known Member
Aug 14, 2001
339
16
318
Brisbane, Australia
cPanel Access Level
Root Administrator
Twitter
I have the exact same problem. Some help would be very appreciated.

Thanks
Having exactly same issue... installed some modules b ut still unable to start the script. I think it comes from the root password in mysql as it says th script is not trying to use it but it does have one.

FAILED--Further testing stopped: ERROR: Access denied for user 'root'@'localhost' (using password: NO)
it means exactly what it says.. your mysql root password you specified in the mysqlmymonlite.sh script is incorrect

Great Tool !
This will save a lot of time for us.
thank you very much !
You're welcome :D
 

Hedloff

Well-Known Member
Jun 7, 2004
151
7
168
Up north!
cPanel Access Level
DataCenter Provider
Is mysqlmymonlite.sh working fine on MySQL 5.6?

I also got error trying: ./mysqlmymonlite.sh mysqltuner
[!!] The --forcemem option is required for remote connections

Any idea how to fix that?