Uploaded image for project: 'Apache Knox'
  1. Apache Knox
  2. KNOX-893

Use Phoenix "thin" JDBC driver HTTP basic auth got HTTP/401 error

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Not A Problem
    • 0.11.0
    • 0.13.0
    • None
    • None

    Description

      Use phoenix thin JDBC driver through knox using command:
      bin/sqlline-thin.py https://knox_gateway:8443/gateway/default/avatica;authentication=BASIC;avatica_user=guest;avatica_password=guest-password
      will get HTTP/401 error.

      401 is unauthorized error, that is because in the request header, need to add Authorization Basic

      {encodedCredential}

      . In CALCITE-1025, some changes are proposed to be added on avatica side, but if refer to the support for hive beeline connection, this is done in HiveDispatchUtils. We may need similar thing for phoenix thin.

      Also from my testing, knox didnt do ldap authentication for the connection in this case, also need to add this part.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. KNOX-314 JDBC/HTTP for Hive Requires Specialized Dispatch

          • Blocker - Blocks development and/or testing work, production could not run
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-1025 Add support for HTTP Basic auth (for proxies) in Avatica HTTP Client

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. KNOX-844 Add documentation for support of Apache Phoenix via Knox

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Wancy Shi Wang
              Wancy Shi Wang
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: