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!

mysqlmymonlite.sh server stats gathering tool for cPanel Server

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

Tags:
  1. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    70
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Tbilisi
    cPanel Access Level:
    Root Administrator
    user/pass is ok, all others mysqlmymonlite switch working fine.
    Just i have problem with ./mysqlmymonlite.sh mysqltuner
    Im confused!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    70
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Tbilisi
    cPanel Access Level:
    Root Administrator
    Problem resolved after firewall disabled! so strange and why?!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    70
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Tbilisi
    cPanel Access Level:
    Root Administrator
    I think mysqltuner will be download on server after "./mysqlmymonlite.sh mysqltuner"
    Its not good idea for local and intranet servers.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    338
    Likes Received:
    15
    Trophy Points:
    318
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    ah i see so you on an intranet ! explains the problem.
     
    lambov likes this.
  5. Binay Kumar

    Binay Kumar Registered

    Joined:
    Aug 25, 2016
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Any one who help me about the above issue.
     
  6. Anthony Parsons

    Anthony Parsons Active Member

    Joined:
    Aug 4, 2016
    Messages:
    26
    Likes Received:
    3
    Trophy Points:
    8
    Location:
    Australia
    cPanel Access Level:
    Root Administrator
    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)
    
     
    #66 Anthony Parsons, Sep 8, 2016
    Last edited by a moderator: Sep 8, 2016
  7. Inigo Montoya

    Inigo Montoya Registered

    Joined:
    May 16, 2018
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    USA
    cPanel Access Level:
    Root Administrator
    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?
     
  8. ronaldst

    ronaldst Well-Known Member

    Joined:
    Feb 22, 2016
    Messages:
    78
    Likes Received:
    11
    Trophy Points:
    8
    Location:
    Norway
    cPanel Access Level:
    Root Administrator
    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?
     
  9. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    338
    Likes Received:
    15
    Trophy Points:
    318
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    haven't tested with Engintron nginx so definitely not compatible

    will have to check myself as it has been a while and alot of cpanel updates have occurred

    are you using centos 6 or 7 ?
     
    #69 eva2000, Sep 18, 2018
    Last edited: Sep 18, 2018
  10. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    338
    Likes Received:
    15
    Trophy Points:
    318
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    if you run this first
    Code:
    perl -MCPAN -e 'install Devel::CheckLib'
    
    then re-run mysqlmymonlite.sh does it help ?
     
  11. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    338
    Likes Received:
    15
    Trophy Points:
    318
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    know a bit late but what's output for these 2 commands
    Code:
    which nginx
    nginx -t
    
     
    Infopro likes this.
  12. ronaldst

    ronaldst Well-Known Member

    Joined:
    Feb 22, 2016
    Messages:
    78
    Likes Received:
    11
    Trophy Points:
    8
    Location:
    Norway
    cPanel Access Level:
    Root Administrator
    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.
     
  13. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,272
    Likes Received:
    2,154
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @ronaldst,

    You could try using a different tuning script such as the one at:

    major/MySQLTuner-perl

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    ronaldst likes this.
  14. ronaldst

    ronaldst Well-Known Member

    Joined:
    Feb 22, 2016
    Messages:
    78
    Likes Received:
    11
    Trophy Points:
    8
    Location:
    Norway
    cPanel Access Level:
    Root Administrator
    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.
     
  15. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    338
    Likes Received:
    15
    Trophy Points:
    318
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    @ronaldst Unfortunately, i can't reproduce this issue on my existing cpanel/whm server and don't have access to any other cpanel/whm licenses to be able to test this on a fresh centos 7 install.

    are you just running mysqlmymonlite.sh without any options ? or running specific flag i.e.

    mysqlmymonlite.sh mysqlreport command

    Code:
    ./mysqlmymonlite.sh mysqlreport              
    
    -------------------------------------------------------------
    System MySQL monitoring stats
    mysqlmymonlite.sh - 0.5.7 WHM mysqlmymon.com
    compiled by George Liu (eva2000) centminmod.com
    -------------------------------------------------------------
    
    Report Generated:
    Mon Oct 29 01:53:17 UTC 2018
    
    ----------------------------
    mysqlreport output
    ----------------------------
    
    MariaDB 10.1.35-MariaDB     uptime 82 2:45:3    Mon Oct 29 01:53:17 2018
    
    __ Key _________________________________________________________________
    Buffer used    33.48M of    1.17G   %Used:   2.79
      Current     249.80M              %Usage:  20.82
    Write hit       1.71%
    Read hit      100.00%
    
    __ Questions ___________________________________________________________
    Total           4.37G     616.6/s
      -Unknown     14.39G      2.0k/s  %Total: 328.94
      Com_         11.21G      1.6k/s          256.12
      DMS           3.91G     551.6/s           89.46
      QC Hits       3.53G     497.4/s           80.66
      COM_QUIT    118.23M      16.7/s            2.70
    Slow 1 s            0         0/s            0.00  %DMS:   0.00 Log:
    DMS             3.91G     551.6/s           89.46
      SELECT        3.78G     532.6/s           86.38         96.56
      INSERT      114.18M      16.1/s            2.61          2.92
      UPDATE       17.87M       2.5/s            0.41          0.46
      DELETE        2.61M       0.4/s            0.06          0.07
      REPLACE           6       0.0/s            0.00          0.00
    Com_           11.21G      1.6k/s          256.12
      stmt_prepar   3.58G     504.5/s           81.81
      stmt_execut   3.58G     504.5/s           81.81
      stmt_close    3.52G     496.0/s           80.43
    
    __ Rows ________________________________________________________________
    Rows            1.68T    237.1k/s
      Using idx   497.16G     70.1k/s  %Index:  29.56
    Rows/question  384.43
    
    __ SELECT and Sort _____________________________________________________
    Scan           35.92M       5.1/s %SELECT:   0.95
    Range          45.48M       6.4/s            1.20
    Full join       5.24k       0.0/s            0.00
    Range check       543       0.0/s            0.00
    Full rng join   5.87k       0.0/s            0.00
    Sort scan      12.93M       1.8/s
    Sort range     34.66M       4.9/s
    Sort mrg pass  21.32k       0.0/s
    
    __ Query Cache _________________________________________________________
    Memory usage  202.38M of  256.00M  %Usage:  79.05
    Block Fragmnt  16.59%
    Hits            3.53G     497.4/s
    Inserts       209.76M      29.6/s
    Insrt:Prune   50.66:1      29.0/s
    Hit:Insert    16.82:1
    
    __ Table Locks _________________________________________________________
    Waited          2.24M       0.3/s  %Total:   0.30
    Immediate     734.47M     103.5/s
    
    __ Tables ______________________________________________________________
    Open             2766 of  10000    %Cache:  27.66
    Opened         16.57k       0.0/s
    
    __ Connections _________________________________________________________
    Max used           99 of   1000      %Max:   9.90
    Total         118.24M      16.7/s
    
    __ Created Temp ________________________________________________________
    Disk table      1.44M       0.2/s   %Disk:   5.74
    Table          25.09M       3.5/s    Size:   2.0G
    File           41.20k       0.0/s
    
    __ Threads _____________________________________________________________
    Running             7 of     17
    Created            99       0.0/s
    Slow                0         0/s
    Cached             82 of   1000      %Hit:    100
    
    __ Aborted _____________________________________________________________
    Clients        31.05k       0.0/s
    Connects        1.13k       0.0/s
    
    __ Bytes _______________________________________________________________
    Sent           70.74T     10.0M/s
    Received        1.03T    145.1k/s
    
    __ InnoDB Buffer Pool __________________________________________________
    Usage          15.75G of   16.00G  %Usage:  98.44
    Read hit      100.00%
    Pages
      Free         16.39k              %Total:   1.56
      Data          1.01M                       96.03  %Drty:   3.70
      Misc          25278                        2.41
      Latched           0                        0.00
    Reads           1.71T    240.7k/s
      From disk    30.62M       4.3/s   %Disk:   0.00
      Ahead Rnd         0         0/s
    Writes          1.05G     147.5/s
    Wait Free        7589       0.0/s   %Wait:   0.00
    Flushes        83.81M      11.8/s
      LRU               0         0/s  %Flush:   0.00
    
    __ InnoDB Lock _________________________________________________________
    Waits          503117       0.1/s
    Current             4
    Time acquiring
      Total     356867821 ms
      Average         709 ms
      Max           43715 ms
    Trx history      6.00M
    
    __ InnoDB Data, Pages, Rows ____________________________________________
    Data
      Reads        45.82M       6.5/s
      Writes      143.75M      20.3/s
      fsync        21.77M       3.1/s
      Pending
        Reads           0
        Writes          0
        fsync           0
    
    Pages
      Created       4.92M       0.7/s
      Read         45.82M       6.5/s
      Written      83.81M      11.8/s
    
    Rows
      Deleted      18.74M       2.6/s
      Inserted     22.05M       3.1/s
      Read          1.33T    187.0k/s
      Updated      76.49M      10.8/s
    
    __ Aria Pagecache ______________________________________________________
    Buffer used    68.84M of    1.00G   %Used:   6.72
      Current      42.30M              %Usage:   4.13
    Write hit      99.47%
    Read hit       85.81%
    
    __ Subquery Cache ______________________________________________________
    Hit ratio      12.55%
    Hits            6.45M      0.9/s
    Miss           44.97M      6.3/s
    
    Report Complete:
    Mon Oct 29 01:53:17 UTC 2018
    ----------------------------
    
    
    might be DBD-mysql issue token ""mariadb-10.1"" is not valid in preprocessor expressions · Issue #262 · perl5-dbi/DBD-mysql

    issue apparently fixed in DBD-mysql 4.0.49

    tried installing perl DBD-mysql from whm logged in modules installer ?
     
    #75 eva2000, Oct 28, 2018
    Last edited: Oct 28, 2018
  16. ronaldst

    ronaldst Well-Known Member

    Joined:
    Feb 22, 2016
    Messages:
    78
    Likes Received:
    11
    Trophy Points:
    8
    Location:
    Norway
    cPanel Access Level:
    Root Administrator
    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.
     
    #76 ronaldst, Oct 29, 2018
    Last edited: Oct 29, 2018
  17. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    338
    Likes Received:
    15
    Trophy Points:
    318
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    Yes it is required and usually does work for my cpanel installs and that of of my clients.
     
  18. ronaldst

    ronaldst Well-Known Member

    Joined:
    Feb 22, 2016
    Messages:
    78
    Likes Received:
    11
    Trophy Points:
    8
    Location:
    Norway
    cPanel Access Level:
    Root Administrator
    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.
     
  19. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    338
    Likes Received:
    15
    Trophy Points:
    318
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    could be DBD-mysql 4.0.48 doesn't support MariaDB 10.2 as yet compilation erro when using with MariaDB 10.2 · Issue #250 · perl5-dbi/DBD-mysql

    seems there's a commit fix in master branch which is for DBD-mysql 4.0.49 planned release Fix compiling against MariaDB · perl5-dbi/DBD-mysql@cf752cd
     
    #79 eva2000, Nov 10, 2018
    Last edited: Nov 10, 2018
  20. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    338
    Likes Received:
    15
    Trophy Points:
    318
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    @ronaldst I tested the DBD-mysql master branch commit patch for fixing MariaDB 10.2+ compatibility and it works for compilation at least on non-cpanel CentOS 7.5 server at dbd-mysql for mariadb 10.2+ but whether that is only fix needed not sure. As you're testing on test VPS maybe worth trying to see if that works for you.

    Test was done on MariaDB 10.3 based non-cpanel server
    Code:
    mysqladmin ver
    mysqladmin  Ver 9.1 Distrib 10.3.10-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.3.10-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 14 days 12 hours 10 min 16 sec
    
    Threads: 7  Questions: 2380407  Slow queries: 0  Opens: 267  Flush tables: 1  Open tables: 222  Queries per second avg: 1.899
    
     
    #80 eva2000, Nov 10, 2018
    Last edited: Nov 10, 2018
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice