Related toNetprobe database libraries, SQL-Toolkit plugin error, SQL-Toolkit plugin fail, libmysqlclient.so, libmysqlclient_r.so
ProblemThis 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 Cause 1The 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 2You 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 Solution 1Please 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
(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