About Scharan

Scharan · ‎09-30-2019

@rvillanueva Appears that you are hitting Bug https://issues.apache.org/jira/browse/SPARK-18673

Scharan · ‎09-04-2019

To encrypt LDAP bind password in zeppelin Shiro configuration follow below steps: 1. Removed system password line from the config (this line contained the password for the system user that is doing the LDAP lookups) 2. Added the following line in shiro.ini: ldapRealm.hadoopSecurityCredentialPath=jceks://file/home/zeppelin/conf/zeppelin.jceks 3. Run the following command as Zeppelin user on Zeppelin host: # hadoop credential create ldapRealm.systemPassword -provider jceks://file/home/zeppelin/conf/zeppelin.jceks #Entered password <test> Where <test> is my password 4. Confirmed that file has 700 attributes 5. Restart Zeppelin

Scharan · ‎09-04-2019

Jdbc interpreter is will take default queue to run a job. To run the job in specific queue a dd the queue name in hive.url property in JDBC interpreter settings as shown below hive.url=jdbc:hive2://<zookeeper quorum>/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2?tez.queue.name=<Queue Name> EXAMPLE: hive.url= jdbc:hive2://c186-node2.squadron-labs.com:2181,c186-node3.squadron-labs.com:2181,c186-node4.squadron-labs.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2?tez.queue.name=sai Where sai is my queue name. To check and confirm execute below query in zeppelin using JDBC interpreter and check-in Yarn Resource manager UI %jdbc(hive) show databases; use <database name>; show tables; select count (*) from <table name>;

Scharan · ‎04-16-2019

@Manish Roy you need to enable spnego authentication to access webUI after enabling Kerberos ,you can refer to the following article https://community.hortonworks.com/articles/28537/user-authentication-from-windows-workstation-to-hd.html

Scharan · ‎04-07-2019

@Pativada kumar You can create users under [users] section in Advanced zeppelin-shiro-ini configuration as shown below [users] <user_name> = <Password>, <role> Example: sai=password, admin

Scharan · ‎03-15-2019

@srikumar parakkal have you configured any roles in zeppelin shiro.ini, you can try commenting below line in shiro configuraion #/api/interpreter/** = authc

Scharan · ‎02-16-2019

@Rene Vargas It should work for all the users, you might have configured queue mapping in capacity scheduler. you can also set in Advance Spark2-defaults from ambari at below peroperty spark.yarn.queue=QUEUE NAME

Scharan · ‎02-15-2019

@Rene Vargas Add the following property in interpreter settings: spark.yarn.queue=QUEUE_NAME (for spark interpreter)

Scharan · ‎01-27-2019

@Sambasivam Subramanian Check is "amb_ranger_admin" user is internal or external user, if it is external user then delete that user and create it as internal user and set the password for same, and update Ranger configs in Ambari UI with new password for "Ranger Admin user's password for Ambari

Scharan · ‎01-11-2019

@Kant T for ldap intergration you need to set the below properties in topology file , if you are using default topology add below properties in Advance-topology <param> <name>main.ldapRealm</name> <value>org.apache.hadoop.gateway.shirorealm.KnoxLdapRealm</value> </param> <param> <name>main.ldapRealm.userDnTemplate</name> <value>uid={0},ou=People,dc=charan,dc=com</value> </param> <param> <name>main.ldapRealm.contextFactory.url</name> <value>ldap://test1:389</value> </param>

Scharan · ‎01-11-2019

@Divya Thaore Are you see any errors in Browser Inspect element , Also check ambari-server logs

Scharan · ‎01-10-2019

@Divya Thaore 502 Bad Gateway error is usually indicating a networking error, Try restart of the browser or try accessing from Incognito mode

Scharan · ‎01-10-2019

@rajendra use the following to compute the total # of tables you have in Hive. hive -e "show databases" >db3.out;cat db3.out | while read line; do hive -e "use $line;show tables" >> tables3.out;done; cat tables3.out | wc -l

Scharan · ‎01-10-2019

@Mickke SemSan Try moving /etc/ranger/<Repository name> on namenode to some location and restart Ranger.

Scharan · ‎01-02-2019

@rajendra check fs.trash.interval time in hdfs , files deleted completely after the trash interval time. you can restore before trash.interval time

Scharan · ‎12-28-2018

@Sedat Kestepe no it is not related to mainboard changed

Scharan · ‎12-28-2018

@Sedat Kestepe this issue occurs when Java is restricting the TLSv1 used by the Ambari Agents. By default, ambari-agent connects to TLSv1, unless specified by force_https_protocol=PROTOCOL_TLSv1_2 in ambari-agent.ini.

Scharan · ‎12-28-2018

@rajendra babu From hdp 2.6.3 zeppelin store notebooks under hdfs location: /user/zeppelin/notebook/ , as you have deleted notebook you can re-store it from trash. Check if that notebook exists under trash directory or not

Scharan · ‎12-27-2018

@Sedat Kestepe To resolve this issue, add the following property in ambari-agent.ini (/etc/ambari-agent/conf/ambari-agent.ini) file under [security]and restart ambari-agent: ======== [security] force_https_protocol=PROTOCOL_TLSv1_2 =========== Please accept this answer if its helpful

Scharan · ‎12-27-2018

@jack Refer this https://community.hortonworks.com/articles/92363/enable-disable-acid.html

Scharan · ‎12-23-2018

