Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysqlmymonlite.sh server stats gathering tool for cPanel Server

Discussion in 'Workarounds and Optimization' started by eva2000, Apr 5, 2012.

Tags:
  1. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    330
    Likes Received:
    13
    Trophy Points:
    318
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    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 :)
     
  2. jette

    jette Registered

    Joined:
    May 24, 2013
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    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
     
  3. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    330
    Likes Received:
    13
    Trophy Points:
    318
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    Add the line as is.

    How are you adding the cron job ? via cpanel ? via ssh telnet and crontab -e command ?
     
  4. PPNSteve

    PPNSteve Well-Known Member

    Joined:
    Mar 13, 2003
    Messages:
    399
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    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 <major@mhtx.net>
     >>  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
    ----------------------------
    
     
  5. xman888

    xman888 Well-Known Member

    Joined:
    Nov 23, 2005
    Messages:
    58
    Likes Received:
    1
    Trophy Points:
    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"
     
  6. xman888

    xman888 Well-Known Member

    Joined:
    Nov 23, 2005
    Messages:
    58
    Likes Received:
    1
    Trophy Points:
    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
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
  8. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    330
    Likes Received:
    13
    Trophy Points:
    318
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    If you have MySQL on separate remote server other than 'localhost' i.e. with remote ip address of hostname, run mysqlmymonlite.sh on the MySQL server and set MYSQLSERVERONLY='y'.
     
  9. xman888

    xman888 Well-Known Member

    Joined:
    Nov 23, 2005
    Messages:
    58
    Likes Received:
    1
    Trophy Points:
    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
     
  10. Bashed

    Bashed Well-Known Member

    Joined:
    Dec 18, 2013
    Messages:
    100
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Strange

    root@server7 [~/centos_whm]# ./mysqlmymonlite.sh mysqltuner
    -bash: ./mysqlmymonlite.sh: Permission denied

    - - - Updated - - -

    Nevermind forgot to chmod +x the file
     
  11. Palsman

    Palsman Member

    Joined:
    Apr 23, 2013
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Linux Server
    cPanel Access Level:
    Root Administrator
    Why Cpanel not put this as 3rd party tools in cpanel.
    We hope that cpanel develop this tool.

    Regards,
     
  12. cPanelJared

    cPanelJared Technical Analyst
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,840
    Likes Received:
    20
    Trophy Points:
    143
    Location:
    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.
     
  13. beninfl

    beninfl Member

    Joined:
    May 23, 2014
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    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?
     
  14. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    85
    Likes Received:
    3
    Trophy Points:
    158
    cPanel Access Level:
    Root Administrator
    this script makes me smile!
     
  15. david.cocos

    david.cocos Member

    Joined:
    May 19, 2014
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I have the exact same problem. Some help would be very appreciated.

    Thanks
     
  16. T-Master

    T-Master Registered

    Joined:
    Jul 12, 2014
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Great Tool !
    This will save a lot of time for us.
    thank you very much !
     
  17. luigidelgado

    luigidelgado Well-Known Member

    Joined:
    Nov 6, 2010
    Messages:
    117
    Likes Received:
    5
    Trophy Points:
    68
    Location:
    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)
     
  18. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    330
    Likes Received:
    13
    Trophy Points:
    318
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    it means exactly what it says.. your mysql root password you specified in the mysqlmymonlite.sh script is incorrect

    You're welcome :D
     
  19. Hedloff

    Hedloff Well-Known Member

    Joined:
    Jun 7, 2004
    Messages:
    112
    Likes Received:
    3
    Trophy Points:
    168
    Location:
    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?
     
  20. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    330
    Likes Received:
    13
    Trophy Points:
    318
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    yeah some folks reported that but i haven't experienced it myself.. usually that message should only be prompted when you mysql server is connecting from remote mysql server or when not localhost
     
Loading...

Share This Page