NetXMS Support Forum

Hello

We have added a ping standard deviation calculations into our internal deployment. I have attached the patch file from the current svn build incase you wanted to incorporate this into the trunk.

Regards

Aron

Thank you, not to urgent. So happy to wait for the next build.

Regards

Aron

Hello

Sorry this is for the console, not as a remote agent. My intention was to have a login ability more along the lines of the below;

nxmc -u User -p Password -start Dashboard.StartupDash

or

http://192.168.1.100/?username=User&password=Password&startup=Dashboard.StartupDash

Regards

Aron

Hello

We are looking to deploy a Raspberry Pi to be used for an unattended wallboard unit. The query I have is there any auto login functionality either on the WebPortal or the Client that could be used to automatically log the client in and once connected display a specific Dashboard?

Regards

Aron

Hello,

Thank you that has worked

Many Thanks

Aron

Below is from package;

access@ubuntu:~$ sudo ldd /usr/lib/libnsm_odbcquery.so
[sudo] password for access:
        linux-gate.so.1 =>  (0xb7829000)
        libnetxms.so.1 => /usr/lib/libnetxms.so.1 (0xb77f3000)
        libtre.so.5 => /usr/lib/libtre.so.5 (0xb77e3000)
        libexpat.so.1 => /lib/libexpat.so.1 (0xb77bb000)
        libz.so.1 => /lib/libz.so.1 (0xb77a6000)
        libdl.so.2 => /lib/libdl.so.2 (0xb77a2000)
        libcrypto.so.0.9.8 => /lib/libcrypto.so.0.9.8 (0xb7653000)
        libpthread.so.0 => /lib/libpthread.so.0 (0xb7639000)
        libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb754e000)
        libm.so.6 => /lib/libm.so.6 (0xb7527000)
        libc.so.6 => /lib/libc.so.6 (0xb73ca000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb73ae000)
        /lib/ld-linux.so.2 (0xb782a000)

Below built from the svn trunk;
sudo ./configure --with-agent --with-odbc --prefix=/usr


access@ubuntu:/usr/lib$ sudo ldd /usr/lib/libnsm_odbcquery.so
        linux-gate.so.1 =>  (0xb7840000)
        libnetxms.so.1 => /usr/lib/libnetxms.so.1 (0xb7809000)
        libdl.so.2 => /lib/libdl.so.2 (0xb7805000)
        libpthread.so.0 => /lib/libpthread.so.0 (0xb77ea000)
        libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb76ff000)
        libm.so.6 => /lib/libm.so.6 (0xb76d9000)
        libc.so.6 => /lib/libc.so.6 (0xb757c000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb7560000)
        libnxexpat.so.1 => /usr/lib/libnxexpat.so.1 (0xb7540000)
        libnxtre.so.5 => /usr/lib/libnxtre.so.5 (0xb752f000)
        /lib/ld-linux.so.2 (0xb7841000)

[24-Sep-2012 19:07:36] Subagent "/usr/lib/libnsm_ping.so" loaded successfully
[24-Sep-2012 19:07:37] Subagent "/usr/lib/libnsm_logwatch.so" loaded successfully
[24-Sep-2012 19:07:37] Subagent "Linux" already loaded from module "/usr/lib/libnsm_linux.so"
[24-Sep-2012 19:07:37] Subagent "/usr/lib/libnsm_ecs.so" loaded successfully
[24-Sep-2012 19:07:37] Error loading subagent module "/usr/lib/libnsm_odbcquery.so": /usr/lib/libnsm_odbcquery.so: undefined symbol: SQLFetch

Best Regards

Aron

Hello

Unfortunately I am experiencing issues getting unixodbc working correctly with nxagentd.

On load it is reporting the following issues;

1-Sep-2012 13:41:56] Subagent "/usr/lib/libnsm_logwatch.so" loaded successfully
[21-Sep-2012 13:41:56] Subagent "Linux" already loaded from module "/usr/local/lib/libnsm_linux.so"
[21-Sep-2012 13:41:56] Subagent "/usr/lib/libnsm_ecs.so" loaded successfully
[21-Sep-2012 13:41:56] Error loading subagent module "/usr/lib/libnsm_odbcquery.so": /usr/lib/libnsm_odbcquery.so: undefined symbol: SQLBindCol
[21-Sep-2012 13:41:57] External parameters providers poller thread will not start
[21-Sep-2012 13:41:57] Trying to bind on 0.0.0.0:4700

