NetXMS Support Forum

Hi,

here are some other, maybe helpful things I figured out:
Bevor the update there was a "libnetxms.so.2" at /usr/lib/x86_64-linux-gnu; now there is a file "libnetxms.so.31".
It seems that libnxddr_pgsql.so is looking for a wrong file...?

Hi,

dpkg -l | grep netxms:

ii  netxms-agent:amd64                    3.1.242-2                                       amd64        NetXMS agent
ii  netxms-base:amd64                     3.1.242-2                                       amd64        NetXMS core libraries
ii  netxms-dbdrv-pgsql:amd64              3.1.242-2                                       amd64        PostgreSQL driver for netxms-server
ii  netxms-dbdrv-sqlite3:amd64            3.1.242-2                                       amd64        SQLite3 driver for netxms-server
ii  netxms-release                        1.6                                             all          Package to install apt source and gpg keyring
iF  netxms-server:amd64                   3.1.242-2                                       amd64        meta package

netxmsd.conf:

DBDriver = /usr/local/lib/libnxddr_pgsql.so
DBServer = localhost
DBName = netxms
DBLogin = xxxx
DBPassword = xxxxxxxx
LogFile = /var/log/netxmsd
LogFailedSQLQueries = yes

Hi,

I updated my netxms server today to version 3.1.242 using apt-get update && apt-get upgrade on Ubuntu 18.04 LTS.
While upgrading I get the following error-massage:

"~$ sudo apt-get upgrade
Paketlisten werden gelesen... Fertig
Abhängigkeitsbaum wird aufgebaut.
Statusinformationen werden eingelesen.... Fertig
Paketaktualisierung (Upgrade) wird berechnet... Fertig
0 aktualisiert, 0 neu installiert, 0 zu entfernen und 0 nicht aktualisiert.
1 nicht vollständig installiert oder entfernt.
Nach dieser Operation werden 0 B Plattenplatz zusätzlich benutzt.
Möchten Sie fortfahren? [J/n] j
netxms-server:amd64 (3.1.242-2) wird eingerichtet ...
NetXMS Database Manager Version 3.1.242 Build 3.1-242-g2c0fcdb3de (UNICODE)

Unable to load and initialize database driver "/usr/local/lib/libnxddr_pgsql.so"
dpkg: Fehler beim Bearbeiten des Paketes netxms-server:amd64 (--configure):
installed netxms-server:amd64 package post-installation script subprocess returned error exit status 3
Trigger für libc-bin (2.27-3ubuntu1) werden verarbeitet ...
Fehler traten auf beim Bearbeiten von:
netxms-server:amd64
E: Sub-process /usr/bin/dpkg returned an error code (1)"

Netxmsd-service doesn`t came up.

debug 9 shows:

" sudo netxmsd -D 9
Using configuration file "/etc/netxmsd.conf"
2019.12.03 13:08:46.554 *D* [                   ] LIB directory set to /usr/lib/x86_64-linux-gnu/netxms
2019.12.03 13:08:46.554 *I* [                   ] Code page set to ISO8859-1
2019.12.03 13:08:46.555 *D* [dload              ] DLOpen: file="/usr/lib/x86_64-linux-gnu/netxms/linux.nsm", module=0x7ff1e5078e00
2019.12.03 13:08:46.555 *D* [dload              ] DLGetSymbolAddr: module=0x7ff1e5078e00, symbol=__NxSubAgentGetIfList, address=0x7ff1e476ef90
2019.12.03 13:08:46.555 *D* [dload              ] DLGetSymbolAddr: module=0x7ff1e5078e00, symbol=__NxSubAgentGetArpCache, address=0x7ff1e476efc0
2019.12.03 13:08:46.556 *I* [                   ] Platform subagent "/usr/lib/x86_64-linux-gnu/netxms/linux.nsm" successfully loaded
2019.12.03 13:08:46.556 *D* [dload              ] DLOpen: file="/usr/local/lib/libnxddr_pgsql.so", module=(nil)
2019.12.03 13:08:46.556 *E* [db.drv             ] Unable to load database driver module "/usr/local/lib/libnxddr_pgsql.so": libnetxms.so.2: cannot open shared object file: No such file or directory"
I tried reinstalling the pgsql driver but it didn`t help.

I found some hint in another thread.
Using  "ldd /usr/local/lib/libnxddr_pgsql.so"
I get the following massage:

