Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - Abraxas

#1
General Support / ExternalParameterShellExec error
July 25, 2022, 04:02:34 PM
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?
#2
General Support / HA setup with VRRPD
May 31, 2022, 02:01:26 PM
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
#3
Thank you, Viktor!
That worked just fine.
#4
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
#5
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
#6
General Support / Re: Free space on / reports wrong data
February 10, 2022, 11:45:28 AM
Thank you Filipp!
Wow, I can't believe this is the first time I see the "Process all thresholds" checkbox, and of course, it was unchecked. Time to review all monitored parameters with multiple thresholds.

Regarding the reservation, I was aware the OS has a reserved limit, but I always believed that's why I always see a bit less available space than df shows.
#7
General Support / Free space on / reports wrong data
February 07, 2022, 09:50:08 AM
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
#8
General Support / Re: node status
December 09, 2021, 05:11:24 PM
I have termianted manually the alarm, and things look ok. I did this to make sure I get alarms in case something happens with that box, but the issue is still there :(
status poll shows the node Normal now:
[09.12.2021 17:11:14] Node is connected
[09.12.2021 17:11:15] Finished status poll for node Dolion
[09.12.2021 17:11:15] Node status after poll is NORMAL
[09.12.2021 17:11:15] **** Poll completed successfully ****
#9
General Support / Re: node status
December 09, 2021, 04:38:42 PM
They were already on Ignore. I tried to delete them, and do a Configuration poll. I set them again on Ignore, but no change.
There are no errors in the server log.
#10
General Support / Re: node status
December 08, 2021, 02:39:19 PM
Thank you for the quick reply!

It only has the node down alarm, as in the attached screenshot.
It has 2 interfaces down, but those were down all the time. I tried to pus them on Ignore, but no luck.
#11
General Support / Re: node status
December 08, 2021, 11:56:07 AM
I have the same problem with nodes remaining down (no VPN involved though).
Node down/up works fine for all hosts monitored on the internal IP subnet, but for the ones that use public IPs (still with the agent), they remain down.
I have this node for example, that is reachable, polling its status looks ok:
[08.12.2021 11:46:38] **** Poll request sent to server ****
[08.12.2021 11:46:38] Poll request accepted
[08.12.2021 11:46:38] Starting status poll for node Dolion
[08.12.2021 11:46:38] Checking NetXMS agent connectivity
[08.12.2021 11:46:38]    Starting status poll on interface lo
[08.12.2021 11:46:38]       Current interface status is NORMAL
[08.12.2021 11:46:38]       Retrieving interface status from NetXMS agent
[08.12.2021 11:46:39]       Interface status retrieved from NetXMS agent
[08.12.2021 11:46:39]       Interface is NORMAL for 790 polls (1 poll required for status change)
[08.12.2021 11:46:39]       Interface status after poll is NORMAL
[08.12.2021 11:46:39]    Finished status poll on interface lo
[08.12.2021 11:46:39]    Starting status poll on interface eno1
[08.12.2021 11:46:39]       Current interface status is NORMAL
[08.12.2021 11:46:39]       Retrieving interface status from NetXMS agent
[08.12.2021 11:46:39]       Interface status retrieved from NetXMS agent
[08.12.2021 11:46:39]       Interface is NORMAL for 790 polls (1 poll required for status change)
[08.12.2021 11:46:39]       Interface status after poll is NORMAL
[08.12.2021 11:46:39]    Finished status poll on interface eno1
[08.12.2021 11:46:39]    Starting status poll on interface eno2
[08.12.2021 11:46:39]       Current interface status is DISABLED
[08.12.2021 11:46:39]       Retrieving interface status from NetXMS agent
[08.12.2021 11:46:39]       Interface status retrieved from NetXMS agent
[08.12.2021 11:46:39]       Interface is DISABLED for 754 polls (1 poll required for status change)
[08.12.2021 11:46:39]       Interface status after poll is DISABLED
[08.12.2021 11:46:39]    Finished status poll on interface eno2
[08.12.2021 11:46:39]    Starting status poll on interface enp0s20f0u8u3c2
[08.12.2021 11:46:40]       Current interface status is DISABLED
[08.12.2021 11:46:40]       Retrieving interface status from NetXMS agent
[08.12.2021 11:46:40]       Interface status retrieved from NetXMS agent
[08.12.2021 11:46:40]       Interface is DISABLED for 754 polls (1 poll required for status change)
[08.12.2021 11:46:40]       Interface status after poll is DISABLED
[08.12.2021 11:46:40]    Finished status poll on interface enp0s20f0u8u3c2
[08.12.2021 11:46:40] Node is connected
[08.12.2021 11:46:41] Finished status poll for node Dolion
[08.12.2021 11:46:41] Node status after poll is CRITICAL
[08.12.2021 11:46:41] **** Poll completed successfully ****

Any idea how to fix this?
#12
General Support / Re: Time Based Event Processing
May 17, 2021, 09:37:54 PM
Awesome, thank you!
I will try this.
#13
General Support / Time Based Event Processing
May 17, 2021, 03:34:09 PM
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
#14
Feature Requests / SMS through SMS vendors
December 09, 2020, 01:09:46 PM
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
#15
General Support / Re: User bandwidth per interval
July 30, 2019, 02:25:34 PM
Thank you for the reply Victor!
I will try the indicated solutions and see how it goes :)

Best regards,
Alex