I have tested the ODBC deployment using isql and it correctly queries the DSN. Unfortunately I have been unsuccessful in working out if there is a dependancy issue. Version unixODBC 2.2.14. Sorry I am unsure which additional information will be constructive.

Regards

Aron

Hello

Many thanks, is now running successfully on the patched version.

Best Regards
Aron

Hello

We were in the process of upgrading from 1.2.2 to 1.2.3 in our deployment and unfortunately run into problems (Win7 32Bit). Downgraded netxms server back to 1.2.2, deployed the 1.2.3 on Win2K  server and had the same result. Looking at the debugs below, I cleared the database and re-initialised the database. Netxms would then run successfully. I have had a look at the table which it was querying and there is nothing particularly interesting, totalrow count was around 300000 and the itemid rowcount being queried was 4290. I am comfortable that the mysql instance is good as this has been live in the 1.2.2 installation and is still good subsequent to the downgrade.

Sorry I am not sure which additional information might be constructive?

Aron

Problem signature:
  Problem Event Name:   APPCRASH
  Application Name:   netxmsd.exe
  Application Version:   0.0.0.0
  Application Timestamp:   504f151c
  Fault Module Name:   MSVCR80.dll
  Fault Module Version:   8.0.50727.6195
  Fault Module Timestamp:   4dcddbf3
  Exception Code:   c0000005
  Exception Offset:   000149d1
  OS Version:   6.1.7601.2.1.0.256.48
  Locale ID:   2057
  Additional Information 1:   0a9e
  Additional Information 2:   0a9e372d3b4ad19135b953a78882e789
  Additional Information 3:   0a9e
  Additional Information 4:   0a9e372d3b4ad19135b953a78882e789

Debug Version 8

[11-Sep-2012 16:46:23] Loading VPN connectors...
[11-Sep-2012 16:46:23] Loading clusters...
[11-Sep-2012 16:46:23] Loading templates...
[11-Sep-2012 16:46:24] Loading agent policies...
[11-Sep-2012 16:46:24] Loading network maps...
[11-Sep-2012 16:47:25] AccountStatusUpdater: wakeup

Debug Version 9

[12-Sep-2012 19:31:50] Successful async query: "SELECT idata_value,idata_timestamp FROM idata_8594 WHERE item_id=3000 ORDER BY idata_timestamp DESC LIMIT 1" [187 ms]
[12-Sep-2012 19:31:50] Successful async query: "SELECT idata_value,idata_timestamp FROM idata_8594 WHERE item_id=3424 ORDER BY idata_timestamp DESC LIMIT 1" [94 ms]
[12-Sep-2012 19:31:51] Successful async query: "SELECT idata_value,idata_timestamp FROM idata_8594 WHERE item_id=3425 ORDER BY idata_timestamp DESC LIMIT 1" [188 ms]
[12-Sep-2012 19:32:04] Successful async query: "SELECT idata_value,idata_timestamp FROM idata_8594 WHERE item_id=3426 ORDER BY idata_timestamp DESC LIMIT 1" [13655 ms]

Hello

Since moving the Netxms we have loved all the net features and stability of the system. However there is one thing that which I believe would be a good addition to the system.

Allot of the information we investigate tends to be throughput related on a multiple network switches/routers, unfortunately we have not found a way to constructively display the information in graphs/alarms. It would be beneficial if the network maps could have the addition of DCI collected information, i.e. the throughput of interfaces. I have attached a demo screen from the previous system. This would allow a cross-section of information to be displayed in a easy to understand logic way.

Regards

Aron

Hello

Sorry if this is a repost but we are experiencing and issue with DCI history corruption. We have a script which will update a custom attribute and the DCI will return the latest value of the CustomAttribute.

DCI: Param=Dummy, Origin=Internal, DataType=String, Interval=60 Seconds, Transformation (no delta);
return GetCustomAttribute($node,"PacketLossMaxName");

