NetXMS Support Forum

Hello

Unfortunately, there seems to be an issue with the Apple Management Console (2.0.2). When you run the console it reports that it 'is damaged and can't be opened.' I have tried on 2 Mac's so far, both (10.11.3).

Regards

Aron

Hello

We are experiencing with crashing netxms after the upgrade to 1.2.17. This generally happens after 10 minutes of loading, setting up the server for CrashDumpLog does not produce a log file for program crash. Running the server with debug mode 9 also does not give any clear indication before netxms stops. We have currently tried this on a windows instance and on a linux instance, both appear to have the same issue. The only current indication of issues are from;

[03-Dec-2014 08:57:48.626] [ERROR] SQL query failed (Query = "INSERT INTO alarm_events (alarm_id,event_id,event_code,event_name,severity,source_object_id,event_timestamp,message) VALUES (?,?,?,?,?,?,?,?)"): Duplicate entry '405363-30146854' for key 'PRIMARY'
[03-Dec-2014 08:57:48.639] [ERROR] SQL query failed (Query = "INSERT INTO alarm_events (alarm_id,event_id,event_code,event_name,severity,source_object_id,event_timestamp,message) VALUES (?,?,?,?,?,?,?,?)"): Duplicate entry '405363-30146855' for key 'PRIMARY'
[03-Dec-2014 08:57:48.668] [ERROR] SQL query failed (Query = "INSERT INTO alarm_events (alarm_id,event_id,event_code,event_name,severity,source_object_id,event_timestamp,message) VALUES (?,?,?,?,?,?,?,?)"): Duplicate entry '405941-30146859' for key 'PRIMARY'
[03-Dec-2014 08:57:48.695] [ERROR] SQL query failed (Query = "INSERT INTO alarm_events (alarm_id,event_id,event_code,event_name,severity,source_object_id,event_timestamp,message) VALUES (?,?,?,?,?,?,?,?)"): Duplicate entry '405941-30146862' for key 'PRIMARY'
[03-Dec-2014 08:57:48.714] [ERROR] SQL query failed (Query = "INSERT INTO alarm_events (alarm_id,event_id,event_code,event_name,severity,source_object_id,event_timestamp,message) VALUES (?,?,?,?,?,?,?,?)"): Duplicate entry '405363-30146864' for key 'PRIMARY'
[03-Dec-2014 08:57:48.725] [ERROR] SQL query failed (Query = "INSERT INTO alarm_events (alarm_id,event_id,event_code,event_name,severity,source_object_id,event_timestamp,message) VALUES (?,?,?,?,?,?,?,?)"): Duplicate entry '406032-30146865' for key 'PRIMARY'
[03-Dec-2014 08:57:48.737] [ERROR] SQL query failed (Query = "INSERT INTO alarm_events (alarm_id,event_id,event_code,event_name,severity,source_object_id,event_timestamp,message) VALUES (?,?,?,?,?,?,?,?)"): Duplicate entry '405363-30146866' for key 'PRIMARY'

We have made no amendments to the Database structure. Deleting the content of the alarm_events table completely makes no difference. 'nxdbmgr check' passes all the current checks.

Not to sure what the next step should be. Not particularly clear how the BIGINT is shown as a hyphenated number?

Regards

Aron

Hello

We have a very interesting automation/management challenge. We have a requirement to pull out a value from a LDAP server. We have currently implemented as below;

ExternalParameterShellExec=LdapQuery(*):/home/access/ldap.sh $1 $2 $3 $4

which in turn executes;

ldapsearch -P 2 -D Username -h $1 -w $2 -s sub "(objectclass=XXX)" -b "GUID=$3" -LL $4 | grep "$4" | sed "s/$4: //"

However it is deploying the DCI's to the nodes which I can not think of an effective way of doing. We would like a way of managing the TemplatedDCI and Thresholds globally but with local variables configured in the Node. The nodes are currently deployed in a template group which applies other DCI's. All the Nodes that the template is assigned against are networking equipment which can not run nxagentd. The volume of Nodes/DCI's that are needed to be created and maintained would make would make it infeasible to try and do manually.

The two approaches that I can think of doing this would be with a DCI like;
LdapQuery(GetCustomAttribute("ip"),GetCustomAttribute("user"),GetCustomAttribute("GUID"),GetCustomAttribute("value")) and having this run on the unit with the LdapQuery configuration set.

But this understandably it did not expect a nested function to be called.

Or alternatively run it as internal/Dummy and in the script get the CustomAttribute. However I am not sure of a way to call the LdapQuery function remotely.

Wondered if anyone else was aware of a different approach?

Regards

Aron

Hello

Below is a functional implementation of SQL Replication Monitoring. I understand that there will be a cleaner solution in future: https://www.netxms.org/forum/general-support/using-netxms-to-monitor-mysql-replication-status-and-progress/msg11314/#msg11314

However in the mean time;

agent config needs the following line;

