NetXMS Support Forum

Can you connect to the instance remotely via SQL Management Studio.  I believe you have to allow  remote access and make sure its able to listen on the default 1433 port   

Sounds good.. Thank you

I'm wondering if the back up process differs when using the Timescale extension ?  will nxdbmgr export capture the database + data or is there a better method.


Thanks

Desktop client with no fancy high dpi monitor. The weird thing is the geomap is spost on its only the Network maps that are off when trying to use the coorrdinates as a background

When trying to set the map background using Geographic Map the coordinates are way off.  I have even taken the coordinates listed in the World map and tried to use those but they are still  of compared to the world map.  The world map does match exactly what google maps shows so I know that is working.  Does the map background use a different coordinate system ?


Thanks

So is this just a bug then ?

I did try a simpler command which did not have the brackets and it did not work either.. Good Idea though

I have some mikrotik wireless devices that I need to monitor signal strength and SNR  and because of the odd way the Mikrotik MIBS are formatted and having to know the connected clients mac in order to retrieve that info from the registration table via snmp i decided to do it over ssh but it always fails on the Mikrotik device.  I have tested the commands from the server using the native ssh client and everything works.  I have also setup a laptop and simple dci with uname -a command and that is successful it just does not like the Miktotik response for some reason.  Below are the responses any suggestions are much appreciated.

Successful Laptop Response:

] Received message CMD_GET_PARAMETER (139)
2021.09.28 09:18:51.107 *D* [comm.cs.1          ] Requesting metric "SSH.Command(x.x.x.x:22,"user","pass","uname -a","",0)"
2021.09.28 09:18:51.107 *D* [ssh                ] AcquireSession: acquired existing session [email protected]:22/1
2021.09.28 09:18:51.114 *D* [comm.cs.1          ] GetParameterValue("SSH.Command(x.x.x.x:22,"user","pass","uname -a","",0)"): 0 (SUCCESS) value = "Linux Yakco 5.11.6-arch1-1 #1 SMP PREEMPT Thu, 11 Mar 2021 13:48:23 +0000 x86_64 GNU/Linux"
2021.09.28 09:18:51.114 *D* [comm.cs.1          ] Sending message CMD_REQUEST_COMPLETED (ID 139; size 128; compressed)
2021.09.28 09:18:51.114 *D* [comm.cs.1          ] Outgoing message dump:


Unsuccessful Mikrotik Response:
* I changed the command to only return the identity to simplify things

Received message CMD_GET_PARAMETER (1736)
2021.09.28 09:27:56.486 *D* [comm.cs.1          ] Requesting metric "SSH.Command(x.x.x.x:22,"user","pass",":put [/system identity get name]","",0)"
2021.09.28 09:27:56.486 *D* [ssh                ] AcquireSession: acquired existing session [email protected]:22/2
2021.09.28 09:27:56.494 *D* [ssh                ] SSHSession::execute: read error:
2021.09.28 09:27:56.494 *D* [ssh                ] SSH output is empty
2021.09.28 09:27:56.494 *D* [comm.cs.1          ] GetParameterValue("SSH.Command(x.x.x.x:22,"user","pass",":put [/system identity get name]","",0)"): 500 (INTERNAL_ERROR) value = ""
2021.09.28 09:27:56.494 *D* [comm.cs.1          ] Sending message CMD_REQUEST_COMPLETED (ID 1736; size 32; uncompressed)
2021.09.28 09:27:56.494 *D* [comm.cs.1          ] Outgoing message dump:

I would really be nice if when doing a right click layer2 topology map we could easily identify the nodes of interest.  Maybe allow a node option similar to manage and unmanage where you can flag or unflag a node on any map. It could possibly add a  background color or maybe simply blink the current status color.  I know I can reduce the number of objects shown in the topology but  90% of the time it is not enough to get a good picture of the topology when trouble shooting a ring of switches and i have to increase the radius. I have also noticed even though the radius is set to 5  depending on the switch I select It will still return 30 or more devices.
 

Thanks

Gary

Question about action configuration.  Im running netxms on a debian server and i was playing around with (Execute command on managment server)  I noticed that all commands run using this option are run as root.  I tested with a simple "touch /opt/testfile.txt"   How does netxms run these commands under root if there is no credentials given for the root user


Thanks

I think it would be helpful to have a script generator that would allow a visual gui in building custom scripts that could be used with netxms or maybe provide a repository for people to post there custom scripts that maybe helpful for others.

See responses below.  I forgot to mention this is a timescaledb so im not sure if that is what is causing my issues




\d alarms;

Table "public.alarms"
       Column       |          Type           | Collation | Nullable | Default
