NetXMS Support Forum

Hello

Just incase someone downloads, and attempts to use previous report. It seems to be out of date and the Database structure is now different. Attached is the report with the updated SQL for IP Addressing being in interface_address_list table.

Most recent guide with current build instructions (Since report-generator was removed): https://www.netxms.org/forum/installation/install-report-server/.

This contains current (un-built) reports and instructions on how they can be built.

Regards

Aron

Hello

I was hoping to confirm my assumptions of what the Reporting Server does and does not do.

The Reporting Server is responsible for taking Pre-Written Reports and generating the Report / Email with the report contents.
The Netxms Console / Manager is how NetXms can configure the reporting server with the Date/Times/Email Addresses that it will use generate / send the report.

Neither programs will create a new Report. To create a report, it would need to be manually written or using the JasperReports designer. This would then be 'generated' this is done using Maven and put into the definitions folder (/opt/nxreporting/workspace/definitions). When the reporting server starts it will load these from definition folder. That is when the Report would appear in the NetXms console / reporting server.

I have not been able to explicitly get the above working at the moment. As such I am hoping that someone will be able to confirm if this is how the components link together?

Thanks

Aron

JasperReport file: Attached and referenced: https://wiki.netxms.org/wiki/UM:Objects#Report
Report Building: https://www.netxms.org/forum/installation/install-report-server/
Wiki Reference to the reporting Server: https://www.netxms.org/documentation/adminguide/reporting.html

*Modified: Due to Report-Generator being removed.

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

I have also been looking to get this up and working. I have had problems with an existing live deployment, and also a fresh install (2.0.2).

On a live deployment (also 2.0.2, upgraded many times in the past) it appears not to be able to access the database.

On a fresh install I was able to get the reporting server running by installing some additional SQL triggers that were missing. Attached from (http://svn.terracotta.org/svn/quartz/oldtrunk/docs/dbTables/tables_mysql.sql). However, I am still am not currently able to configure a report up. I am still investigating.

Note: I do not know if running the SQL on a 'Production' Deployment would result in data loss as it drops the tables before re-creating them.

It might help.

Thank you,

Will apply the fix now.

Regards

Aron

Hello

Found a core dump for which I have a backtrace of, awaiting the gdb version to run and provide a live version;

(gdb) bt
#0  Node::topologyPoll (this=0xcbd8090, pSession=0x0, dwRqId=0, nPoller=115) at node.cpp:5329
#1  0xb7666ba1 in TopologyPoller (arg=0x73) at poll.cpp:586
#2  0xb7335d4c in start_thread () from /lib/i386-linux-gnu/libpthread.so.0
#3  0xb6f999de in clone () from /lib/i386-linux-gnu/libc.so.6
(gdb) bt full
#0  Node::topologyPoll (this=0xcbd8090, pSession=0x0, dwRqId=0, nPoller=115) at node.cpp:5329
        peerNode = 0x0
        ifaceFound = <optimized out>
        iface = 0x18eb61d8
        i = <optimized out>
        fdb = <optimized out>
        nbs = 0xa26a7f60
#1  0xb7666ba1 in TopologyPoller (arg=0x73) at poll.cpp:586
        node = 0xcbd8090
        szBuffer = L"poll: BLC-SW1 [110]\000]\000 [50574]\000]\000\000\060]\000]", '\000' <repeats 89 times>
#2  0xb7335d4c in start_thread () from /lib/i386-linux-gnu/libpthread.so.0
No symbol table info available.
#3  0xb6f999de in clone () from /lib/i386-linux-gnu/libc.so.6
No symbol table info available.
(gdb) thread apply all bt

Summary look at the node does not imply any particular issue;
Seems to be un-connected with the other SQL errors which are happening -D5

[03-Dec-2014 11:40:44.198] [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-30157884' for key 'PRIMARY'
[Thread 0xa5107b40 (LWP 28681) exited]
[03-Dec-2014 11:40:44.272] [DEBUG] EVENT 52 (ID:30157885 F:0x0001 S:4 TAG:"") FROM Ldn-NetXMS: Database query failed (Query: INSERT INTO alarm_events (alarm_id,event_id,event_code,event_name,severity,source_object_id,event_timestamp,message) VALUES (?,?,?,?,?,?,?,?); Error: Duplicate entry '405363-30157075' for key 'PRIMARY')
[Thread 0x824fcb40 (LWP 27788) exited]

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

Thank you, have applied successfully with the AgentReadParameter.

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

       if (regcomp(&pregVersion, "version: (.*) \\(api\\:([0-9].*)\\/proto\\:([0-9\\-].*)\\)", REG_EXTENDED) != 0)
                return false;


        if (regcomp(&pregDevice, "^[[:space:]]*([0-9]+)\\: cs\\:(.*) ro\\:(.*)\\/(.*) ds\\:(.*)\\/(.*) ([A-Z]).*", REG_EXTENDED) != 0)


This works with the exception of proto:86-89 reporting that it is 86. However trying to implement [//d-] or it does not seem to get the extended value. However to a large extent it is now working.

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