Agent configuration file problem in NetXMS version 2.6.300

[jbriseno]

Hi, Alex I appreciate your time to help me. I repeated the Filipp procedure as root user. The computer screen sent the following messages:

root@hpserver1:/var/log# rm netxmsd.log
root@hpserver1:/var/log# cd
root@hpserver1:~# netxmsd -D 6
Using configuration file "/etc/netxmsd.conf"
2020.12.05 12:56:36.873 *D* [                  ] LIB directory set to /usr/local/lib/netxms
2020.12.05 12:56:36.874 *I* [                  ] Code page set to ISO8859-1
2020.12.05 12:56:36.874 *E* [                  ] Cannot load platform subagent "/usr/local/lib/netxms/linux.nsm" (/usr/local/lib/netxms/linux.nsm: cannot open shared object file: No such file or directory)
2020.12.05 12:56:36.874 *E* [db.drv            ] Unable to load database driver module "mysql.ddr": /usr/local/lib/netxms/dbdrv/mysql.ddr: cannot open shared object file: No such file or directory

The content of the netxmsd.conf file

# Logging
# Log file name
LogFile=/var/log/netxmsd

# Increase logging verbosity, 0 (only errors) to 9 (verbose debug)
#DebugLevel=3

## Database configuration.
## Uncomment and setup ONE section.

## Option #1 - SQLite (for test installations only):
#DBDriver=sqlite.ddr
#DBName=/var/lib/netxms/netxms.db

## Option #2 - PostgreSQL (recommended):
#DBDriver=pgsql.ddr
#DBServer=127.0.0.1
#DBName=netxms
#DBLogin=netxms
#DBPassword=netxms

##Option #3 - MySQL:
DBDriver=mysql.ddr
DBServer=localhost
DBName=netxms
DBLogin=############
DBPassword=########

## Option #4 - Oracle:
#DBDriver=oracle.ddr
#DBServer=//127.0.0.1:1521/ORCL # Instant Client connection string or SID
#DBLogin=netxms
#DBPassword=netxms

## Option #5 - unixODBC/FreeTDS:
#DBDriver=odbc.ddr
#DBServer=NETXMS_DSN
#DBLogin=netxms
#DBPassword=netxms

Thanks in Advance

[alk]

According to systemctl output, netxms is installed in /usr, but it tries to load modules from /usr/local/bin - this looks like you mixed binaries from different versions.
I recommend to clean both versions, then configure and make install again.

Which distro do you use?

[jbriseno]

Hi, Alex. I am using Ubuntu server 18.04. Question: How can I clean both versions?
Thanks in advance.

[Filipp Sudanov]

I would do the following way:
apt remove "netxms*"

Then find and delete the following files on the file system:
libnx*
libnetxms*

And then install netxms again - install  netxms-release package and then netxms-server, netxms-agent and database driver package.

[jbriseno]

Hi, Filipp. Thanks for your sooner reply to my post. I have a Database question: we have a current netXMS database. With this in mind. Do I do

nxdbmgr upgrade or

nxdbmgr init

Thanks in advance

Jose

[Filipp Sudanov]

The database will stand as it is, so there is no need to do init or upgrade. Netxms will just connect to the database that it has in config file.

[jbriseno]

Hi, Filipp, Got it. Thanks

[jbriseno]

Hi, Fillip. I followed your directions to re install the NextXMS on our server.  However, when I tried to install it appeared an error:

Error while loading shared libraries: libnxdb.so.36 when I tried to install the latest netXMS server

Apt command information

sudo apt-get install netxms-server netxms-dbdrv-mysql

The following additional packages will be installed:
  netxms-agent netxms-dbdrv-sqlite3
The following NEW packages will be installed:
  netxms-agent netxms-dbdrv-mysql netxms-dbdrv-sqlite3 netxms-server

sudo systemctl status nxagentd.service
%u25CF nxagentd.service - NetXMS Agent
  Loaded: loaded (/lib/systemd/system/nxagentd.service; disabled; vendor preset: enabled)
  Active: failed (Result: exit-code) since Tue 2020-12-08 16:15:14 UTC; 4min 59s ago

Dec 08 16:15:14 hpserver1 systemd[1]: Starting NetXMS Agent...
Dec 08 16:15:14 hpserver1 nxagentd[15444]: /usr/bin/nxagentd: error while loading shared libraries: libnxdb.so.36: cannot open s
Dec 08 16:15:14 hpserver1 systemd[1]: nxagentd.service: Control process exited, code=exited status=127
Dec 08 16:15:14 hpserver1 systemd[1]: nxagentd.service: Failed with result 'exit-code'.
Dec 08 16:15:14 hpserver1 systemd[1]: Failed to start NetXMS Agent.

