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!

issue with percona

Discussion in 'Database Discussion' started by anand, Mar 11, 2014.

  1. anand

    anand Well-Known Member

    Joined:
    Nov 11, 2002
    Messages:
    1,435
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    Ref: How to replace MySQL with Percona in 11.36 | cPanel Blog

    Until recently this was working on a server for me, however with the latest update, it seems to be broken. Now when i execute a php script, it gives me the below error.

    Code:
    php: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory
    I have recompiled apache using easyapache already twice, but it doesn't seem to fix the issue. Any ideas ?

    Thanks
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 anand, Mar 11, 2014
  2. ga2host

    ga2host Registered
    PartnerNOC

    Joined:
    Dec 19, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    We are also having this problem it has been temporarily resolved by creating a symlink to the .16 library

    cd /usr/lib64/
    ln -s libmysqlclient.so.16 libmysqlclient.so.18

    However easyapache is now failing with this:

    checking for mysql_close in -lmysqlclient... no
    checking for mysql_error in -lmysqlclient... no

    Percona rpms installed:

    rpm -qa |grep PerconaPercona-Server-shared-compat-5.5.35-rel33.0.611.rhel5
    Percona-Server-shared-56-5.6.16-rel64.0.el5
    Percona-Server-client-56-5.6.16-rel64.0.el5
    Percona-Server-devel-56-5.6.16-rel64.0.el5
    Percona-Server-server-56-5.6.16-rel64.0.el5
     
    #2 ga2host, Mar 12, 2014
    Last edited: Mar 12, 2014
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,617
    Likes Received:
    1,787
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    This is due to the change documented by Percona here:

    Percona Server 5.6.16-64.0 is now available - MySQL Performance Blog

    Here is a snippet:

    A workaround to this issue would be to create a symbolic link:

    Code:
    ln -s /usr/lib64/libperconaserverclient.so /usr/lib64/libmysqlclient.so
    Then, run EasyApache to rebuild the PHP binaries. Note that Percona is not officially supported by cPanel so issues like this can arise from time to time when using software that cPanel does not test against.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 cPanelMichael, Mar 12, 2014
  4. ga2host

    ga2host Registered
    PartnerNOC

    Joined:
    Dec 19, 2007
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    Michael,

    Thanks for the reply! For some reason in my digging I couldn't find it.

    I will test this later and report back.
     
    #4 ga2host, Mar 12, 2014
  5. anand

    anand Well-Known Member

    Joined:
    Nov 11, 2002
    Messages:
    1,435
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    Thanks for the pointer. Testing this now.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 anand, Mar 12, 2014
  6. anand

    anand Well-Known Member

    Joined:
    Nov 11, 2002
    Messages:
    1,435
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    Issue fixed, thanks a lot.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 anand, Mar 12, 2014
  7. DaVinciDigital

    DaVinciDigital Registered

    Joined:
    Jun 25, 2013
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Ahem ;)

    Ticket 4645179

    Well, this workaround is not clean and doesn't help matters. Following Percona's indications, we should use the original MySQL libraries. To do so we can install MySQL56-shared-5.6.16-3.cp1142.rpm

    Problem is that upcp believes that we don't need the package above and as suck it would uninstall it everytime it is run.

    Can we instruct upcp to keep the above mentioned package? In this was we can keep the system clean and ready for upgrades once that cPanel would support Percona officially.
     
    #7 DaVinciDigital, Mar 12, 2014
  8. DaVinciDigital

    DaVinciDigital Registered

    Joined:
    Jun 25, 2013
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Ok, I got a solution, thanks to some pointers from Richard. I'll update tomorrow (gotta do some more testing first).
     
    #8 DaVinciDigital, Mar 12, 2014
  9. LeadDogGraphics

    LeadDogGraphics Well-Known Member

    Joined:
    Feb 25, 2012
    Messages:
    97
    Likes Received:
    1
    Trophy Points:
    58
    Location:
    West Palm Beach, FL
    cPanel Access Level:
    Root Administrator
    Although cPanel, really should look into offer Percona as an option for database. It is a very popular choice and a damn fine database engine.

    Thank you for the above code, is there a way as mentioned above to make the link permanent, or will this continue to work through updates?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #9 LeadDogGraphics, Mar 16, 2014
  10. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,617
    Likes Received:
    1,787
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #10 cPanelMichael, Mar 18, 2014
  11. GOT

    GOT Get Proactive!

    Joined:
    Apr 8, 2003
    Messages:
    902
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Norfolk, VA
    cPanel Access Level:
    DataCenter Provider
    FWIW, I fixed this by installing Percona-Server-shared-compat. Weirdly, its version 5.1 and the server version is 5.5, but its well into the php compile at this point, so it looks like its working.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #11 GOT, Apr 26, 2014
  12. egillette

    egillette Well-Known Member

    Joined:
    Jan 5, 2010
    Messages:
    68
    Likes Received:
    0
    Trophy Points:
    56
    Location:
    Orlando, FL
    cPanel Access Level:
    DataCenter Provider
    The symbolic link thing worked for me too.

    In my case this problem was that libperconaserverclient.so didn't exist.

    So I symlinked it to libperconaserverclient.so.18 as shown below:

    Code:
    root@rebuild [/usr/lib64]# ls -lah /usr/lib64/libperconaserverclient.so
lrwxrwxrwx. 1 root root 39 Jul 28 16:29 /usr/lib64/libperconaserverclient.so -> /usr/lib64/libperconaserverclient.so.18*
root@rebuild [/usr/lib64]#
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #12 egillette, Jul 28, 2014
    Last edited: Jul 28, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - issue percona
  1. angelleye

    New Thread Setting up Google Drive Backup Issues

    angelleye, Jun 17, 2018 at 7:32 PM, in forum: Data Protection
    Replies:
    0
    Views:
    1
    angelleye
    Jun 17, 2018 at 7:32 PM
  2. joshuapinedamexico

    New Thread IP has changed login issue

    joshuapinedamexico, Jun 16, 2018 at 8:13 PM, in forum: Security
    Replies:
    0
    Views:
    42
    joshuapinedamexico
    Jun 16, 2018 at 8:13 PM
  3. Charlie Young

    Disk Issues

    Charlie Young, Jun 14, 2018 at 6:26 PM, in forum: General Discussion
    Replies:
    2
    Views:
    79
    cPanelMichael
    Jun 15, 2018 at 12:11 PM
  4. andresaltamirano

    Issue with Mailman

    andresaltamirano, Jun 13, 2018 at 7:40 AM, in forum: Discusión en Español
    Replies:
    1
    Views:
    43
    cPanelLauren
    Jun 13, 2018 at 9:22 AM
  5. mehdix92

    Exim Configuration Issue

    mehdix92, Jun 12, 2018 at 5:16 AM, in forum: E-mail Discussion
    Replies:
    3
    Views:
    83
    cPanelMichael
    Jun 14, 2018 at 9:08 AM

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.
    Accept Learn More...
    Dismiss Notice