Back to Geneos FAQ

How to solve error locating libmysqlclient_r.so file for MySQL or MariaDB

Netprobe database libraries, SQL-Toolkit plugin error, SQL-Toolkit plugin fail, libmysqlclient.so, libmysqlclient_r.so

Problem Copied

This article provides common solutions for the below error when you tried using SQL-Toolkit plugin to connect MySQL or MariaDB databases.

<Wed Jul 1 10:32:34> ERROR: SQL-TOOLKIT Fail -
libmysqlclient_r.so: cannot open shared object file: No such file or directory
libmysqlclient_r.so.15: cannot open shared object file: No such file or directory
libmysqlclient_r.so.16: cannot open shared object file: No such file or directory
libmysqlclient_r.so.18: cannot open shared object file: No such file or directory
DBMS API Library loading fails
This library is a part of DBMS client installation, not SQLAPI++
Make sure DBMS client is installed and
this required library is available for dynamic loading

Possible Causes Copied

Possible Cause 1 Copied

The SQL-Toolkit plugin requires the database client libraries for connecting to MySQL or MariaDB databases. This is not included in the Netprobe download package. User may not have the database client installed properly.

Possible Cause 2 Copied

You may be using an outdated Geneos version with a newer MySQL or MariaDB database. The database library filename was changed to libmysqlclient.so, and the Netprobe is looking for libmysqlclient_r.so (note the difference in _r suffix).

Possible Solutions Copied

Possible Solution 1 Copied

Please refer to the SQL-Toolkit plugin documentation, and make sure the database client has been installed on the Netprobe machine. If the database client has been installed as a different user account from the Netprobe, user should check any permission issues.

Possible Solution 2 Copied

(a) Please check that you are running Netprobe version GA5.0.0 and above (AA-4226). (Recommended)

(b) As a workaround, you may try to create a symbolic link from libmysqlclient_r.so to libmysqlclient.so in the client library folder. The command to be run in Linux should look similar to this one:

ln -s /usr/lib64/mysql/libmysqlclient.so /usr/lib64/mysql/libmysqlclient_r.so

Further Information Copied

["Geneos"] ["Geneos > Netprobe"] ["FAQ"]

Was this topic helpful?