josemb@hpserver1:~$ sudo find / -name libnx*
[sudo] password for josemb:
/usr/lib/x86_64-linux-gnu/libnxlp.so.36.0.0
/usr/lib/x86_64-linux-gnu/libnxlp.so.36
/usr/lib/x86_64-linux-gnu/libnxsl.so.36.0.0
/usr/lib/x86_64-linux-gnu/libnxagent.so.36.0.0
/usr/lib/x86_64-linux-gnu/libnxcore.so.36
/usr/lib/x86_64-linux-gnu/libnxcore.so.36.0.0
/usr/lib/x86_64-linux-gnu/libnxsrv.so.36.0.0
/usr/lib/x86_64-linux-gnu/libnxsrv.so.36
/usr/lib/x86_64-linux-gnu/libnxsl.so.36
/usr/lib/x86_64-linux-gnu/libnxdbmgr.so.36
/usr/lib/x86_64-linux-gnu/libnxagent.so.36
/usr/lib/x86_64-linux-gnu/libnxdbmgr.so.36.0.0

Do you know what I did wrong? any comments are wellcome !

[Filipp Sudanov]

Did you manage to find and delete libnx* and libnetxms* files?

Please show the output of these two commands:

ldd /usr/bin/nxagentd
ldd /usr/lib/x86_64-linux-gnu/libnxdb.so.36

[jbriseno]

Hi, Filipp. Yes I did them.

The output of mentioned two commands:

ldd /usr/bin/nxagentd
    linux-vdso.so.1 (0x00007ffc9abed000)
    libappagent.so.36 => /usr/lib/x86_64-linux-gnu/libappagent.so.36 (0x00007f129e708000)
    libnxagent.so.36 => /usr/lib/x86_64-linux-gnu/libnxagent.so.36 (0x00007f129e4f7000)
    libnxdb.so.36 => not found
    libnetxms.so.36 => not found
    libnxsnmp.so.36 => not found
    libsystemd.so.0 => /lib/x86_64-linux-gnu/libsystemd.so.0 (0x00007f129e273000)
    libjansson.so.4 => /usr/lib/x86_64-linux-gnu/libjansson.so.4 (0x00007f129e065000)
    librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f129de5d000)
    libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f129dc59000)
    libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f129da3a000)
    libssl.so.1.1 => /usr/lib/x86_64-linux-gnu/libssl.so.1.1 (0x00007f129d7ac000)
    libcrypto.so.1.1 => /usr/lib/x86_64-linux-gnu/libcrypto.so.1.1 (0x00007f129d2de000)
    libcurl.so.4 => /usr/lib/x86_64-linux-gnu/libcurl.so.4 (0x00007f129d05f000)
    libpcre32.so.3 => /usr/lib/x86_64-linux-gnu/libpcre32.so.3 (0x00007f129cdfc000)
    libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f129ca73000)
    libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f129c85b000)
    libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f129c46a000)
    libnetxms.so.36 => not found
    libnxdb.so.36 => not found
    libnetxms.so.36 => not found
    liblzma.so.5 => /lib/x86_64-linux-gnu/liblzma.so.5 (0x00007f129c244000)
    liblz4.so.1 => /usr/lib/x86_64-linux-gnu/liblz4.so.1 (0x00007f129c028000)
    libgcrypt.so.20 => /lib/x86_64-linux-gnu/libgcrypt.so.20 (0x00007f129bd0c000)
    /lib64/ld-linux-x86-64.so.2 (0x00007f129eeac000)
    libnghttp2.so.14 => /usr/lib/x86_64-linux-gnu/libnghttp2.so.14 (0x00007f129bae7000)
    libidn2.so.0 => /usr/lib/x86_64-linux-gnu/libidn2.so.0 (0x00007f129b8c8000)
    librtmp.so.1 => /usr/lib/x86_64-linux-gnu/librtmp.so.1 (0x00007f129b6ac000)
    libpsl.so.5 => /usr/lib/x86_64-linux-gnu/libpsl.so.5 (0x00007f129b49e000)
    libgssapi_krb5.so.2 => /usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2 (0x00007f129b253000)
    libldap_r-2.4.so.2 => /usr/lib/x86_64-linux-gnu/libldap_r-2.4.so.2 (0x00007f129b001000)
    liblber-2.4.so.2 => /usr/lib/x86_64-linux-gnu/liblber-2.4.so.2 (0x00007f129adf3000)
    libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f129abd6000)
    libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f129a838000)
    libgpg-error.so.0 => /lib/x86_64-linux-gnu/libgpg-error.so.0 (0x00007f129a623000)
    libunistring.so.2 => /usr/lib/x86_64-linux-gnu/libunistring.so.2 (0x00007f129a2a5000)
    libgnutls.so.30 => /usr/lib/x86_64-linux-gnu/libgnutls.so.30 (0x00007f1299f3f000)
    libhogweed.so.4 => /usr/lib/x86_64-linux-gnu/libhogweed.so.4 (0x00007f1299d0b000)
    libnettle.so.6 => /usr/lib/x86_64-linux-gnu/libnettle.so.6 (0x00007f1299ad5000)
    libgmp.so.10 => /usr/lib/x86_64-linux-gnu/libgmp.so.10 (0x00007f1299854000)
    libkrb5.so.3 => /usr/lib/x86_64-linux-gnu/libkrb5.so.3 (0x00007f129957e000)
    libk5crypto.so.3 => /usr/lib/x86_64-linux-gnu/libk5crypto.so.3 (0x00007f129934c000)
    libcom_err.so.2 => /lib/x86_64-linux-gnu/libcom_err.so.2 (0x00007f1299148000)
    libkrb5support.so.0 => /usr/lib/x86_64-linux-gnu/libkrb5support.so.0 (0x00007f1298f3d000)
    libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2 (0x00007f1298d23000)
    libsasl2.so.2 => /usr/lib/x86_64-linux-gnu/libsasl2.so.2 (0x00007f1298b08000)
    libgssapi.so.3 => /usr/lib/x86_64-linux-gnu/libgssapi.so.3 (0x00007f12988c7000)
    libp11-kit.so.0 => /usr/lib/x86_64-linux-gnu/libp11-kit.so.0 (0x00007f1298598000)
    libtasn1.so.6 => /usr/lib/x86_64-linux-gnu/libtasn1.so.6 (0x00007f1298385000)
    libkeyutils.so.1 => /lib/x86_64-linux-gnu/libkeyutils.so.1 (0x00007f1298181000)
    libheimntlm.so.0 => /usr/lib/x86_64-linux-gnu/libheimntlm.so.0 (0x00007f1297f78000)
    libkrb5.so.26 => /usr/lib/x86_64-linux-gnu/libkrb5.so.26 (0x00007f1297ceb000)
    libasn1.so.8 => /usr/lib/x86_64-linux-gnu/libasn1.so.8 (0x00007f1297a49000)
    libhcrypto.so.4 => /usr/lib/x86_64-linux-gnu/libhcrypto.so.4 (0x00007f1297813000)
    libroken.so.18 => /usr/lib/x86_64-linux-gnu/libroken.so.18 (0x00007f12975fd000)
    libffi.so.6 => /usr/lib/x86_64-linux-gnu/libffi.so.6 (0x00007f12973f5000)
    libwind.so.0 => /usr/lib/x86_64-linux-gnu/libwind.so.0 (0x00007f12971cc000)
    libheimbase.so.1 => /usr/lib/x86_64-linux-gnu/libheimbase.so.1 (0x00007f1296fbd000)
    libhx509.so.5 => /usr/lib/x86_64-linux-gnu/libhx509.so.5 (0x00007f1296d73000)
    libsqlite3.so.0 => /usr/lib/x86_64-linux-gnu/libsqlite3.so.0 (0x00007f1296a6a000)
    libcrypt.so.1 => /lib/x86_64-linux-gnu/libcrypt.so.1 (0x00007f1296832000)

