NetXMS Support Forum

Thanks Victor! Removed old entrys (think that still some leftovers are in the System), exectuted systemctl enable ntexms, and finaly everything is working fine!
Regards from Vienna

Hi Victor!

Thanks for answering, I originally Setup the Server from source the I decided to remove the install and did another install via apt. It worked fine till the update. Do you think that some parts of the first try are left over? I found nxdbmgr in /usr/bin (seems to be the correct Version). I also learned that netxmsd seems to be in this Location and is not starting automaticaly. Is there a solution for this Problem?

Regards
Hary

Hi, since the last update I have this Problem:
~# ldconfig
~# ldconfig -p|grep libnetxms                                               libnetxms.so.34 (libc6,x86-64) => /lib/x86_64-linux-gnu/libnetxms.so.34
~# /usr/local/bin/nxdbmgr init /usr/share/netxms/sql/dbinit_mysql.sql
/usr/local/bin/nxdbmgr: error while loading shared libraries: libnxdbmgr.so.33: cannot open shared object file: No such file or Directory


How can I fix this? Please help me, the Servier is not working anymore!!

Regads from Vienna
Hary

Found Problem that causes not showing the VMHost behinde the ILO, you have to create node with IP 0.0.0.0 set check at 'This is address of remote management node' and Change IP to the correct one, than everything works. Not solvet the crash Problem, please check this and give me some help

Hi, my old Server always crashed after start (no login possible), so I decided to make a new Server. Guess what, after Start it crashes (Database is locked) now build from .deb not compiled from Scratch as the last Server was, so I Always have to stop netxmsd, unlock db, and start netxmsd. This is bad if it happens during the night.......
Other Thing with the new Server is, I have a HP Server (Gen0) with ILO, bevor the new Server I was able to check the ESXi trough the ILO, this is not working anymore. But, I´m not able to add the ESXi, because Netxms says, that this IP is still in use (ILO has 253, ESXi has 1, so different IP´s). Sometimes I´m able to add, but some hours later its gone (with all the DCI´s I worked days for, are they somewhere?)

SOLVED
Found out that since 4 days there is a new Version of the datasource on Git (but nor message About this..)

Found some strage Thing, the Datasource NETXMS trys to sort with the Settings from a complete different Datasource (a MySQL source that is local), found no way to Change this, even reinstalling NETXMS Datasource did not help%u2026. When I try to make a new Dashboard, also no success (can not choose any DCI from list, List is empty) Any ideas?

This is the string from JSON Model:

"targets": [   
{
          "dci": {
            "id": "670",
            "name": "CPU: usage"
          },
          "dciTarget": {
            "id": "184",
            "name": "mail.event-log.com"
          },
"format": "time_series",
          "group": [],
          "hide": false,
          "legend": "",
          "metricColumn": "none",
          "rawQuery": false,
          "rawSql": "SELECT\n  timeco1h AS \"time\",\n  id\nFROM co1h\nWHERE\n  $__timeFilter(timeco1h)\nORDER BY timeco1h",              I think this is the Problem!
          "refId": "A",
          "select": [
  [
              {
                "params": [
                  "id"
                ],
                "type": "column"
              }
            ]
          ],
          "table": "co1h",
          "timeColumn": "timeco1h",
          "timeColumnType": "timestamp",
          "type": "DCI",
          "where": [
            {
              "name": "$__timeFilter",
              "params": [],
              "type": "macro"
    }
          ]
        }

I got this error on Grafana since some week when I try to Access my Netxms Data, everything i tryed was witout success (delete datasource and recreate, Change tomcat on Netxms site, update Grafana, Netxms and both Debian OS....)
status:500
statusText:"Internal Server Error"
data:Object
description:"Unparseable date: "ri Apr 03 2020 19:14:26 GMT+020""
error:46
message:46

When testing the Datasource i got: Function expected sometimes the Error is different and says someting About the Http Header

And now the realy strange Thing: it happens on Edge all the time, on Chrome it is only the first minutes after rebooting the Server...... On mobilphone (Android with Chrome and Edge) it is aso not working, same Error as on Edge on Windows (just that both browser have this error)........
Any Ideas? I´m not sure if it is related to Grafana or Netxms.
Greetings
Hary from Vienna

Tried this out, produces new Errors and no Data where shown after this Change, so I think this original error is some kind of cosmetic problem

Hi Victor, this is the Output of gdb. How can i Prevent getting null (sorry I´m not a programmer :-))

