Cloudera Docs

Enabling Knox for SSB in CDP Private Cloud Base 7.1.8

When using SQL Stream Builder (SSB) on CDP Private Cloud Base 7.1.8, the Auto Discovery feature of Knox is not supported for SQL Stream Builder (SSB), but the SSB service definitions are already added to Knox. This means you only need to add SSB as a custom service to the cdp-proxy configuration, and define the Knox proxy paths for SSB in Cloudera Manager to enable Knox authentication for SSB.

  1. Go to your cluster in Cloudera Manager.
  2. Click on Knox from the list of Services.
  3. Select Configuration.
  4. Search for Knox Simplified Topology Management.
  5. Add the following entries to the Knox Simplified Topology Management - cdp-proxy:
    • Without Load Balancer
      SSB-SSE-UI
SSB-SSE-WS
    • With Load Balancer
      SSB-SSE-UI-LB
SSB-SSE-WS-LB
  6. Add the following entries to the Knox Simplified Topology Management - cdp-proxy-api:
    • Without Load Balancer 
      SSB-MVE-API
    • With Load Balancer
      SSB-MVE-API-LB
    The Knox Simplified Topology Management need to look like the following example:
  7. Click Save changes.
    The Refresh needed indicator appears beside the Knox service name.
  8. Refresh Knox.
  9. Go back to your cluster in Cloudera Manager.
  10. Click on SQL Stream Builder from the list of Services.
  11. Select Configuration.
  12. Search for Knox proxy path for YARN.
  13. Add the following URL path: 
    /gateway/cdp-proxy/yarnuiv2/proxy
  14. Search for Knox proxy path for Materialized View Engine.
  15. Add the following URL path: 
    /gateway/cdp-proxy-api/ssb-mve-api
  16. Restart the SQL Stream Builder service.
Complete the steps in Accessing the Steaming SQL Console through Knox section to open the Streaming SQL Console.