ldd /usr/lib/x86_64-linux-gnu/libnxdb.so.36
ldd: /usr/lib/x86_64-linux-gnu/libnxdb.so.36: No such file or directory

Thanks in advance

[victor]

Looks like files from netxms-base package are missing - try to re-install it.

Best regards,
Victor

[jbriseno]

Hi, Victor I appreciate your sooner reply to my post. I have a question: How can I install the netxms-base package ?

Thanks in Advance

[Filipp Sudanov]

apt install netxms-base

if it's already installed, try removing it first with
apt purge netxms-base

[jbriseno]

Hi, Filipp. First I appreciate your time for help me. Second, Every thing is Ok. However, when

sudo apt-get install netxms-server netxms-dbdrv-pgsql

Additional steps required:

1. Edit default configuration file (/etc/netxmsd.conf) <----- Done !

2. Load database schema

  nxdbmgr init <--- I have a question here. Do I have to do it or I do nxdbmgr upgrade. Because I started netXMS server without this step and It  doesn't work

3. Start daemon with command:

  systemctl start netxms-server

The latest 3 lines of the file /var/log/netxmsd

2020.12.09 13:31:22.401 *I* [                  ] Platform subagent "/usr/lib/x86_64-linux-gnu/netxms/linux.nsm" successfully loaded
2020.12.09 13:31:22.401 *E* [db.drv            ] Unable to load database driver module "mysql.ddr": /usr/lib/x86_64-linux-gnu/netxms/dbdrv/mysql.ddr: cannot open shared object file: No such file or directory

Thanks in Advance

[jbriseno]

Hey, Filipp. I found an installation procedure error. I fixed it and the netXMS server is up and running

josemb@hpserver1:~$ netxmsd -version
NetXMS Server Version 3.6.300 Build 3.6-300-g287f599693 (UNICODE)
NXCP: 5.53.1.29 (AES-256, Blowfish-256, 3DES, AES-128, Blowfish-128)
Built with: g++ (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0

Thanks a lot to all netxms guys for your help. I appreciate a lot.

Best regards !
Jose

[alk]

If tables are already created - run "nxdbmgr upgrade"