Bharat, the attachments didn¹t come. Can you create a JIRA and attach them to it?
Thanks Bosco From: Bharat Mallela <[email protected]> Reply-To: "[email protected]" <[email protected]> Date: Thursday, July 30, 2015 at 5:59 AM To: "[email protected]" <[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 > >
