[KNOX-893] Use Phoenix "thin" JDBC driver HTTP basic auth got HTTP/401 error

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 0.11.0
• Fix Version/s: 0.13.0
• Assignee: Shi Wang
• Reporter: Shi Wang
• Created: 27/Feb/17 18:49
• Updated: 28/Mar/19 14:09
• Resolved: 28/Feb/17 00:37

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.

Issue Links

• relates to: KNOX-314 JDBC/HTTP for Hive Requires Specialized Dispatch
• relates to: CALCITE-1025 Add support for HTTP Basic auth (for proxies) in Avatica HTTP Client
• relates to: KNOX-844 Add documentation for support of Apache Phoenix via Knox