Bharat, Is this cluster kerberized one? Please re-attach the xa_portal.log. I don't see that in the email.
Regards, Ramesh From: Bharat Mallela <[email protected]<mailto:[email protected]>> Reply-To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Thursday, July 30, 2015 at 5:59 AM To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> 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
