NetXMS Support Forum

Hi,
I've bene using NetXMS for a long time, but I recently moved to a new set of servers and rain into some strange problems.
I have the following script:
#! /bin/bash
LOG_FILE="/var/log/rating_engine.log"
STATE=`/etc/init.d/vrrpd show_state`;
if [[ ! -f "/tmp/ccup_running.lock" ]]; then
  if [ "$STATE" = "State is master." ]; then
          LAST_RUN=`tac $LOG_FILE | grep -m 1 "Billing ended" | tr -s ' ' | cut -d ' ' -f 1,2`
          LAST_RUN_DATE=$(date -ud "$LAST_RUN" +'%s')
          CURRENT_DATE=`date +%s`
          TIME_DIFF=$((CURRENT_DATE-LAST_RUN_DATE))

          if [ $TIME_DIFF -gt 180 ];then
                  echo "1"
          else
                  echo "0"
          fi
  else
          echo "0"
  fi
else
  echo "0"
fi
The script returns 0 or 1, as needed, but on the NetXMS server I only have 0s

In all older versions it has been working fine. On the new ones (NetXMS Core Agent Version 4.1.333 Build 4.1-333-gf37ab67d18 (UNICODE) in this case), the server always sees 0.
When I try nxget from the server, I get:

tac: write error: Broken pipe

Also I noticed the when I try to add this as a new parameter for that node, I see the data type as "string" I am returning 0 or 1, and used to set these as Integer. How can I change the data type from the agent?

Hi,

I am trying to build a HA setup, but a bit different than what was described in the tutorial. I want it to be consistent with our other deployments.
We use VRRPd to load a VIP between 2 hosts. I setup MySQL with master-master replication between the 2 boxes, and when the VIP move takes place, a script clears the DB lock and starts the netxms daemon on the new master. The problem I am facing is that netxms binds to the primary  IP of the box, not the VIP.

How can I make it use the VIP, or where to clean it in the DB so that the new server does not complain it can't bind to it?

Best regards,
Alex

Hi,

I am trying to upgrade the DB, and I am using Mysql8.
Here is what I get:
nxdbmgr upgrade -t
NetXMS Database Manager Version 4.1.283 Build 4.1-283-g624f7b1b4c (UNICODE)

Upgrading database...
Upgrading from version 22.22 to 22.24
>>> ALTER TABLE object_properties ADD state_before_maint integer
>>> ALTER TABLE dct_threshold_instances ADD row_number integer
SQL query failed (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'row_number integer' at line 1):
ALTER TABLE dct_threshold_instances ADD row_number integer
Rolling back last stage due to upgrade errors...
Database upgrade failed
>>> SELECT var_value FROM metadata WHERE var_name='PendingOnlineUpgrades'

I know row_number is a reserved word in 8, but I don't know how to edit the ALTER statement and put ` characters around it in order to continue.

Can't figure if there's anything I can do from metadata:
select * from metadata;
+-----------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| var_name                    | var_value                                                                                                                                                                                            |
+-----------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| IDataIndexCreationCommand_0 | CREATE INDEX idx_idata_%d_id_timestamp ON idata_%d(item_id,idata_timestamp DESC)                                                                                                                     |
| IDataTableCreationCommand   | CREATE TABLE idata_%d (item_id integer not null,idata_timestamp integer not null,idata_value varchar(255) null)                                                                                      |
| LocationHistory             | CREATE TABLE gps_history_%d (latitude varchar(20), longitude varchar(20), accuracy integer not null, start_timestamp integer not null, end_timestamp integer not null, PRIMARY KEY(start_timestamp)) |
| PendingOnlineUpgrades       |                                                                                                                                                                                                      |
| SchemaVersion               | 700                                                                                                                                                                                                  |
| SchemaVersionMajor          | 22                                                                                                                                                                                                   |
| SchemaVersionMinor          | 22                                                                                                                                                                                                   |
| ServerID                    | 2D29B5BE09DEAAD1                                                                                                                                                                                     |
| Syntax                      | MYSQL                                                                                                                                                                                                |
| TDataIndexCreationCommand_0 | CREATE INDEX idx_tdata_%d ON tdata_%d(item_id,tdata_timestamp)                                                                                                                                       |
| TDataTableCreationCommand_0 | CREATE TABLE tdata_%d (item_id integer not null,tdata_timestamp integer not null,tdata_value longtext null)                                                                                          |
+-----------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
11 rows in set (0.00 sec)


