From users-return-8318-archive-asf-public=cust-asf.ponee.io@nifi.apache.org Mon Mar 26 18:03:02 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 297F9180649 for ; Mon, 26 Mar 2018 18:03:01 +0200 (CEST) Received: (qmail 46275 invoked by uid 500); 26 Mar 2018 16:03:00 -0000 Mailing-List: contact users-help@nifi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@nifi.apache.org Delivered-To: mailing list users@nifi.apache.org Received: (qmail 46265 invoked by uid 99); 26 Mar 2018 16:03:00 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 26 Mar 2018 16:03:00 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 79EE7C00CF for ; Mon, 26 Mar 2018 16:03:00 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.999 X-Spam-Level: ** X-Spam-Status: No, score=2.999 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=2, KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id 6K042GenLe8w for ; Mon, 26 Mar 2018 16:02:59 +0000 (UTC) Received: from us2-ob3-7.mailhostbox.com (us2-ob3-7.mailhostbox.com [208.91.199.220]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id CE8705F1A1 for ; Mon, 26 Mar 2018 16:02:58 +0000 (UTC) Received: from DESKTOPQAK9QTG (unknown [1.186.44.89]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: mohit.jain@open-insights.co.in) by us2.outbound.mailhostbox.com (Postfix) with ESMTPSA id 63FB1CC8E4 for ; Mon, 26 Mar 2018 16:02:53 +0000 (GMT) From: To: Subject: Unable to create HiveConnectionPool with kerberos. Date: Mon, 26 Mar 2018 21:32:54 +0530 Message-ID: <02be01d3c51b$e8ce4f20$ba6aed60$@open-insights.co.in> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_02BF_01D3C54A.02872760" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AdPFGr1QpjVgh13GQQyVHlO/wYiLAA== Content-Language: en-in X-CMAE-Score: 0 X-CMAE-Analysis: v=2.2 cv=fOdJ5dSe c=1 sm=1 tr=0 a=kO9EpOyK4BIkPXgD6EtT/A==:117 a=kO9EpOyK4BIkPXgD6EtT/A==:17 a=DAwyPP_o2Byb1YXLmDAA:9 a=JSLpD7L9F8SUBMTFNN8A:9 a=CjuIK1q_8ugA:10 a=b5IAlWF-2ph_Mpedd-oA:9 a=8C4jglr9sPg2CGJS:21 a=gKO2Hq4RSVkA:10 a=UiCQ7L4-1S4A:10 a=hTZeC7Yk6K0A:10 a=frz4AuCg-hUA:10 This is a multipart message in MIME format. ------=_NextPart_000_02BF_01D3C54A.02872760 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, I am getting the following warning when I use HiveConnection pool with Kerberos : HiveConnectionPool[id=6e60258b-9e00-3bac-85ba-0dac8e22142f] Configuration does not have security enabled, Keytab and Principal will be ignored It also throws the following bulletin in my PutHiveQl processor: PutHiveQL[id=55f4ac1b-ecf9-3db3-b898-7a9d145a5382] org.apache.nifi.processors.hive.PutHiveQL$$Lambda$663/2042832677@40267000 failed to process due to org.apache.nifi.processor.exception.ProcessException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not open client transport with JDBC Uri: jdbc:hive2://******:10000/nifi_test1: Peer indicated failure: Unsupported mechanism type PLAIN); rolling back session: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not open client transport with JDBC Uri: jdbc:hive2://******:10000/nifi_test1: Peer indicated failure: Unsupported mechanism type PLAIN) Hive Configuration Resources:- /etc/hive/conf/hive-site.xml,/etc/hadoop/conf/core-site.xml I have set hive.security.authentication and hadoop.security.authentication to Kerberos. Please let me know if I'm doing anything wrong. Regards, Mohit ------=_NextPart_000_02BF_01D3C54A.02872760 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

I am getting = the following warning when I use HiveConnection pool with Kerberos = :

 

HiveConnectionPool[id=3D6e60258b-9e0= 0-3bac-85ba-0dac8e22142f] Configuration does not have security enabled, = Keytab and Principal will be ignored

 

It also = throws the following bulletin in my PutHiveQl processor: = 

PutHiveQL[id=3D=
55f4ac1b-ecf9-3db3-b898-7a9d145a5382] =
org.apache.nifi.processors.hive.PutHiveQL$$Lambda$663/2042832677@40267000=
 failed to process due to =
org.apache.nifi.processor.exception.ProcessException: =
org.apache.commons.dbcp.SQLNestedException: Cannot create =
PoolableConnectionFactory (Could not open client transport with JDBC =
Uri: jdbc:hive2://******:10000/nifi_test1: Peer indicated failure: =
Unsupported mechanism type PLAIN); rolling back session: =
org.apache.commons.dbcp.SQLNestedException: Cannot create =
PoolableConnectionFactory (Could not open client transport with JDBC =
Uri: jdbc:hive2://******:10000/nifi_test1: Peer indicated failure: =
Unsupported mechanism type PLAIN)
 

Hive Configuration Resources:- = /etc/hive/conf/hive-site.xml,/etc/hadoop/conf/core-site.xml

I have set = hive.security.authentication and hadoop.security.authentication to = Kerberos.

 

Please let =
me know if I’m doing anything wrong.

 

Regards,

Mohit

------=_NextPart_000_02BF_01D3C54A.02872760--