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.

Mysql 5.x Upgrade - version `libmysqlclient_15' not found

Discussion in 'General Discussion' started by teckyhead, Mar 3, 2008.

  1. teckyhead

    teckyhead Member

    Joined:
    Jan 2, 2007
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    I've done a few mysql 4.x -> 5.x upgrades and never had a problem.

    I know about the issues that can happen if you don't run the easyapache and perl update script afterwards, but this time the problem is a little different. The mysql server (5.0.45) is running fine but it appears that the client programs haven't been updated or there is some mismatch between them and the shared libraries. Here is the output of a few programs in order to provide some info...


    ===========================================
    # cat /etc/redhat-release
    CentOS release 4.6 (Final)

    # yum info MySQL-devel
    Installed Packages
    Name : MySQL-devel
    Arch : x86_64
    Version: 5.0.45
    Release: 0.glibc23
    Size : 24 M
    Repo : installed
    Summary: MySQL - Development header files and libraries

    # yum info MySQL-client
    Name : MySQL-client
    Arch : x86_64
    Version: 5.0.45
    Release: 0.glibc23
    Size : 791 k
    Repo : installed
    Summary: MySQL - Client

    # /scripts/mysqlup
    MySQL Setup Script Version 7.0
    Loaded cPPkgs::MySQL ok!
    This is the cPPkgs::MySQL 5.0.45 installer for Linux.
    MySQL 5.0.45 is up to date
    Install Complete
    ===========================================

    WHM is WHM 11.15.0 cPanel 11.18.1-R20683

    So, yum and WHM are telling me Mysql is v5.0.45 and all up to date. However, when I run a client program such as mysqladmin I see this:

    # mysqladmin
    mysqladmin: /usr/lib64/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by mysqladmin)

    The _15 libs are there. Here's the file listing from /usr/lib64

    ==================================
    # ls -al /usr/lib64/libmy*
    lrwxrwxrwx 1 root root 26 Mar 2 06:09 /usr/lib64/libmysqlclient_r.so -> libmysqlclient_r.so.15.0.0
    lrwxrwxrwx 1 root root 26 Mar 2 06:09 /usr/lib64/libmysqlclient_r.so.15 -> libmysqlclient_r.so.15.0.0
    -rwxr-xr-x 1 root root 2599067 Jul 17 2007 /usr/lib64/libmysqlclient_r.so.15.0.0
    lrwxrwxrwx 1 root root 24 Mar 2 06:09 /usr/lib64/libmysqlclient.so -> libmysqlclient.so.15.0.0
    lrwxrwxrwx 1 root root 20 Mar 2 05:55 /usr/lib64/libmysqlclient.so.14 -> libmysqlclient.so.15
    lrwxrwxrwx 1 root root 24 Mar 2 06:09 /usr/lib64/libmysqlclient.so.15 -> libmysqlclient.so.15.0.0
    -rwxr-xr-x 1 root root 1343616 Sep 26 2006 /usr/lib64/libmysqlclient.so.15.0.0
    ==================================


    PHP seems to have compiled fine ... I can get into phpMyAdmin without a problem. It seems that it's just those pesky Mysql client utilities that have a problem.

    Gary
     
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    What does

    Code:
    which mysqladmin
    
    show?
     
  3. teckyhead

    teckyhead Member

    Joined:
    Jan 2, 2007
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    [root@194 ~]# which mysql
    /usr/bin/mysql


    [root@194 ~]# which mysqladmin
    /usr/bin/mysqladmin


    Regards,

    Gary
     
  4. viraj

    viraj Well-Known Member

    Joined:
    Sep 28, 2006
    Messages:
    209
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Try running the following from SSH as root :
    /scripts/mysqlup --force
    Hope that fixes the issue...
     
  5. teckyhead

    teckyhead Member

    Joined:
    Jan 2, 2007
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Yep...already tried that. It says that MySQL is up to date. That's correct too...the mysql server and PHP are working fine. It's just the client binaries that aren't working.

    Gary
     
  6. viraj

    viraj Well-Known Member

    Joined:
    Sep 28, 2006
    Messages:
    209
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Can you try reinstalling the RPMs for those binaries ?
     
  7. parvaz1355

    parvaz1355 Registered

    Joined:
    Jan 25, 2005
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    where run scripts/mysqlup --force
    get err:

    This is the cPPkgs::MySQL 5.0.45 installer for Linux.
    Fetching http://httpupdate.cpanel.net/mysqlinstall/5.0.45-0/centos/5/MySQL-shared-5.0.45-0.glibc23.i386.rpm (0)....@216.144.237.225......connected......receiving...1%...2
    %...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%..
    .32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...6
    0%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%
    ...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
    error: failed to stat (deleted) /var/tmp: No such file or directory
    Preparing... ##################################################
    MySQL-shared ##################################################
    Fetching http://httpupdate.cpanel.net/mysqlinstall/5.0.45-0/centos/5/MySQL-server-5.0.45-0.glibc23.i386.rpm (0)....@216.144.237.225......connected......receiving...1%...2
    %...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%..
    .32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...6
    0%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%
    ...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
    error: failed to stat (deleted) /var/tmp: No such file or directory
    Preparing... ##################################################
    error: install: %pre scriptlet failed (2), skipping MySQL-server-5.0.45-0.glibc23
    Fetching http://httpupdate.cpanel.net/mysqlinstall/5.0.45-0/centos/5/MySQL-shared-5.0.45-0.glibc23.i386.rpm (0)....@216.144.237.225......connected......receiving...1%...2
    %...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%..
    .32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...6
    0%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%
    ...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
    error: failed to stat (deleted) /var/tmp: No such file or directory
    Preparing... ##################################################
    MySQL-shared ##################################################
    This script updates all the mysql privilege tables to be usable by
    MySQL 4.0 and above.



    howt o fix it?
     
  8. WebScHoLaR

    WebScHoLaR Well-Known Member

    Joined:
    Dec 14, 2005
    Messages:
    511
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    Planet Earth
    Please provide the output of these two commands:

    mount
    df -h
     
  9. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    It looks like something deleted /var/tmp, but because files therein are still held by other applications (e.g. courier-authlib) the directory still appears available. Check the output of:

    lsof /var/tmp

    and shutdown services that own files therein. Once that is done try mysqlup again.
     
Loading...

Share This Page