"linux-vdso.so.1 (0x00007ffe763d0000)
        libnetxms.so.2 => not found
        libpq.so.5 => /usr/lib/x86_64-linux-gnu/libpq.so.5 (0x00007f50249c5000)
        libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f50247c1000)
        libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f50245a2000)
        libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f50241b1000)
        libssl.so.1.1 => /usr/lib/x86_64-linux-gnu/libssl.so.1.1 (0x00007f5023f24000)
        libcrypto.so.1.1 => /usr/lib/x86_64-linux-gnu/libcrypto.so.1.1 (0x00007f5023a59000)
        libgssapi_krb5.so.2 => /usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2 (0x00007f502380e000)
        libldap_r-2.4.so.2 => /usr/lib/x86_64-linux-gnu/libldap_r-2.4.so.2 (0x00007f50235bc000)
        /lib64/ld-linux-x86-64.so.2 (0x00007f5024e15000)
        libkrb5.so.3 => /usr/lib/x86_64-linux-gnu/libkrb5.so.3 (0x00007f50232e6000)
        libk5crypto.so.3 => /usr/lib/x86_64-linux-gnu/libk5crypto.so.3 (0x00007f50230b4000)
        libcom_err.so.2 => /lib/x86_64-linux-gnu/libcom_err.so.2 (0x00007f5022eb0000)
        libkrb5support.so.0 => /usr/lib/x86_64-linux-gnu/libkrb5support.so.0 (0x00007f5022ca5000)
        liblber-2.4.so.2 => /usr/lib/x86_64-linux-gnu/liblber-2.4.so.2 (0x00007f5022a97000)
        libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2 (0x00007f502287c000)
        libsasl2.so.2 => /usr/lib/x86_64-linux-gnu/libsasl2.so.2 (0x00007f5022661000)
        libgssapi.so.3 => /usr/lib/x86_64-linux-gnu/libgssapi.so.3 (0x00007f5022420000)
        libgnutls.so.30 => /usr/lib/x86_64-linux-gnu/libgnutls.so.30 (0x00007f50220bb000)
        libkeyutils.so.1 => /lib/x86_64-linux-gnu/libkeyutils.so.1 (0x00007f5021eb7000)
        libheimntlm.so.0 => /usr/lib/x86_64-linux-gnu/libheimntlm.so.0 (0x00007f5021cae000)
        libkrb5.so.26 => /usr/lib/x86_64-linux-gnu/libkrb5.so.26 (0x00007f5021a21000)
        libasn1.so.8 => /usr/lib/x86_64-linux-gnu/libasn1.so.8 (0x00007f502177f000)
        libhcrypto.so.4 => /usr/lib/x86_64-linux-gnu/libhcrypto.so.4 (0x00007f5021549000)
        libroken.so.18 => /usr/lib/x86_64-linux-gnu/libroken.so.18 (0x00007f5021333000)
        libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f5021116000)
        libp11-kit.so.0 => /usr/lib/x86_64-linux-gnu/libp11-kit.so.0 (0x00007f5020de7000)
        libidn2.so.0 => /usr/lib/x86_64-linux-gnu/libidn2.so.0 (0x00007f5020bca000)
        libunistring.so.2 => /usr/lib/x86_64-linux-gnu/libunistring.so.2 (0x00007f502084c000)
        libtasn1.so.6 => /usr/lib/x86_64-linux-gnu/libtasn1.so.6 (0x00007f5020639000)
        libnettle.so.6 => /usr/lib/x86_64-linux-gnu/libnettle.so.6 (0x00007f5020403000)
        libhogweed.so.4 => /usr/lib/x86_64-linux-gnu/libhogweed.so.4 (0x00007f50201cf000)
        libgmp.so.10 => /usr/lib/x86_64-linux-gnu/libgmp.so.10 (0x00007f501ff4e000)
        libwind.so.0 => /usr/lib/x86_64-linux-gnu/libwind.so.0 (0x00007f501fd25000)
        libheimbase.so.1 => /usr/lib/x86_64-linux-gnu/libheimbase.so.1 (0x00007f501fb16000)
        libhx509.so.5 => /usr/lib/x86_64-linux-gnu/libhx509.so.5 (0x00007f501f8cc000)
        libsqlite3.so.0 => /usr/lib/x86_64-linux-gnu/libsqlite3.so.0 (0x00007f501f5c3000)
        libcrypt.so.1 => /lib/x86_64-linux-gnu/libcrypt.so.1 (0x00007f501f38b000)
        libffi.so.6 => /usr/lib/x86_64-linux-gnu/libffi.so.6 (0x00007f501f183000)
        libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f501ede5000)"


