ranger-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Don Bosco Durai <bo...@apache.org>
Subject Re: Need Help in running Hive ranger plugin
Date Thu, 30 Jul 2015 17:09:44 GMT
Bharat, the attachments didnĀ¹t come. Can you create a JIRA and attach them
to it?

Thanks

Bosco

From:  Bharat Mallela <bhmallel@in.ibm.com>
Reply-To:  "dev@ranger.incubator.apache.org"
<dev@ranger.incubator.apache.org>
Date:  Thursday, July 30, 2015 at 5:59 AM
To:  "dev@ranger.incubator.apache.org" <dev@ranger.incubator.apache.org>
Subject:  Need Help in running Hive ranger plugin

> Hi Ranger dev team,
> 
> I am facing a problem in ranger hive plugin. The communication between ranger
> server and plugin is not happening.
> 
> Installed versions
> Hive version: 0.14 (as part of Ambari)
> Ranger 0.5
> 
> Configurations:
> ===========
> Service Name: hivedev
> jdbc.driverClassName : com.mysql.jdbc.Driver
> Jdbc.url : jdbc:mysql://bdvs1669.******/hive
> 
> when ever I do test connection, am getting
> 
> Connection Failed.
> Unable to retrieve any databases using given parameters. You can still save
> the repository and start creating policies, but you would not be able to use
> autocomplete for resource names. Check xa_portal.log for more info.
> 
> 
> But with the given user and password I can connect to database and access hive
> database
> 
> 
> [root@bdvs1669 ranger-hive-plugin]# mysql -u hive -p
> Enter password:
> 
> mysql> show databases;
> +--------------------+
> | Database           |
> +--------------------+
> | information_schema |
> | hive               |
> | mysql              |
> | test               |
> +--------------------+
> 4 rows in set (0.00 sec)
> 
> 
> After this I saved the service and created a dummy policy and also installed
> the hive plugin on bdvs1669
> 
> plugin shows as enabled:
> 
> [root@bdvs1669 ranger-hive-plugin]# cat /etc/hive/conf/ranger-security.xml
> <ranger>\n<enabled>Tue Jul 28 22:10:27 PDT 2015</enabled>\n</ranger>
> [root@bdvs1669 ranger-hive-plugin]#
> 
> and also enabled debug logs by putting
> log4j.logger.com.xasecure.pdp.hive=DEBUG,DRFA in hive-log4j and restarted
> hive. There are no plugin logs  (attaching hiveserver2.log)
> 
> policy cache is empty:
> 
> [root@bdvs1669 ranger-hive-plugin]# ls /etc/ranger/hivedev/policycache/
> [root@bdvs1669 ranger-hive-plugin]#
> 
> 
> I am attaching logs for reference. Please help me out in enabling
> communication between hive plugin and server.
> 
> 
> (See attached file: hiverser2.log)(See attached file: xa_portal.log)
> 
> Thanks
> Bharat lal. M
> 
> 



Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message