--------------------+-------------------------+-----------+----------+---------
alarm_id           | integer                 |           | not null |
parent_alarm_id    | integer                 |           | not null |
alarm_state        | integer                 |           | not null |
hd_state           | integer                 |           | not null |
hd_ref             | character varying(63)   |           |          |
creation_time      | integer                 |           | not null |
last_change_time   | integer                 |           | not null |
rule_guid          | character varying(36)   |           |          |
source_object_id   | integer                 |           | not null |
zone_uin           | integer                 |           | not null |
source_event_code  | integer                 |           | not null |
source_event_id    | bigint                  |           | not null |
dci_id             | integer                 |           | not null |
message            | character varying(2000) |           |          |
original_severity  | integer                 |           | not null |
current_severity   | integer                 |           | not null |
repeat_count       | integer                 |           | not null |
alarm_key          | character varying(255)  |           |          |
ack_by             | integer                 |           | not null |
resolved_by        | integer                 |           | not null |
term_by            | integer                 |           | not null |
timeout            | integer                 |           | not null |
timeout_event      | integer                 |           | not null |
ack_timeout        | integer                 |           | not null |
alarm_category_ids | character varying(255)  |           |          |
event_tags         | character varying(2000) |           |          |
rca_script_name    | character varying(255)  |           |          |
impact             | character varying(1000) |           |          |
Indexes:
    "alarms_pkey" PRIMARY KEY, btree (alarm_id, source_object_id, creation_time)
    "alarms_creation_time_idx" btree (creation_time DESC)
    "alarms_source_object_id_creation_time_idx" btree (source_object_id, creation_time DESC)
Number of child tables: 1989 (Use \d+ to list them.)




select count(*) from alarms;
count
-------
     0
(1 row)


Did not find any relation named "old_alarms".
netxms_db=#


netxms_db-# \d event_log;
                          Table "public.event_log"
      Column      |          Type           | Collation | Nullable | Default
------------------+-------------------------+-----------+----------+---------
event_id         | bigint                  |           | not null |
event_code       | integer                 |           | not null |
event_timestamp  | integer                 |           | not null |
origin           | integer                 |           | not null |
origin_timestamp | integer                 |           | not null |
event_source     | integer                 |           | not null |
zone_uin         | integer                 |           | not null |
dci_id           | integer                 |           | not null |
event_severity   | integer                 |           | not null |
event_message    | character varying(2000) |           |          |
event_tags       | character varying(2000) |           |          |
root_event_id    | bigint                  |           | not null |
raw_data         | text                    |           |          |
Indexes:
    "event_log_pkey" PRIMARY KEY, btree (event_id, event_source, event_timestamp)
    "event_log_event_source_event_timestamp_idx" btree (event_source, event_timestamp DESC)
    "idx_event_log_event_timestamp" btree (event_timestamp)
    "idx_event_log_root_id" btree (root_event_id) WHERE root_event_id > 0
    "idx_event_log_source" btree (event_source)
Number of child tables: 17943 (Use \d+ to list them.)


netxms_db=# \d  event_log_v35_2;
Did not find any relation named "event_log_v35_2".

Currently we have 3.3.323  and I am getting the following error when trying to upgrade

Upgrading database...
Upgrading from version 35.1 to 35.2
SQL query failed (25P02 ERROR:  current transaction is aborted, commands ignored until end of transaction block):
DROP INDEX IF EXISTS idx_event_log_event_timestamp
Rolling back last stage due to upgrade errors...

I normally build from source and install.  Do I need to install a previous version in order to upgrade to 3.6 or should this process still work jumping that many versions

Thanks,

Gary

Just an update I downloaded CentOS 7 and was able to successfully build and install using the latest netxms source and postgres 12.    However i did run into  an initial issues when trying to nxdb init

Unable to connect to database netxms_db@localhost as netxms (FATAL:  Ident authentication failed for user "netxms") i believe this is because the pg_hba.conf does not have an entry for netxms after changing to the following i was able to initialize via nxbmgr init

local   all             postgres                                trust
# IPv4 local connections:
host    netxms_db   netxms         127.0.0.1/32             md5
# IPv6 local connections:
host    netxms_db   netxms         ::1/128                  md5



using pqsql i created a db of netxms_db and  user netxms with password of netxms for testing   


hope this helps

Are you able to connect to either database using the cli tools such as mysql  or psql for postgres ?   Did you make sure to add the correct db driver username and credentials in the netxms config?  You also would have to have configured netxms to build those drivers   --with-pgsql  --with-mysql --with-sqlite in orderian to initialize the databases.  Hope any of that helps. I have never had any issues as long as every thing builds correctly and I am able to connect to the DB with my configured username and password from the cli tools then i'm usually good to go.