Uploaded image for project: 'OpenNMS'
  1. OpenNMS
  2. NMS-6859

Geo Maps are not working (everything is on the Antarctic)

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.13.4
    • Fix Version/s: 14.0.0
    • Security Level: Default (Default Security Scheme)
    • Labels:
      None

      Description

      I made a clean compilation of 1.12.10-SNAPSHOT and 1.13.5-SNAPSHOT.

      I've started 1.12 with a clean DB installation and imported the attached requisition (Cisco.xml).

      The geo-location have been discovered properly and the map looks like maps-112.png.

      Here is the geo-data from the DB:

      opennms_1_12=# select n.nodelabel, a.latitude, a.longitude from node n, assets a where n.nodeid=a.nodeid order by n.nodelabel;
        nodelabel   | latitude  | longitude  
      --------------+-----------+------------
       Barquisimeto | 10.063611 | -69.334724
       HQ           |      10.5 | -66.916664
       Maracaibo    | 10.633333 |  -71.63333
       Merida       |       8.6 |     -71.15
       SW           |      10.5 | -66.916664
       Valencia     | 10.157931 |  -67.99721
      (6 rows)
      

      Unfortunately, in 1.13 the maps are not working in the same way and the problem seems to be the geo-coding code.

      So, I've started 1.13 with a clean DB installation and imported the same requisition (Cisco.xml).

      The geo-location have been discovered properly and the map looks like maps-113.png.

      Here is the geo-data from the DB:

      opennms_1_13=# select n.nodelabel, a.latitude, a.longitude from node n, assets a where n.nodeid=a.nodeid order by n.nodelabel;
        nodelabel   |     latitude      |     longitude     
      --------------+-------------------+-------------------
       Barquisimeto | -69.3347244262695 | -69.3347244262695
       HQ           | -66.9166641235352 | -66.9166641235352
       Maracaibo    | -71.6333312988281 | -71.6333312988281
       Merida       | -71.1500015258789 | -71.1500015258789
       SW           | -66.9166641235352 | -66.9166641235352
       Valencia     | -67.9972076416016 | -67.9972076416016
      (6 rows)
      

      As you can see, the coordinates seem to be completely different.

        Attachments

        1. Cisco.xml
          2 kB
        2. maps-112.png
          maps-112.png
          1.30 MB
        3. maps-113.png
          maps-113.png
          444 kB

          Activity

            People

            • Assignee:
              agalue Alejandro Galue
              Reporter:
              agalue Alejandro Galue
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: