Ranger - Unable to re-install

anand_ranganath — Fri, 16 Dec 2016 08:35:02 GMT

Ranger Version: 0.5.0.2.4

Ambari version :2.2.2.1

HDP Version: 2.4.0

I Installed successfully for the first time and I am trying to re-install in Ranger on the same cluster. Before re-installing I ran these commands to clean up.


    // get the service
curl -u admin:admin -X GET  http://localhost:8080/api/v1/clusters/dx/services/RANGER

// stop the service
curl -u admin:admin -H 'X-Requested-By: ambari' -X PUT -d '{"RequestInfo":{"context":"Stop Service"},"Body":{"ServiceInfo":{"state":"INSTALLED"}}}' http://localhost:8080/api/v1/clusters/dx/services/RANGER

// delete the service
curl -u admin:admin -H 'X-Requested-By: ambari' -X DELETE http://localhost:8080/api/v1/clusters/dx/services/RANGER

While re-installing it says unable to connect to the database. MySQL is located on the same host where Ranger is being installed. Do I have to clean up some of the properties or folder structure before re-installing ?

[root@usw2dxdpmn01 ~]# /usr/java/default/bin/java -cp /usr/share/java/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://ranger/mysql -u rangeradmin -p xxxxxxx
SQLException : SQL state: 08S01 com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure


The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. ErrorCode: 0

I tried with mysql and I am able to connect.

[root@usw2dxdpmn01 ~]# mysql -urangeradmin -pxxxxxxx
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 47
Server version: 5.1.73 Source distribution


Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Any help ,pointers is highly appreciated.

Re: Ranger - Unable to re-install

bhagan — Sat, 17 Dec 2016 03:58:38 GMT

Not sure about the Ranger re-installation, but it looks like the MySQL SQLException is occurring because you have left out the server name in the -cstring option.

Re: Ranger - Unable to re-install

anand_ranganath — Sun, 18 Dec 2016 02:13:46 GMT

I resolved the problem by dropping the ranger folder under /usr/hdf/2.4.0/ranger-*

question Re: Ranger - Unable to re-install in Archives of Support Questions (Read Only)

Ranger - Unable to re-install

Re: Ranger - Unable to re-install

Re: Ranger - Unable to re-install