Found some time because of canceled meetings....... Did the install as described, lets see what happens. In case of Problems I´ll start the Debugger mode
How can i get rid of this Messages:
[204] DCI Dummy [428] (Error 5 in line 5: Invalid operation with NULL value)

This is the Content of the Transformation:
Avail = GetDCIValue($node, FindDCIByDescription($node, "memAvailReal"));
Buffer = GetDCIValue($node, FindDCIByDescription($node, "memBuffer"));
Cached = GetDCIValue($node, FindDCIByDescription($node, "memCached"));
Total = GetDCIValue($node, FindDCIByDescription($node, "memTotalReal"));
return (Total - Avail - Buffer - Cached) * 1000;

Thanks, will try as soon as possible (I´m afraid not before Satureday), Thanks.

No, after reboot got same Problem again Connection refused: connect Before reboot i disabled some of the DCI with Errors, can this be the reason?

2020.03.10 08:36:29.060 *I* [logger             ] Log file opened (rotation policy 2, max size 16777216)
2020.03.10 08:36:29.126 *I* [                   ] Code page set to ISO8859-1
2020.03.10 08:36:29.202 *I* [                   ] Platform subagent "/usr/local/lib/netxms/linux.nsm" successfully loaded
2020.03.10 08:36:29.433 *I* [db.drv             ] Database driver "mysql.ddr" loaded and initialized successfully
2020.03.10 08:36:34.710 *I* [                   ] Server ID 2B5B9BE9BB192F11
2020.03.10 08:36:35.092 *I* [                   ] Server certificate not set
2020.03.10 08:36:35.712 *I* [db.drv             ] Database driver "sqlite.ddr" loaded and initialized successfully
2020.03.10 08:36:36.007 *I* [db.drv             ] Database driver "sqlite.ddr" loaded and initialized successfully
2020.03.10 08:36:36.441 *E* [                   ] Unable to load module "/usr/local/lib/netxms/ndd/ers8000.ndd" (/usr/local/lib/libavaya-ers.so: undefined symbol: _Z8SnmpWalkP14SNMP_TransportPKwPFjP13SNMP_VariableS0_PvES5_b)
2020.03.10 08:36:36.444 *I* [                   ] Network device driver DELL-PWC loaded successfully
2020.03.10 08:36:36.452 *I* [                   ] Network device driver OPTIX loaded successfully
2020.03.10 08:36:36.463 *I* [                   ] Network device driver NETONIX loaded successfully
2020.03.10 08:36:36.472 *E* [                   ] Unable to load module "/usr/local/lib/netxms/ndd/netscreen.ndd" (/usr/local/lib/netxms/ndd/netscreen.ndd: undefined symbol: _Z8SnmpWalkP14SNMP_TransportPKwPFjP13SNMP_VariableS0_PvES5_b)
2020.03.10 08:36:36.477 *I* [                   ] Network device driver EXTREME loaded successfully
2020.03.10 08:36:36.486 *I* [                   ] Network device driver H3C loaded successfully
2020.03.10 08:36:36.486 *I* [                   ] Network device driver HPSW loaded successfully
2020.03.10 08:36:36.486 *I* [                   ] Network device driver PROCURVE loaded successfully
2020.03.10 08:36:36.489 *I* [                   ] Network device driver DLINK loaded successfully
2020.03.10 08:36:36.507 *E* [                   ] Unable to load module "/usr/local/lib/netxms/ndd/ntws.ndd" (/usr/local/lib/netxms/ndd/ntws.ndd: undefined symbol: _Z8SnmpWalkP14SNMP_TransportPKwPFjP13SNMP_VariableS0_PvES5_b)
2020.03.10 08:36:36.517 *E* [                   ] Unable to load module "/usr/local/lib/netxms/ndd/hpsw.ndd" (/usr/local/lib/netxms/ndd/hpsw.ndd: undefined symbol: _Z8SnmpWalkP14SNMP_TransportPKwPFjP13SNMP_VariableS0_PvES5_b)
2020.03.10 08:36:36.526 *I* [                   ] Network device driver PING3 loaded successfully
2020.03.10 08:36:36.533 *I* [                   ] Network device driver QTECH-OLT loaded successfully
2020.03.10 08:36:36.548 *E* [                   ] Unable to find entry point in network device driver "/usr/local/lib/netxms/ndd/cisco-sb.ndd"
2020.03.10 08:36:36.554 *I* [                   ] Network device driver NET-SNMP loaded successfully
2020.03.10 08:36:36.564 *I* [                   ] Network device driver SYMBOL-WS loaded successfully
2020.03.10 08:36:36.581 *I* [                   ] Network device driver RITTAL loaded successfully
2020.03.10 08:36:36.598 *I* [                   ] Network device driver JUNIPER loaded successfully
2020.03.10 08:36:36.598 *I* [                   ] Network device driver NETSCREEN loaded successfully
2020.03.10 08:36:36.601 *E* [                   ] Unable to find entry point in network device driver "/usr/local/lib/netxms/ndd/procurve.ndd"
2020.03.10 08:36:36.617 *I* [                   ] Network device driver AIRESPACE loaded successfully
2020.03.10 08:36:36.633 *E* [                   ] Unable to load module "/usr/local/lib/netxms/ndd/cat2900xl.ndd" (/usr/local/lib/libcisco.so: undefined symbol: _Z8SnmpWalkP14SNMP_TransportPKwPFjP13SNMP_VariableS0_PvES5_b)
2020.03.10 08:36:36.639 *I* [                   ] Network device driver TB loaded successfully
2020.03.10 08:36:36.645 *I* [                   ] Network device driver IGNITENET loaded successfully
2020.03.10 08:36:36.657 *I* [                   ] Network device driver MIKROTIK loaded successfully
2020.03.10 08:36:36.666 *E* [                   ] Unable to load module "/usr/local/lib/netxms/ndd/catalyst.ndd" (/usr/local/lib/libcisco.so: undefined symbol: _Z8SnmpWalkP14SNMP_TransportPKwPFjP13SNMP_VariableS0_PvES5_b)
2020.03.10 08:36:36.668 *I* [                   ] Network device driver UBNT loaded successfully
2020.03.10 08:36:36.669 *I* [                   ] Network device driver AT loaded successfully
2020.03.10 08:36:36.681 *E* [                   ] Unable to find entry point in network device driver "/usr/local/lib/netxms/ndd/cisco-esw.ndd"
2020.03.10 08:36:36.686 *I* [                   ] Network device driver CATALYST-GENERIC loaded successfully
2020.03.10 08:36:36.686 *I* [                   ] Network device driver CATALYST-2900XL loaded successfully
2020.03.10 08:36:36.686 *I* [                   ] Network device driver CISCO-ESW loaded successfully
2020.03.10 08:36:36.686 *I* [                   ] Network device driver CISCO-NEXUS loaded successfully
2020.03.10 08:36:36.686 *I* [                   ] Network device driver CISCO-SB loaded successfully
2020.03.10 08:36:36.686 *I* [                   ] Network device driver CISCO-GENERIC loaded successfully
2020.03.10 08:36:36.712 *I* [                   ] Network device driver BAYSTACK loaded successfully
2020.03.10 08:36:36.712 *I* [                   ] Network device driver NTWS loaded successfully
2020.03.10 08:36:36.712 *I* [                   ] Network device driver ERS8000 loaded successfully
2020.03.10 08:36:36.720 *E* [                   ] Unable to load module "/usr/local/lib/netxms/ndd/baystack.ndd" (/usr/local/lib/libavaya-ers.so: undefined symbol: _Z8SnmpWalkP14SNMP_TransportPKwPFjP13SNMP_VariableS0_PvES5_b)
2020.03.10 08:36:36.735 *E* [                   ] Unable to load module "/usr/local/lib/netxms/ndd/h3c.ndd" (/usr/local/lib/netxms/ndd/h3c.ndd: undefined symbol: _Z8SnmpWalkP14SNMP_TransportPKwPFjP13SNMP_VariableS0_PvES5_b)
2020.03.10 08:36:36.750 *I* [db.drv             ] Database driver "sqlite.ddr" loaded and initialized successfully
2020.03.10 08:36:37.474 *W* [                   ] Failed to compile transformation script for object www.event-log.com [204] DCI Dummy [428] (Error in line 2: syntax error, unexpected T_IDENTIFIER, expecting $end)
2020.03.10 08:36:37.486 *W* [                   ] Failed to compile transformation script for object motoren.event-log.com [206] DCI Dummy [433] (Error in line 2: syntax error, unexpected T_IDENTIFIER, expecting $end)
2020.03.10 08:36:37.534 *W* [                   ] Failed to compile transformation script for object nas.event-log.com [234] DCI Dummy [448] (Error in line 2: syntax error, unexpected T_IDENTIFIER, expecting $end)
2020.03.10 08:36:37.625 *W* [                   ] Failed to compile transformation script for object netxms.event-log.com [260] DCI Dummy [438] (Error in line 2: syntax error, unexpected T_IDENTIFIER, expecting $end)
2020.03.10 08:36:37.658 *W* [                   ] Failed to compile transformation script for object nodered.event-log.com [5688] DCI Dummy [903] (Error in line 2: syntax error, unexpected T_IDENTIFIER, expecting $end)
2020.03.10 08:36:37.756 *W* [                   ] Failed to compile transformation script for object vmcontroller.event-log.com [6551] DCI Dummy [3286] (Error in line 2: syntax error, unexpected T_IDENTIFIER, expecting $end)
2020.03.10 08:36:37.971 *W* [                   ] Failed to compile transformation script for object RAM Linux [789] DCI Dummy [423] (Error in line 2: syntax error, unexpected T_IDENTIFIER, expecting $end)
2020.03.10 08:36:37.971 *W* [                   ] Failed to compile transformation script for object LinuxHDD free [802] DCI Dummy [498] (Error in line 2: syntax error, unexpected T_IDENTIFIER, expecting $end)
2020.03.10 08:36:37.989 *I* [db.drv             ] Database driver "sqlite.ddr" loaded and initialized successfully
2020.03.10 08:36:38.621 *I* [                   ] Listening for SNMP traps on UDP socket 0.0.0.0:162
2020.03.10 08:36:38.621 *I* [                   ] Listening for SNMP traps on UDP socket :::162
2020.03.10 08:36:38.776 *I* [                   ] SocketListener/Clients: listening on 0.0.0.0:4701
2020.03.10 08:36:38.776 *I* [                   ] SocketListener/Clients: listening on [0.0.0.0]:4701
2020.03.10 08:36:38.776 *I* [                   ] NetXMS Server started
2020.03.10 08:36:38.777 *I* [                   ] SocketListener/AgentTunnels: listening on 0.0.0.0:4703
2020.03.10 08:36:38.777 *I* [                   ] SocketListener/AgentTunnels: listening on [0.0.0.0]:4703
2020.03.10 08:36:38.777 *I* [                   ] SocketListener/MobileDevices: listening on 0.0.0.0:4747
2020.03.10 08:36:38.777 *I* [                   ] SocketListener/MobileDevices: listening on [0.0.0.0]:4747
2020.03.10 08:36:38.781 *I* [                   ] Listening for syslog messages on UDP socket 0.0.0.0:514
2020.03.10 08:36:38.781 *I* [                   ] Listening for syslog messages on UDP socket :::514
2020.03.10 08:36:39.052 *W* [                   ] Failed to execute transformation script for object www.event-log.com [204] DCI Dummy [501] (Error 5 in line 3: Invalid operation with NULL value)
2020.03.10 08:36:39.052 *W* [                   ] Failed to execute transformation script for object www.event-log.com [204] DCI Dummy [522] (Error 4 in line 2: Bad arithmetic conversion)
2020.03.10 08:36:39.056 *W* [                   ] Failed to execute transformation script for object motoren.event-log.com [206] DCI Dummy [507] (Error 5 in line 3: Invalid operation with NULL value)
2020.03.10 08:36:39.056 *W* [                   ] Failed to execute transformation script for object motoren.event-log.com [206] DCI Dummy [520] (Error 4 in line 2: Bad arithmetic conversion)
2020.03.10 08:36:39.099 *W* [                   ] Failed to execute transformation script for object nas.event-log.com [234] DCI Dummy [515] (Error 5 in line 4: Invalid operation with NULL value)
2020.03.10 08:36:39.100 *W* [                   ] Failed to execute transformation script for object nas.event-log.com [234] DCI Dummy [519] (Error 4 in line 2: Bad arithmetic conversion)
2020.03.10 08:36:39.872 *W* [                   ] Failed to execute transformation script for object netxms.event-log.com [260] DCI Dummy [504] (Error 5 in line 3: Invalid operation with NULL value)
2020.03.10 08:36:39.872 *W* [                   ] Failed to execute transformation script for object netxms.event-log.com [260] DCI Dummy [521] (Error 4 in line 2: Bad arithmetic conversion)
2020.03.10 08:36:40.341 *W* [                   ] Failed to execute transformation script for object nodered.event-log.com [5688] DCI Dummy [902] (Error 5 in line 3: Invalid operation with NULL value)
2020.03.10 08:36:40.344 *W* [                   ] Failed to execute transformation script for object nodered.event-log.com [5688] DCI Dummy [914] (Error 4 in line 2: Bad arithmetic conversion)
2020.03.10 08:36:41.660 *W* [                   ] Failed to execute transformation script for object ELVMHost [5728] DCI Dummy [962] (Error 5 in line 3: Invalid operation with NULL value)
2020.03.10 08:36:41.660 *W* [                   ] Failed to execute transformation script for object ELVMHost [5728] DCI Dummy [963] (Error 5 in line 3: Invalid operation with NULL value)
2020.03.10 08:36:41.729 *W* [                   ] Failed to execute transformation script for object ELVMHost [5728] DCI Dummy [968] (Error 5 in line 3: Invalid operation with NULL value)
2020.03.10 08:36:41.741 *W* [                   ] Failed to execute transformation script for object vmcontroller.event-log.com [6551] DCI Dummy [3285] (Error 5 in line 3: Invalid operation with NULL value)
2020.03.10 08:36:41.746 *W* [                   ] Failed to execute transformation script for object vmcontroller.event-log.com [6551] DCI Dummy [3297] (Error 5 in line 3: Invalid operation with NULL value)
2020.03.10 08:36:41.746 *W* [                   ] Failed to execute transformation script for object vmcontroller.event-log.com [6551] DCI Dummy [3299] (Error 4 in line 2: Bad arithmetic conversion)
2020.03.10 08:36:41.746 *W* [                   ] Failed to execute transformation script for object vmcontroller.event-log.com [6551] DCI Dummy [3298] (Error 5 in line 5: Invalid operation with NULL value)

This was the Right hint! Thanks, after upgrading to the newest Version it is workiung again. Just have to sort out some minor Errors like
Failed to execute autobind script for object APC [6303] (Error 30 in line 13: Unknown object's method)  or
[260] DCI Dummy [438] (Error 5 in line 5: Invalid operation with NULL value) (think it has to do with the new Scripting. hav to put $1, $2 and so on in) or
Unable to load module "/usr/local/lib/netxms/ndd/netscreen.ndd"

OK, will try this tomorrow (today very bussy :-)) Thanks for you´re help