Thank you,
Alex

Hi,
I have a few nodes with older agents, and the server (4.0.2088) keeps applying the new template, resulting in a bunch of unsupported DCIs, like in the attached screenshot.

How should I proceed to get rid of these?

Thank you,
Alex

Hi,
I have a Debian server with nxagent on it. There was a trace running that filled the / partition to 100%.
NetXMS was configured to trigger the most important alarm at 1% free space, but it never triggered. When I checked the logged data, the agent never reported the free percentage below 5%, as in the attached graph.
After freeing up space (it has not about 78% free space), nxagent reports it ok. Any idea what can cause this and how to fix it?

And I also have a second issue with this: I actually have 2 data collection items for root disk space, and on the other one, there were 3 thresholds: 16%, 10% and 8%. The 16% threshold was reached and got triggered, but the other 2 did not, even though the free space % went a bit below 5% (instead of 0, as mentioned above).

Thank you,
Alex

Hi,

Is there a way to configure an event processing to behave differently based on the time?
Besides the normal alarms we have, I was trying to setup new ones that should trigger only during the night for example, when there is nobody to check email/sms messages. So basically I wanted to add a new event processing policy, for a particular event, but it should only trigger if the event is raised between 00 and 8 am for example.
I hope this can be done through the filtering script, but I was not able to find how to do that.

Thank you,
Alex

Hi,

We have been using text2reach for a few years now, and it has been working fine.
We already have an SMS platform we use for other purposes (https://www.alarislabs.com/messaging). They support multiple protocols and APIs:
             - Support for all relevant messaging protocols: SMPP, SIGTRAN, HTTP, RCS, UCP, ParlayX
             - A variety of APIs to OTTs (Viber, WhatsApp, Telegram, etc)

I am looking for a way to send our messages through Alaris in order to decrease the costs associated with the monitoring alarms. Any way we can accomplish this?

Thank you,
Alex

Hi,

I am trying to find a way to monitor the used bandwidth for several devices (how much IN and OUT data has been used over time). I would like to see the bandwidth used per day/week/month, one one or if possible multiple interfaces of the device.
We have some usage limitations on certain devices, and i need to make sure we don't use more than allocated.

Is there a way to get this configured?

Thank you,
Alex

Hi,

I am looking for a way to generate alarms when the values of a monitored resource drop below certain values compared to what is expected at that time.
To be more precise: I am monitoring the number of sessions on a server (or the bandwidth usage on an interface). The volume fluctuates during the day, being way lower during the nights, but it repeats daily in about the same shape (like a sinus graph).
I would like to raise an alarm if the values drop below a certain value normal for that time of day (like if normally the lowest value at night is 400, to raise an alarm when it drops below 250 or something like this; while during the day is should drop below let's say 2000).

The only way I see this doable so far is by creating 1 data collection with custom schedule that runs once or a few times in each interval I want to set a stable threshold. This is not elegant and neither easy to scale/maintain, so I was hoping you guys have a better way to handle this...

Thanks,
Alex

Hi,

I would love to use the SMS feature of NetXMS, but as far as I can see the web driver works only with websms.ru, and they only have a russion version of the site.
Is there any otehr provider this driver works with (one that has an english site hopefully)?

Thanks,
Alex

Hi,

I recently installed NetXMS. I configured the DCIs for 2 hosts, and they seem to be gathering data correctly (I see the values in history). When I try to generate Line Charts with them though, the charts are empty. I attached a few screenshots with what I get.
Am I missing something?

Thank you!