NetXMS Support Forum

I am not big expert in oracle stuff, but here's config that works for me (we can now use just subagent name withou .nsm, but it does not change anything):

SubAgent = oracle
[ORACLE]
ID = DB1
Name = //10.10.1.1/orcl.office.companyname.com
Username = user
Password = password

On 6-th level of debug the following lines are in agent log:

2024.05.29 12:19:33.495 *D* [db.drv.oracle      ] OCI version 19.9.0.0.0
2024.05.29 12:19:33.497 *D* [db.drv.oracle      ] OCI statement caching is ENABLED
2024.05.29 12:19:33.497 *I* [db.drv            ] Database driver "oracle.ddr" loaded and initialized successfully
2024.05.29 12:19:33.498 *D* [oracle            ] ORACLE: poller thread for database oracle started
2024.05.29 12:19:33.498 *I* [subagents          ] Subagent "ORACLE" (/opt/netxms-master/lib/netxms/oracle.nsm) loaded successfully (version 5.0.0-rc141)
2024.05.29 12:19:33.605 *D* [db.drv.oracle      ] Connected to Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
2024.05.29 12:19:33.605 *D* [db.conn            ] New DB connection opened: handle=0x7f083c08b100
2024.05.29 12:19:33.605 *D* [db.query          ] DB Library: long running query threshold for session 0x7f083c08b100 set to 5000
2024.05.29 12:19:33.610 *I* [oracle            ] Connection with database oracle restored (version 12.1, connection TTL 3600)

What it's saying for you in the line with db.drv.oracle tag?

Map coordinates are set on the upper left corner (this may change in the future, but that's how it currently is).

Geographical map acts only as a backdrop on network maps, there is no link with object geographical coordinates. There were thoughts to introduce network map type that would use objects coordinates, but we are not there yet.

There is, however a way to view devices positioned on a map - it's Tools->World map, or on devices which have geolocation entered there's Geolocation tab.

UI is a bit unclear, just enter 28 in the network mask field

Quote from: gillesvilleneuve on May 23, 2024, 11:15:04 AMThe problem is present if I use: display objects as Small Labels, not present if i use display objects as Icons

Thanks for the info, now we've managed to replicate this. 

String functions were deprecated, now string methods should be used:

a = "abc";
b = a.right(2);
println(b);
Documentation should be up to date: https://www.netxms.org/documentation/nxsl-latest/#class-string

you can turn on sql trace for some time, from linux command line

nxadm -c "debug sql on"
and
nxadm -c "debug sql off"
afterwards.

This will turn on detailed sql query logging, log will be huge, but there will be more detailed information.

object_properties table is updated when objects are updated (renamed, custom attributes changed, etc). Changes are saved into db once per minute.

Not sure why this is happening. Can you run the script I've shared manually (via Execute Script from context menu) on a couple of nodes which we bound to that container, but should not and share the output.

Should now be:
if (($node.snmpSysName != "") and ($node.snmpSysName !=null))
{
  $node.rename($node->snmpSysName);
}


https://www.netxms.org/documentation/nxsl-latest/#_instance_methods_14

We do not have any out of the box metrics, but if you find any command line utility that is able to get this data, you can add external metric for that.

There's parameter Server.Security.2FA.TrustedDeviceTTL in Configuration->Server configuration, it's time in seconds

Please check again, this should be now fixed

NXSL functions accept OIDs both with and without the leading dot. Returned values are without the dot. So both of below lines will print "System description: 1.3.6.1.4.1.14988.1"

println("System description: " .. $node.createSNMPTransport()?.getValue(".1.3.6.1.2.1.1.2.0") );
println("System description: " .. $node.createSNMPTransport()?.getValue("1.3.6.1.2.1.1.2.0") );

?. is safe dereference which appeared in 5.0 - should createSNMPTransport() return null, this will not produce script error.

We will discuss internally, if background image size can be considering when opening map.

As for now, if size in map properties is 0, 0 then default values are taken from server configuration settings Objects.NetworkMaps.DefaultHeight (or ...Width), or coordinates of farthest objects are taken as size, if they are bigger then default values. So you can increase these default values to the size of your biggest background image.

Also, there's a difference between desktop and web version - in the latter background image is not cropped to map size.

We just found a bug in DCI loading from database, they could be randomly marked as "anomaly detected". Next patch release will contain fix for that

Quote from: Egert143 on May 08, 2024, 11:12:57 AMWhat do the yellow DCI mean? they collect data but are yellow.

Might be a bug. Can you share a screenshot of this?