NetXMS Support Forum

I mean that coordinates set in map properties correspond to what's in the upper left corner of the map. So e.g. if I take latitude 51°30'N and longitude 0, I'll have London in the corner of my map.

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?

Got it.   That works.  Thanks!  

Can you send a screenshot of "Map coordinates are set on the upper left corner" ?    I'm not sure if I'm missing something.

If I set the map coordinates in the properties, it refuses to even show me that part of the world. https://ibb.co/dbVqwM7
(please see map coordinates as they are set, vs the map that is displayed).     I can't even get my part of the world to load in the map view, at all... that's sort of my biggest problem.

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

Thanks for the '--with-oracle' suggestion. It worked.
Now, Oracle.DBInfo.IsReachable(DB1) is coming NO

SubAgent = oracle.nsm
[ORACLE]
ID = DB1
Name = TEST
Username = dbuser
Password = "mypass123"
I also tried below config but that didn't work either.
Select
SubAgent = oracle.nsm
[ORACLE]
ID = DB1
TnsName = TEST
Username = dbuser
Password = "mypass123"
I gave full connection string as below. Also didn't work.
Select
SubAgent = oracle.nsm
[ORACLE]
ID = DB1
Name = dbuser@//localhost:1521/TEST
Username = dbuser
Password = "mypass123"
2024.05.28 15:16:46.285 *D* [comm.cs.1          ] Requesting metric "Oracle.DBInfo.IsReachable(DB1)"
2024.05.28 15:16:46.285 *D* [comm.cs.1          ] GetMetricValue("Oracle.DBInfo.IsReachable(DB1)"): 0 (SUCCESS) value = "NO"
2024.05.28 15:16:46.285 *D* [comm.cs.1          ] Outgoing message dump:
  ** 000000 | 00 1D 50 00 00 00 00 30 00 00 05 3E 00 00 00 02 | ..P....0...>....
  ** 000010 | 00 00 00 1C 00 00 00 00 00 00 00 00 00 00 00 00 | ................
  ** 000020 | 00 00 00 15 07 00 00 00 00 00 00 02 4E 4F 00 00 | ............NO..
  ** code=0x001D (CMD_REQUEST_COMPLETED) version=5 flags=0x0000 id=1342 size=48 numFields=2
  ** 000000: [    28] INT32       0
  ** 000010: [    21] UTF8-STRING "NO"
Is there any difference between the INI formats of 4.5.0 and 5.x ? Id or ID? TnsName or Name?
Can't find Administration Guide for old versions.

Only confirmation. The upgrade was successfull now.
Thank you. Martin

Is this not a valid subnet for Network Discovery?
(It seems to want to change it to a /24)

https://ibb.co/D41q05K

I'm not sure if I'm doing something wrong, or if things are just broken; I'm not having much luck with mapping.

I created a map with the background set to Geographic Map.  I then set the GPS coordinates.  However, the map displayed is something totally different:
https://ibb.co/dbVqwM7

I guess that is problem #1.


My second problem, is that objects don't display based on the location set in the object properties. (although if the problem #1 above is broken, then this problem #2 is never going to look right). 

Shouldn't objects appear on the Geo-location Map based on the location set in their properties?

My third issue is that (I assumed) setting a location (or location details like city, district, zip code, etc)  on a container would push those values down to lower level objects, including location/GPS details.  If all objects in a container are at the same location then wouldn't setting the values at a higher level cause them to be set automatically on the lower level object?