@Luis Vazquez Try below steps 1. ssh to Knox gateway host and go to /var/lib/knox/data-2.6.5.X/services 2. download the configurations from https://github.com/apache/knox/tree/v0.11.0/gateway-service-definitions/src/main/resources/services/hbaseui/1.1.0/ URL. 3. make sure your folder structure should look alike /var/lib/knox/data-2.6.5.X/services/hbaseui/1.1.0 and should have rewrite.xml and service.xml files 4. change the owner/Group permissions to Knox for /var/lib/knox/data-2.6.5.X/services/hbaseui/ and subdirectory 5. Go to Knox configurations Modify "Advanced topology" with below service tag <service> <role>HBASEUI</role> <url>http://HBASEMANTERHOST:16010</url> </service> <service> 6. Restart Knox service. 7. You should be able to access HBase UI from the below URL https://Knxo-host:8443/gateway/<topology-name>/hbase/webui/ Note: Hbase UI through knox is not supported in hdp 2.6.5, You can try above steps as a workaround. Please accept answer if it helped.

Scharan · ‎12-21-2018

@Brian Chambers Looks like you have configured Knox SSO, may i know what is the hdp version

Scharan · ‎12-15-2018

@haco fayik try executing # yum clean all

Scharan · ‎12-15-2018

Hi @Jorge Florencio you can use ldap in place on adrealm, just need to change the Active Directory details to suit your AD environment. Refer to this article: https://community.hortonworks.com/articles/105169/hdp-26-configuring-zeppelin-for-active-directory-u.html

Scharan · ‎12-14-2018

@Jorge Florencio Group search base is missing, try with below template ======== ldapRealm=org.apache.zeppelin.realm.LdapRealm ldapRealm.contextFactory.systemUsername =cn=manager,dc=charan,dc=com ldapRealm.contextFactory.systemPassword =xxxx ldapRealm.contextFactory.authenticationMechanism=simple ldapRealm.contextFactory.url=ldap://ldap_url:389 ldapRealm.authorizationEnabled=true #ldapRealm.pagingSize = 20000 ldapRealm.searchBase=dc=sai,dc=com ldapRealm.userSearchBase=ou=People,dc=charan,dc=com ldapRealm.groupSearchBase=cn=admin,ou=Group,dc=charan,dc=com ldapRealm.userObjectClass=* ldapRealm.groupObjectClass=groupOfNames ldapRealm.userSearchAttributeName = uid ldapRealm.userSearchScope = subtree ldapRealm.groupSearchScope = subtree ldapRealm.userSearchFilter= (&(objectclass=*)(uid={0})) ldapRealm.memberAttribute = member ldapRealm.memberAttributeValueTemplate={0} ldapRealm.rolesByGroup = "admin":admin_role ============

Scharan · ‎12-14-2018

@Vikash KUMAR You need to install HDF management pack to add HDF services to an HDP cluster, Refer to the following document https://docs.hortonworks.com/HDPDocuments/HDF3/HDF-3.1.1/bk_installing-hdf-and-hdp/content/ch_add-hdf-to-hdp.html

Scharan · ‎12-10-2018

@choppadandi vamshi krishna Refer this document https://docs.hortonworks.com/HDPDocuments/HDP3/HDP-3.0.1/integrating-hive/content/hive_connect_hive_to_apache_superset.html

Scharan · ‎12-08-2018

@Chris Nelson Check is the keytabs under /etc/security/keytabs/ are created correctly with proper hostname or not with the below command # klist -kt /etc/security/keytabs/<keytab> You can also try regenerating the keytabs

Scharan · ‎12-08-2018

@Dhiraj try with the below api curl -X GET 'http://<kms host>:<port>/kms/v1/key/<keyname>/_versions?user.name=keyadmin'

Scharan · ‎12-08-2018

@Israel Zúñiga de la Mora Can you check tagsync.pid exists under /var/run/ranger/ on Ranger tagsync host with appropriate permission

Online	Online
Last Visited	‎10-13-2019 10:42 PM

Date Registered	‎07-09-2019 07:05 AM
Last Visited	‎10-13-2019 10:42 PM
Total Messages Posted	58
Total Kudos Received	33

Re: After enable Kerberos, all the web links askin...

Re: I am getting 502 Bad Gateway while loading the...

Re: how to retrieve the deleted zeppelin notebooks...

Re: SSL Error while connecting to ambari server af...

Re: Acid is enabled in HDP 3.0. How can I turn it ...

Re: Zeppelin example throwing "Unrecognized Hadoop...

How to encrypt Ldap bind password in zeppelin shir...

How to execute jdbc interpreter jobs in specific y...

Re: After enable Kerberos, all the web links askin...

Re: how to create a new user in apache zeppelin

Re: Unable to view Zeppelin Interpreter

Re: How to configure zeppelin in Ambari 2.7.3 to u...

Re: How to configure zeppelin in Ambari 2.7.3 to u...

Re: HDP Upgrade - Pre-Upgrade checks failed from 2...

Re: Knox ldap integration

Re: I am getting 502 Bad Gateway while loading the...

Re: I am getting 502 Bad Gateway while loading the...

Re: How to get total number of hive tables in a da...

Re: Ranger HDFS plugin not working, how to debug?

Re: how to retrieve the deleted zeppelin notebooks...

Re: SSL Error while connecting to ambari server af...

Re: SSL Error while connecting to ambari server af...

Re: how to retrieve the deleted zeppelin notebooks...

Re: SSL Error while connecting to ambari server af...

Re: Acid is enabled in HDP 3.0. How can I turn it ...

Re: How to fix Knox HBASE UI?

Re: Knox LDAP/AD logout not working properly?

Re: Problem in ambari-server 2.6.2.2 installation

Re: Zeppelin user role mapping using Active Direct...

Re: Zeppelin user role mapping using Active Direct...

Re: HDF INSTALLATION

Re: can any one tell me the procedure of hive conf...

Re: After Kerberizing cluster, services will not s...

Re: How to check version of a Ranger KMS key?

Re: After installation of Ambari (2.7.1) and HDP (...