The last value is showing correctly, other historical records are showing mostly null type entries with some showing incorrect date and/or values.

Regards

Aron

Hello

Unfortunately we are experiencing a problem with Nxagentd on a windows server. The agent will run successfully however at the moment the ODBC subagent seems to stop after around 12 hours or so. The log is reporting;

[06-Aug-2012 14:57:43] ODBC connect error: Failed to set ODBC version ([MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '10.30.0.151' (10060))
[06-Aug-2012 14:57:49] ODBC connect error: Failed to set ODBC version ([MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '10.30.0.151' (10060))
[06-Aug-2012 14:57:54] ODBC connect error: Failed to set ODBC version ([MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '10.30.0.151' (10060))
[06-Aug-2012 14:57:55] ODBC connect error: Failed to set ODBC version ([MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '10.30.0.151' (10060))
[06-Aug-2012 14:57:57] ODBC connect error: Failed to set ODBC version ([MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '10.30.0.151' (10060))
[06-Aug-2012 14:57:57] ODBC connect error: Failed to set ODBC version ([MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '10.30.0.151' (10060))
[06-Aug-2012 14:57:59] ODBC connect error: Failed to set ODBC version ([MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '10.30.0.151' (10060))

If you go into the ODBC and test connection the test reports as succesfull. The NXAgent is working successfully for all other probes that is configure to be done (LogWatch, Ping, etc). Restart of the Nxagent service sucessfully resolves the issue until the same error will return.

Regards

Aron

Hello,

Thank you for the build. Provisionally looks good, running as expected and memory usage is stable with no obvious signs of the issue.

Many thanks

Aron

Hello

Tracing information shows the bulk of the missing memory from the following area;

==26275== 129 bytes in 3 blocks are definitely lost in loss record 711 of 813
==26275==    at 0x4C2B6CD: malloc (in /usr/lib/valgrind/vgpreload_memcheck-amd64-linux.so)
==26275==    by 0x5077C61: SNMP_ProxyTransport::readMessage(SNMP_PDU**, unsigned int, sockaddr*, unsigned int*, SNMP_SecurityContext* (*)(sockaddr*, unsigned int)) (snmpproxy.cpp:101)
==26275==    by 0x68A3FA2: SNMP_Transport::doRequest(SNMP_PDU*, SNMP_PDU**, unsigned int, int) (transport.cpp:127)
==26275==    by 0x50771BB: SnmpGet(unsigned int, SNMP_Transport*, char const*, unsigned int const*, unsigned int, void*, unsigned int, unsigned int) (snmp.cpp:79)
==26275==    by 0x535C9F1: SnmpGetInterfaceStatus(unsigned int, SNMP_Transport*, unsigned int, int*, int*) (snmp.cpp:108)
==26275==    by 0x531A4EB: Node::getInterfaceStatusFromSNMP(SNMP_Transport*, unsigned int, int*, int*) (node.cpp:3058)
==26275==    by 0x52FA00D: Interface::StatusPoll(ClientSession*, unsigned int, Queue*, int, SNMP_Transport*) (interface.cpp:373)
==26275==    by 0x5313A80: Node::statusPoll(ClientSession*, unsigned int, int) (node.cpp:1201)
==26275==    by 0x533124B: StatusPoller(void*) (poll.cpp:273)
==26275==    by 0x55B5E99: start_thread (pthread_create.c:308)
==26275==    by 0x58BD4BC: clone (clone.S:112)

Reading the code I have a made a guess that pBuffer is not free'ed in SNMP_ProxyTransport::readMessage. Adding this to the function has stopped the report of this leak. Unfortunately I am not able to build a windows version to confirm in the live environment.

Regards

Aron

Hello

A quick update on this is that investigation is continuing to go slowly. Upgrade to 1.2.2 has had no affect on the issue. Investigation with valgrind has reported allot of issues which I will look into to confirm that they are actually the cause of the leaks.

Recent incidents on out internal system where we were unable to contact a heavily used Remote NX agent on Unbuntu (currently v1.2.2) resulted in the system running for longer before it run out of memory. The agent is predominantly doing ICMP and SNMP proxy requests.

Regards

Aron