ExternalParametersProvider=mysql -uuser --host=ipaddress -ppassword --execute "SHOW slave status\G" | sed 's/ //g;s/:/=/g;s/^/SqlSlave./':60


DCI Collection will be avaliable for all the slave status commands prefixed with SqlSlave. IE SqlSlave.Slave_IO_Running and SqlSlave.Slave_SQL_Running.

Hopefully will save some time for someone else trying to achieve the same

Hello

I have been trying to think of effective solutions for integration of IPMI into NetXms for effective Management and alarming. Obtaining the information can be done fairly effectively with FreeIPMI.

ubuntu:~$ ipmi-sensors --hostname=10.10.10.10 --username=user --password=password  -D LAN_2_0 -b --comma-separated-output -q
ID,Name,Type,Event
1,UID Light,OEM Reserved,'OEM Event = 0000h'
2,Int. Health LED,OEM Reserved,'OEM Event = 0000h'
3,Ext. Health LED,OEM Reserved,'OEM Event = 0000h'
4,Power Supply 1,Power Supply,'Presence detected'
5,Power Supply 2,Power Supply,'Presence detected'
6,Power Supplies,Power Supply,'Fully Redundant'
8,VRM 1,Power Unit,'Device Inserted/Device Present'
9,VRM 2,Power Unit,'Device Inserted/Device Present'
10,Fan Block 1,Fan,'transition to Running'
11,Fan Block 2,Fan,'transition to Running'
12,Fan Block 3,Fan,'transition to Running'
13,Fan Blocks,Fan,'Fully Redundant'
15,Temp 1,Temperature,'OK'
16,Temp 2,Temperature,'OK'
17,Temp 3,Temperature,'OK'
18,Temp 4,Temperature,'OK'
19,Temp 5,Temperature,'OK'
20,Temp 6,Temperature,'OK'
21,Temp 7,Temperature,'OK'
22,Power Meter,Current,'Device Enabled'

However getting the information into netxms effectively is where I am drawing a blank. My preferred approach would be run as an ExternalCommand, but instead of the information returning a singular value the output would be consumed into the new Table functionality. This would allow for scripting to dynamically query the information and alarm as required.

However I am not sure if there is another/easier way to achieve the same goals?

Regards

Aron

Hello

We are in the process of provisioning drbd and was looking to use nxagent to monitor it. It appears that the drbd status no longer matches with the expected regex strings in the agent.

I will try see if I can find the correct implementation string.

Regards

Example from: http://www.drbd.org/users-guide-8.3/s-first-time-up.html

cat /proc/drbd
version: 8.3.0 (api:88/proto:86-89)
GIT-hash: 9ba8b93e24d842f0dd3fb1f9b90e8348ddb95829 build by buildsystem@linbit, 2008-12-18 16:02:26
1: cs:Connected ro:Secondary/Secondary ds:Inconsistent/Inconsistent C r---
    ns:0 nr:0 dw:0 dr:0 al:0 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:b oos:200768

Live from a deployment;
cat /proc/drbd
version: 8.3.11 (api:88/proto:86-96)
srcversion: 21CA73FE6D7D9C67B0C6AB2

1: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r-----
    ns:1081844 nr:0 dw:33336 dr:1051434 al:13 bm:64 lo:0 pe:0 ua:0 ap:0 ep:1 wo:f oos:0

Hello

Unfortunately there does not appear to be a binary build for the MAC client client on the download section.

Sorry if this has already been flagged.

Regards

Aron

Hello

Unfortunatley I have experienced a few crashes since the upgrade to 1.2.5. The crashes have not been anything clear cause and effect. Please find attached the .info from the crash dumps. Unsure of the content of the .mdmp files and if there would be any security implications of posting these publicly.

Kind regards

Aron

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

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

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

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

I am experiencing a strange issue with SNMP proxy functionality within the server. We have a fairly distributed deployment and rely on the SNMP Proxy functionality quite heavily. After a period of about a day the SNMP proxy functionality will lock up with no clear explanation or error (that I can find but still fairly new to the system), the snmp proxy functionality is not locking up on a remote per agent basis and seems to be global to all remote agents (6-8 remote instances). If the poller/configuration proxy flags are removed on the object it will correctly poll that agent. I have increase the logging on a remote agent instances and can still see the agent receiving requests from the server, tcpdump confirms that the remote agent is doing icmp polls but not snmp requests. From a server perspective there are no outstanding requests in show queue and the show pollers does not show a locked poller for the non-responding instances.

Sorry I am a little unsure what additional information would be constructive to help identified the issue.

Regards

Aron

Hello

We are currently rolling out the NetXms system internally to our servers which has gone well until we have got to the older versions of windows. The server in question is Windows 2000 SP4.

Currently after installing when running the agent the system reports the following error:
nxagentd.exe - Entry Point not found;

The procedure entry point GetVolumePathNamesForVolumeNameA could not be located in KERNEL32.dll

Any assistance would be greatly received.

Regards

Aron