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.

mtop on CentOS

Discussion in 'Database Discussions' started by LeadDogGraphics, Mar 10, 2012.

  1. LeadDogGraphics

    LeadDogGraphics Well-Known Member

    Joined:
    Feb 25, 2012
    Messages:
    97
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    West Palm Beach, FL
    cPanel Access Level:
    Root Administrator
    I have cPanel 11.32 with MySQL 5.5.21 installed.

    In efforts to track my live database queries, I came across this page:
    How To: Install mtop on CentOS

    It gave instructions on installing mtop, I have found all the latest dependencies and resolved them as well as installed the mtop with success but was unable to get it to run. I get the following errors:

    Can't load '/usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.18: cannot open shared object file: No such file or directory at /usr/local/lib/perl5/5.8.8/x86_64-linux/XSLoader.pm line 70.
    at /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/DBD/mysql.pm line 15
    Compilation failed in require at /usr/bin/mtop line 412.
    BEGIN failed--compilation aborted at /usr/bin/mtop line 412.




    Has anyone succeeded with MySQL 5.5? Or any suggestions on alternatives?
     
  2. Eric

    Eric Administrator
    Staff Member

    Joined:
    Nov 25, 2007
    Messages:
    746
    Likes Received:
    11
    Trophy Points:
    18
    Location:
    Texas
    cPanel Access Level:
    Root Administrator
    Howdy,

    Do you have libmysqlclient.so.18 on the system? (Or any other versions?)

    You might be able to find the library with
    Code:
     locate libmysqlclient 
    it should be in /usr/lib or /usr/lib64.

    If you can't find the file you might run an RPM verify on the MySQL client rpm that cPanel provides. You might be missing a file.

    Code:
     rpm -V MySQL-shared-5.5.21-1.cp.1132.x86_64
    Thanks!
     
    #2 Eric, Mar 14, 2012
    Last edited: Mar 14, 2012
  3. LeadDogGraphics

    LeadDogGraphics Well-Known Member

    Joined:
    Feb 25, 2012
    Messages:
    97
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    West Palm Beach, FL
    cPanel Access Level:
    Root Administrator
    Hey Eric,

    Thanks for the info, I ran the first search and came up with this:
    Code:
     locate libmysqlclient
    /usr/lib64/libmysqlclient.so
    /usr/lib64/libmysqlclient.so.12
    /usr/lib64/libmysqlclient.so.12.0.0
    /usr/lib64/libmysqlclient.so.14
    /usr/lib64/libmysqlclient.so.14.0.0
    /usr/lib64/libmysqlclient.so.15
    /usr/lib64/libmysqlclient.so.15.0.0
    /usr/lib64/libmysqlclient.so.16
    /usr/lib64/libmysqlclient.so.16.0.0
    /usr/lib64/libmysqlclient_r.so.12
    /usr/lib64/libmysqlclient_r.so.12.0.0
    /usr/lib64/libmysqlclient_r.so.14
    /usr/lib64/libmysqlclient_r.so.14.0.0
    /usr/lib64/libmysqlclient_r.so.15
    /usr/lib64/libmysqlclient_r.so.15.0.0
    /usr/lib64/libmysqlclient_r.so.16
    /usr/lib64/libmysqlclient_r.so.16.0.0
    /usr/lib64/mysql/libmysqlclient.a
    /usr/lib64/mysql/libmysqlclient.so
    /usr/lib64/mysql/libmysqlclient_r.a
    /usr/lib64/mysql/libmysqlclient_r.so
    /usr/local/cpanel/lib/libmysqlclient.so.14
    /usr/local/cpanel/lib64/libmysqlclient.so.14
    /var/cache/yum/webtatic/packages/libmysqlclient15-5.0.77-1.1.w5.x86_64.rpm
    
    Then I ran the second line you gave and got this response:
    package MySQL-shared-5.5.21-1.cp.1132.x86_64 is not installed

    I know when i installed the MySQL-shared-compatability... it jacked things up, I submitted a cPanel ticket for help and one of your awesome gurus helped me out by recreating a symlink and that got things working again but using the version 16 of libmysqlclient. So yes I am missing version 18 that I should have, and do remember seeing before my failed attempt at installing mtop.

    So my question is how to fix the mysql install? Should i use easy apache and force a rebuild? or is there a script that I can run to look for missing files? Please advise so I don't jack something up again.
     
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    What does the following show when you run it or does it report the same error?

    Code:
    /usr/bin/perl -MDBD::mysql -we 'print $DBD::mysql::VERSION;'
     
  5. LeadDogGraphics

    LeadDogGraphics Well-Known Member

    Joined:
    Feb 25, 2012
    Messages:
    97
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    West Palm Beach, FL
    cPanel Access Level:
    Root Administrator
    4.020

    10chars
     
  6. gbh

    gbh Active Member

    Joined:
    Sep 17, 2004
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Sydney
    cPanel Access Level:
    Root Administrator
    Did you end up solving this? I have the exact same issue
     
  7. LeadDogGraphics

    LeadDogGraphics Well-Known Member

    Joined:
    Feb 25, 2012
    Messages:
    97
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    West Palm Beach, FL
    cPanel Access Level:
    Root Administrator
    No i did not. I would like to though.
     
  8. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    The biggest issue I'm seeing with mtop and mytop is that both are older. Have you considered innotop, which actually works to install from source?

    Code:
    cd /root
    wget http://innotop.googlecode.com/files/innotop-1.9.0.tar.gz
    tar xzf innotop-1.9.0.tar.gz 
    cd innotop-1.9.0
    perl Makefile.PL
    make install
    innotop
    Thanks!
     
  9. lbeachmike

    lbeachmike Well-Known Member

    Joined:
    Dec 27, 2001
    Messages:
    313
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Long Beach, NY
    cPanel Access Level:
    Root Administrator
    Hi there -

    Was this ever figured out?

    I'm having what appears to be a similar issue to the above which is causing trouble for a user's DADA installation, and it appears that it is simply not finding the binary it's looking for in the correct path.

    When I do a locate on libmysqlclient.so.16, it appears that it is not in the path that DADA is looking for it to be -

    Code:
    root@<removed> [/etc]# locate libmysqlclient
    /usr/lib64/libmysqlclient.so
    /usr/lib64/libmysqlclient.so.18
    /usr/lib64/libmysqlclient.so.18.0.0
    /usr/lib64/libmysqlclient_r.so
    /usr/lib64/libmysqlclient_r.so.18
    /usr/lib64/libmysqlclient_r.so.18.0.0
    /usr/lib64/mysql/libmysqlclient.a
    /usr/lib64/mysql/libmysqlclient.so
    /usr/lib64/mysql/libmysqlclient_r.a
    /usr/lib64/mysql/libmysqlclient_r.so
    /usr/local/cpanel/3rdparty/lib64/mysql/libmysqlclient.so.15
    /usr/local/cpanel/3rdparty/lib64/mysql/libmysqlclient.so.15.0.0
    /usr/local/cpanel/3rdparty/lib64/mysql/libmysqlclient_r.so.15
    /usr/local/cpanel/3rdparty/lib64/mysql/libmysqlclient_r.so.15.0.0
    /usr/local/cpanel/lib64/libmysqlclient.so.16
    Did this path change when I upgraded from MySQL 5.1 to 5.5 or when cpanel changed to RPM-based packages?

    Is this just a matter of changing the config on the user's DADA installation?

    Thanks.

    Mike
     
  10. lbeachmike

    lbeachmike Well-Known Member

    Joined:
    Dec 27, 2001
    Messages:
    313
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Long Beach, NY
    cPanel Access Level:
    Root Administrator
    This issue was fixed via the following steps to force a reinstall of the below two Perl modules -

    Code:
    perl -MCPAN -e shell
     
    Once you do that you need to run the following commands within that shell.
     
    force install DBI
    force install DBD::mysql
    Thanks to the exceptional support team help at NDC Host for figuring out the solution after it was noticed that this also caused a problem for their Watch MySQL plug-in to start-up properly.

    It appears these issues were introduced upon upgrading from MySQL 5.1 to 5.5. If that is the case, cPanel might like to take a look at this and consider revising their upgrade scripts to include such needed module reinstalls.
     
  11. LeadDogGraphics

    LeadDogGraphics Well-Known Member

    Joined:
    Feb 25, 2012
    Messages:
    97
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    West Palm Beach, FL
    cPanel Access Level:
    Root Administrator
    Thanks for the tip Mike, glad you could help with this. I had just dropped the issue since I could not find an answer on here or anywhere else online. I spent quite a bit of time on Google and couldn't come up with anything.
     
  12. lbeachmike

    lbeachmike Well-Known Member

    Joined:
    Dec 27, 2001
    Messages:
    313
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Long Beach, NY
    cPanel Access Level:
    Root Administrator
    I had come up pretty empty in my googling efforts as well. Did it resolve your issue with getting mtop installed as well? I've wanted to install that for some time now but haven't gotten to it just yet.
     
  13. LeadDogGraphics

    LeadDogGraphics Well-Known Member

    Joined:
    Feb 25, 2012
    Messages:
    97
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    West Palm Beach, FL
    cPanel Access Level:
    Root Administrator
    Haven't tried yet, just saw your post a little while ago while i was catching up on news and emails. I'll try it over the weekend.
     
  14. lbeachmike

    lbeachmike Well-Known Member

    Joined:
    Dec 27, 2001
    Messages:
    313
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Long Beach, NY
    cPanel Access Level:
    Root Administrator
    Hey LeadDog - Curious if this resolved your issue and if you were subsequently able to get mtop running.

    Thanks.

    Mike
     
  15. rinogo

    rinogo Member

    Joined:
    Dec 6, 2007
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Mike (lbeachmike), it worked for me! Thanks so much! :)
     
  16. lbeachmike

    lbeachmike Well-Known Member

    Joined:
    Dec 27, 2001
    Messages:
    313
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Long Beach, NY
    cPanel Access Level:
    Root Administrator
    Great! Fixing the Perl modules, or were you actually able to get mtop installed?
     
  17. rpkemp

    rpkemp Registered

    Joined:
    Apr 12, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Just wanted to add my thanks to lbeachmike for pointing out this fix - I was puzzling over this for ages before I found your solution
     
Loading...

Share This Page