@Aditya Sharma Is it a kerberized environment? If yes then have you set on the client side. export HADOOP_OPTS="-Djava.security.krb5.realm=YOUR.REALM.NAME -Djava.security.krb5.kdc=my.kdc.com . Also Can you pelas emake sure that "hbase-site.xml" file is present in clients classpath and your code knows the Zookeeper Addresses and those host and ports are accessible from your machine where you are running the java code. Example: config.set("hbase.zookeeper.quorum", "node1.example.com"); config.set("hbase.zookeeper.property.clientPort", "2181") . ... View more

@Aditya Sharma Please define the "zookeeper.znode.parent" property in your code something like following: Configuration conf = HBaseConfiguration.create(); conf.set("zookeeper.znode.parent", "/hbase-unsecure"); . Parent value may differ in your case though but you can find the value of "zookeeper.znode.parent" in the "hbase-site.xml" file. ... View more

@Said Masoud Your BaseDn is too open. Are you sure that is what you want. authentication.ldap.baseDn=dc ----> can it be authentication.ldap.baseDn=dc=example,dc=com . The error "org.springframework.ldap.BadLdapGrammarException" indicates that incorrect value is specified as LDAP attributes. See: http://docs.spring.io/spring-ldap/docs/current/apidocs/org/springframework/ldap/BadLdapGrammarException.html ... View more

@Said Masoud Please check if the LDAP service is running or not? Because you are getting "<urlopen error [Errno 111] Connection refused>" If the LDAP is not running then you can start it. For OpenLDap something like following: # service slapd start - Please check if the "authentication.ldap.primaryUrl" host& port mentioned in the following properly of the ambari.properties are accessible from ambari host or not? Example: # cat /etc/ambari-server/conf/ambari.properties | grep 'authentication.ldap.primaryUrl' authentication.ldap.primaryUrl=erie1.example.com:389 # telnet erie1.example.com 389 - Also in your curl command you have an extra Quotation mark here [-d '"[{"Event"] where as it should be [-d '[{"Event"] example as following: curl -k -i -u admin:admin -H 'X-Requested-By: ambari' -X POST -d '[{"Event":{"specs":[{"principal_type":"users","sync_type":"all"},{"principal_type":"groups","sync_type":"all"}]}}]' https://127.0.0.1:8443/api/v1/ldap_sync_events - In your ambari-server.log there is some error related to DN as following so can you please share the output of the following command (if possible can you please share ambari-server.log and ambari.properties) # cat /etc/ambari-server/conf/ambari.properties | grep ldap Example output: ---------------- # cat /etc/ambari-server/conf/ambari.properties | grep ldap ambari.ldap.isConfigured=true authentication.ldap.baseDn=dc=example,dc=com authentication.ldap.bindAnonymously=false authentication.ldap.dnAttribute=dn authentication.ldap.groupMembershipAttr=memberUid authentication.ldap.groupNamingAttr=cn authentication.ldap.groupObjectClass=posixGroup authentication.ldap.managerDn=cn=Manager,dc=example,dc=com authentication.ldap.managerPassword=/etc/ambari-server/conf/ldap-password.dat authentication.ldap.primaryUrl=erie1.example.com:389 authentication.ldap.referral=ignore authentication.ldap.useSSL=false authentication.ldap.userObjectClass=posixAccount authentication.ldap.usernameAttribute=uid client.security=ldap Error Failed to parse DN; nested exception is org.springframework.ldap.core.ParseException: Encountered "<EOF>" at line 1, column 2. . ... View more

@saravanan gopalsamy Sure, The Database queries should definitely work well as it leaves no foot print in the database of the service that we wanted to delete and completely cleans all the entries related to that mentioned service from the Database completely. You will need to restart AmbariServer after making the database changes. ... View more

@saravanan gopalsamy As mentioned earlier that you can delete services from ambari UI from Ambari 2.4.x version else you will have to use the Rest API as mentioned in the above link. In Ambari 2.2.1 that feature is not available in ambari UI. So you will need to either use the Ambari API or more simplest way is to delete the service directly from the Database as mentioned in the following article. . (Easiest and quick option) Deleting Service entry directly from Database using the following query: delete from hostcomponentstate where service_name = 'KNOX'; delete from hostcomponentdesiredstate where service_name = 'KNOX'; delete from servicecomponentdesiredstate where service_name = 'KNOX'; delete from servicedesiredstate where service_name = 'KNOX'; delete from serviceconfighosts where service_config_id in (select service_config_id from serviceconfig where service_name = 'KNOX'); delete from serviceconfigmapping where service_config_id in (select service_config_id from serviceconfig where service_name = 'KNOX'); delete from serviceconfig where service_name = 'KNOX'; delete from requestresourcefilter where service_name = 'KNOX'; delete from requestoperationlevel where service_name = 'KNOX'; delete from clusterservices where service_name ='KNOX'; delete from clusterconfig where type_name like 'knox%'; delete from clusterconfigmapping where type_name like 'knox%'; . Please see: https://community.hortonworks.com/content/kbentry/81939/how-to-resolve-ambari-db-inconsistency-error-you-h.html Then you will need to restart Ambari Server. ... View more

@saravanan gopalsamy Yes, Either you can remove the services from Ambari UI as following: Ambari UI --> Ambari Metrics Collector (Or any service that you want to delete) --> Service Action (Drop down menu) --> "Delete Service" (Button) . Or use the Ambari Rest API to do the same : https://cwiki.apache.org/confluence/display/AMBARI/Using+APIs+to+delete+a+service+or+all+host+components+on+a+host - Here is an example removing METRICS_COLLECTOR from a host. # curl -u admin -H "X-Requested-By: ambari" -X DELETE http://<AMBARI_HOST>:8080/api/v1/clusters/<CLUSTERNAME>/hosts/hdmdup0002.machine.test.group/host_components/METRICS_COLLECTOR - Which version of ambari are you using that also matters. Because you can delete services from ambari UI from Ambari 2.4.x version else you will have to use the Rest API as mentioned in the above link. ... View more