-
Type:
Service Pack Request
-
Status: Verified
-
Resolution: Fixed
-
Affects Version/s: 6.0
-
Fix Version/s: 6.0.N
-
Component/s: Analytics, Search and Indexing (non-UI)
-
Labels:None
-
Bug Priority:
-
ACT Numbers:
00985473
-
Premier Customer:Yes
-
Story Points:8
-
RCA Cause:Use case not considered
-
RCA Quality:Use case not considered
-
RCA 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
- is related to by
-
MNT-20474 Zeppelin Reports fail when Alfresco and SOLR communications are secured via SSL
- Closed