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

org.hibernate.exception.SQLGrammarException with ACLs on V17

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 17.0.0
    • Fix Version/s: 17.1.1
    • Component/s: Web UI - ACLs
    • Security Level: Default (Default Security Scheme)
    • Labels:
    • Environment:

      Description

      With org.opennms.web.aclsEnabled=true set in opennms.properties. testuser can login and access the alarms , events, maps and all other features as expected, however the app throws an error when accessing the outages page/panel.

      org.hibernate.exception.SQLGrammarException

      "nyetest" is a member of specific surveillance categories and views needed to use the web acls feature . The events, alarms, maps panes are all showing the proper 'filtered' views as expected. I have a similar acl config running well on our 1.12.9 system.

      Admin user does not have the problem when acls are enabled, and disabling acls makes the problem go away for all users. The web.log shows a problem with the "{ " in the query near 'where ifServices.id =

      {alias}

      .ifServiceId ' in the sql query.

      The database was upgraded with /opt/opennms/bin/install -dis from 1.12.9 release. Most config files were started clean with the new release other than provisioning files, surveillance views, etc.

      Radius auth is in use but enabling/disabling has no effect on this issue.

      Stack Trace and Web Log Debug attached , generated from a visit to
      http://10.x.y.z:8980//opennms/outage/list.htm?outtype=current

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              mpdsville1 Mike Donnelly
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: