Want to subscribe to topics you're interested in?
Become a Member

MariaDB libmysqlclient.so missing

Discussion in 'Install & Upgrades or Pre-Install Questions' started by Maester Aemon, Oct 7, 2016.

  1. Maester Aemon

    Maester Aemon New Member

    20
    3
    3
    Mar 24, 2016
    Ratings:
    +5
    Local Time:
    1:44 PM
    1.9.12
    Hi, I am trying to run an executable that needs libmysqlclient.so but I get the following error
    Code:
    error while loading shared libraries: libmysqlclient.so.20: cannot open shared object file: No such file or directory
    
    I have tried to google and figure out how to get it but I haven't had any luck with that. Anyone who has any idea? Thanks.

     
  2. eva2000

    eva2000 Administrator Staff Member

    55,182
    12,251
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,829
    Local Time:
    9:44 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    what's the full error message ? version of centmin mod used ? and mariadb version ?

    Output for following commands
    Code (Text):
    mysqladmin ver
    rpm -ql MariaDB-compat | grep '.so'
    updatedb
    locate libmysqlclient.so
    
     
  3. Maester Aemon

    Maester Aemon New Member

    20
    3
    3
    Mar 24, 2016
    Ratings:
    +5
    Local Time:
    1:44 PM
    1.9.12
    I figured this out as it seems like one needs MySQL 7. I don't think MariaDB has libmysqlclient.so.20 (version 20).

    But anyways here's the output for following commands

    Code:
    mysqladmin  Ver 9.1 Distrib 10.0.27-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.0.27-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 19 days 3 hours 32 min 17 sec
    
    Threads: 1  Questions: 1998  Slow queries: 0  Opens: 15  Flush tables: 1  Open tables: 69  Queries per second avg: 0.001
    
    Code:
    /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.15
    /usr/lib64/libmysqlclient_r.so.15.0.0
    /usr/lib64/libmysqlclient_r.so.16
    /usr/lib64/libmysqlclient_r.so.16.0.0
    
    No output for updatedb

    Code:
    /usr/lib64/libmysqlclient.so
    /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.so.18
    /usr/lib64/libmysqlclient.so.18.0.0
    /usr/lib64/mysql/libmysqlclient.so
    
    Latest centminmod (stable I think) is being used. And full error message is simply that in op, that libmysqlclient.so.20 is missing.
     
  4. eva2000

    eva2000 Administrator Staff Member

    55,182
    12,251
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,829
    Local Time:
    9:44 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    what app you trying to run ?
     
  5. Maester Aemon

    Maester Aemon New Member

    20
    3
    3
    Mar 24, 2016
    Ratings:
    +5
    Local Time:
    1:44 PM
    1.9.12
    Its coded by a friend and needs version 20 of libmysqlclient to use sql connection, not sure why version 20 though.
     
  6. eva2000

    eva2000 Administrator Staff Member

    55,182
    12,251
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,829
    Local Time:
    9:44 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    .20 is for Oracle MySQL 5.7

    .18 is used by MariaDB 10.1 and Percona MySQL 5.7
    .16 is used by MariaDB 10.0 and 5.5

    Probably get him to code for .16 minimum
     
    Last edited: Oct 7, 2016