NetXMS Support Forum

Hi Victor

The version of the library found installed is another one, libmysqlclient.so.18.

the agent was installed using the command tar -xvf nxagent-3.4.310-linux-x86_64.tar -C / < /opt/netxms >.

Cássio

Hey,

as per debuglevel, mysql driver is not loading.


2022.07.14 09:45:40.806 *I* [                   ] Subagent "PORTCHECK" (portcheck.nsm) loaded successfully (version 3.4.310)
2022.07.14 09:45:40.807 *D* [dload              ] DLOpen: file="/opt/netxms/lib/netxms/mysql.nsm", module=0x1038af0
2022.07.14 09:45:40.807 *D* [dload              ] DLGetSymbolAddr: module=0x1038af0, symbol=NxSubAgentRegister, address=0x7fe625ea3ed0
2022.07.14 09:45:40.807 *D* [dload              ] DLOpen: file="/opt/netxms/lib/netxms/dbdrv/mysql.ddr", module=(
2022.07.14 09:45:40.807 *E* [db.drv             ] Unable to load database driver module "mysql.ddr": libmysqlclient.so.16: cannot open shared object file: No such file or directory
2022.07.14 09:45:40.807 *E* [                   ] MYSQL: failed to load database driver
2022.07.14 09:45:40.807 *E* [                   ] Initialization of subagent "MYSQL" (/opt/netxms/lib/netxms/mysql.nsm) failed
2022.07.14 09:45:40.807 *D* [dload              ] DLClose: module=0x1038af0
2022.07.14 09:45:40.807 *I* [                   ] System hardware ID is unknown
2022.07.14 09:45:41.809 *D* [                   ] External parameters providers poller thread will not start

Hey,

I configured an agent as per the documentation for collecting data from a mysql database.
however I am not able to collect/visualize several parameters, examples according to page 279, admin tab:

MySQL.InnoDB.ReadCacheHitRatio(idIn)noDB read cache hit ratio (%)
MySQL.InnoDB.ReadRequest(id) InnoDB read requests
MySQL.InnoDB.WriteRequest(id) InnoDB write requests
MySQL.InnoDB.ReadCacheHitRatio(idIn)noDB read cache hit ratio (%)
MySQL.InnoDB.ReadRequest(id) InnoDB read requests
MySQL.InnoDB.WriteRequest(id) InnoDB write requests

How does business services work?

how is the coding on this module? How is the SLA calculated?
Is there any documentation? Do you have any files that control this?

Cassio - GPD

hello,

Sudanov

It worked . Thanks ...

Hi Sudanov.

Yes, it was compiled with the following commands :

./configure --prefix=/produtos/netxms --with-server --with-mysql --with-agent --disable-ssh --disable-mqtt

./make install -I /produtos/netxms

./make -I /produtos/netxms

Hello,

We are not able to upload the mysql database versio 8.0.26, SO Red Hat Linux 8.2, it shows the error:

Unable to load database driver module "mysql.ddr": libmysqlclient.so.21: cannot open shared object file: No such file or directory.

Below is the debug log:

[root@vmnetxms bin]# ./netxmsd -D9
Using configuration file "/etc/netxmsd.conf"
2021.09.01 15:45:18.795 *D* [                   ] LIB directory set to /produtos/netxms/lib/netxms
2021.09.01 15:45:18.795 *I* [                   ] Code page set to ISO8859-1
2021.09.01 15:45:18.797 *D* [dload              ] DLOpen: file="/produtos/netxms/lib/netxms/linux.nsm", module=0x1285250
2021.09.01 15:45:18.797 *D* [dload              ] DLGetSymbolAddr: module=0x1285250, symbol=__NxSubAgentGetIfList, address=0x7f16158117a0
2021.09.01 15:45:18.797 *D* [dload              ] DLGetSymbolAddr: module=0x1285250, symbol=__NxSubAgentGetArpCache, address=0x7f16158117d0
2021.09.01 15:45:18.797 *I* [                   ] Platform subagent "/produtos/netxms/lib/netxms/linux.nsm" successfully loaded
2021.09.01 15:45:18.797 *D* [dload              ] DLOpen: file="/produtos/netxms/lib/netxms/dbdrv/mysql.ddr", module=(nil)
2021.09.01 15:45:18.797 *E* [db.drv             ] Unable to load database driver module "mysql.ddr": libmysqlclient.so.21: cannot open shared object file: No such file or directory

Hello, Sudanov.

The nxagent.conf file is configured and running according to the documentation (active as log), but I still can't view/create an response time, Bytes received, time DNS resolution, load/download time, TCP time and connection, latency, availability chart.

See the examples attached

Thanks
Cássio

I followed the documentation (the two options-node/DCI). But I'm not getting the desired result. Displays error (NetSvc. ResponseTime UNSPPORTED); I couldn't find the Service. Check. xxxxx parameter.

I would like to get results of the type (response time, Bytes received, time DNS resolution, load/download time, TCP time and connection, latency, availability). Someone has some documentation on it.

Cássio