Unfortunatly I`m not a linux-expert, so I don`t know how this file is gone and how I can get it back.

Does anyone have some suggestions to solve this problem?
Thanks
Sebastian

Hi Victor,

netxms server and webserver are on the same machine, web console is opened from various windows 10 clients.

Tomcat:
Server version: Apache Tomcat/8.5.39 (Ubuntu)
Server built:   Apr 10 2019 04:45:09 UTC
Server number:  8.5.39.0
OS Name:        Linux
OS Version:     4.15.0-51-generic
Architecture:   amd64
JVM Version:    11.0.3+7-Ubuntu-1ubuntu218.04.1

Java version:
openjdk version "11.0.3" 2019-04-16
OpenJDK Runtime Environment (build 11.0.3+7-Ubuntu-1ubuntu218.04.1)
OpenJDK 64-Bit Server VM (build 11.0.3+7-Ubuntu-1ubuntu218.04.1, mixed mode, sharing)

Best,
Sebastian

Hello,

when using netxms web-console, the time displayed in linecharts etc. is UTC, while on my clients it is CEST (UTC+2).
Both server and client are using ntp from the same timeserver.

I searched the forum and found some suggestions, but nothing didn´t work for me. Maybe I did something wrong and can´t find this error.
Here are the time settings for my netxms server:

Local time: Di 2019-06-11 09:50:25 CEST
Universal time: Di 2019-06-11 07:50:25 UTC
RTC time: Di 2019-06-11 07:50:25
Time zone: Europe/Berlin (CEST, +0200)
System clock synchronized: yes
systemd-timesyncd.service active: yes
RTC in local TZ: no

Settings on windows clients:

(UTC+01:00) Amsterdam, Berlin, Bern, Rom, Stockholm, Wien
settings for summertime are "automatic" and time is correct CEST
I also checked browsertime for IE11, Firefox and Chrome. It´s always CEST and at all of them the linecharts are showing UTC.
Netxms version is 2.2.13 on Ubuntu server 18.04 LTS.

Has anyone a helpful hint for me to solve this problem?

Thanks and greetings

M.

Hi Victor,

I answered weeks ago, now my post seems to be gone

But everything is fine now. I had to delete some entries from database table "scheduled tasks". Seemed that there was something false with them.

Best Regards
Sebastian

Hi,

thanks for your answer. Unluckily I'm a noob at linux. I will figure out what "under gdb" means and try to send the dump.

For now, the server is working after deleting the data in table "scheduled task".
It seems that SEGV still happens when netxmsd is restarting while an alert-email is scheduled.
Is there any known solution for this behavior?

Best, Sebastian

Hi,

I need your help
Today I updated netxms (upgrading netxms-packages) and now netxmsd gets killed straight after starting.
With "netxmsd -D 4" I get following text at the end:

"...
2019.02.04 15:03:42.621 *D* 0 startup scripts processed
2019.02.04 15:03:42.621 *D* Server initialization completed in 2053 milliseconds
2019.02.04 15:03:42.622 *I* NetXMS Server started

NetXMS Server V2.2.12 Build 9516 (UNICODE) Ready
Enter "help" for command list or "down" for server shutdown
System Console

netxmsd: 2019.02.04 15:03:43.620 *D* [action             ] Executing scheduled action [1] for event (null) on node [2453]
2019.02.04 15:03:43.620 *D* [action             ] Executing action 1 (Send E-Mail on node down) of type SEND EMAIL
Segmentation fault"

It seems to me that the server crashes when it is trying to send a Email.(?)
I checked server configs and everything is like before.
I use Ubuntu 18.04 LTS and postgresql on x64.
DB-upgrade was fine and without errors.

Has anybody some helpful suggestions for me?
THX

Hi thanks for your answer. Everything worked then.
Due to some problems at work I wasn`t able to respond in time.

Hi,

I am trying to install NETXMS on Ubuntu Server 18.04 LTS. When I try to install netxms-server I get a notice that libzmq5 is missing and could not be installed. When I´m looking for unsuppported packages I get the information, that "netxms-release is not longer downloadable". I used http://packages.netxms.org/netxms-release_1.2_all.deb
Any idea how to solve this problem? I didn´t find any informations that 18.04 LTS is unsupported.

Thanks.