Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-20352

Search and Insight Zeppelin Reports fail when communication to Alfresco is secured via SSL

    Details

    • Bug Priority:
      Category 2
    • ACT Numbers:

      00985473

    • Premier Customer:
      Yes
    • Story Points:
      8
    • RCA Cause:
      Use case not considered
    • RCA Quality:
      Use case not considered
    • RCA Description:
      Hide
      Either no one tested using a self-signed certificate, or if they did then this process was not documented. (The person who tested this area is no longer with Alfresco)

      Once the correct configuration is set then the feature works as desired - no code change was necessary.
      Show
      Either no one tested using a self-signed certificate, or if they did then this process was not documented. (The person who tested this area is no longer with Alfresco) Once the correct configuration is set then the feature works as desired - no code change was necessary.

      Description

      Summary

      Deploying alfresco-insight-zeppelin-1.0.0 and configuring it to communicate with ACS via SSL causes Reports to fail to execute. Reports are unable to populate data and throw an unable to execute query error.

      Steps to Reproduce

      • Manually Deploy ACS 6.0.0 OOTB using the default SSL Certificate for 8443
      • Manually Deploy alfresco-insight-engine-distribution-1.0.0
      • Manually Deploy alfresco-insight-zeppelin-1.0.0 and configure for SSL communications with Alfresco according the documentation: https://docs.alfresco.com/sie/concepts/deploying-apache-zeppelin-zip.html
      • Access Zeppelin Dashboard and view the ootb example Dashboard
      • Attempt to refresh the Dashboard and all Reports will fail with the same Unable to Execute Query error

      Additional Information
      -Login via the Alfresco Realm functions regardless of SSL or Non SSL

      • Ran a wireshark locally and saw that when communication is non SSL Zeppelin sends a Post request to Alfresco like /alfresco/api/default/public/search/versions/1/sql?stmt=select+%27Insight+Eng... When SSL is enabled for the connection to Alfresco this POST request is never sent.
      • Screen shots attached for interpreter configurations and error messages in UI as well as debug logging from Zeppelin showing the error messages thrown when running a report

        Attachments

        1. DebugLoggingErrorMessages.txt
          16 kB
        2. FailedQuery.PNG
          FailedQuery.PNG
          50 kB
        3. Interpreter.PNG
          Interpreter.PNG
          44 kB
        4. shiro.ini
          4 kB
        5. ZeppelinQueryWorks.png
          ZeppelinQueryWorks.png
          123 kB

          Issue Links

          is related to by

          Service Pack Request - MNT-20474 Zeppelin Reports fail when Alfresco and SOLR communications are secured via SSL

          • Closed

            Structure

              Activity

                People

                • Assignee:
                  custeng Customer Engineering
                  Reporter:
                  thines Trevor Hines
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  10 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Structure Helper Panel