About Scharan

Scharan · ‎11-14-2019

@jeff_watson To enable debug on superset logs, follow below steps Stop Superset from Ambari Add this line at the end of /usr/hdp/current/superset/lib/python3.4/site-packages/superset/__init.py logging.getLogger('flask_appbuilder').setLevel(logging.DEBUG) 3. Then Start superset manually using following command source /usr/hdp/current/superset/conf/superset-env.sh ; /usr/hdp/current/superset/bin/python3.4 /usr/hdp/current/superset/bin/gunicorn --log-level debug -b `hostname`:9088 superset:app

Scharan · ‎11-07-2019

@Manoj690 Check if their is any ranger policy or you can try disabling Authorization for HiveServer2 as follows: ### Ambari UI > Hive > Configs > Advanced > Advanced Hiveserver2-Site > Uncheck "Enable Authorization" Option > Restart Hive Service and run the query

Scharan · ‎11-07-2019

@nicola_marangon can you share interpreter settings

Scharan · ‎11-07-2019

@Harish-hadoop Add the queue name in hive.url property in jdbc interpreter settings hive.url=jdbc:hive2://<zookeeper quorum>/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2?tez.queue.name=<Queue Name> EXAMPLE: hive.url= jdbc:hive2://test1:2181,test2:2181,test3:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2?tez.queue.name=sai

Scharan · ‎11-07-2019

@asmarz centos 7.7 is not tested, I suggest you to go with centos 7.6

Scharan · ‎11-07-2019

It looks like now you are able to open HBase shell. If the table is disabled, "> is_disabled ’t1′ "command will return true. ERROR: org.apache.hadoop.hbase.NotServingRegionException: hbase:meta,,1 is not online on gaian-lap386.com,16020,1573102321915 Check is the region server on gaian-lap386.com is up and running

Scharan · ‎11-07-2019

@Manoj690 Jdk 8 is supported with the currenty hbase version.

Scharan · ‎11-07-2019

@Manoj690 Jdk 11 is not yet tested, refer below document https://hbase.apache.org/book.html#java

Scharan · ‎11-07-2019

@Manoj690 What is the java version

Scharan · ‎11-07-2019

@sashik Can you try installing pyOpenSSL in the Python3

Scharan · ‎11-07-2019

@sashik Which python version you are using Make sure openssl package is installed

Scharan · ‎11-06-2019

can you share the output of below command # hadoop checknative -a | grep hadoop

Scharan · ‎11-06-2019

ERROR datanode.DataNode (DataNode.java:secureMain(2883)) - Exception in secureMain java.lang.RuntimeException: Although a UNIX domain socket path is configured as /var/lib/hadoop-hdfs/dn_socket, we cannot start a localDataXceiverServer because libhadoop cannot be loaded. Above error occurs when libhadoop.so library is missing in /usr/hdp/current/hadoop/lib/native/ To resolve this issue copy the missing library from another healthy node @Muralikrishna

Scharan · ‎11-06-2019

@wdailey Use "ldapRealm=org.apache.zeppelin.realm.LdapRealm" Below is the template for your reference ldapRealm=org.apache.zeppelin.realm.LdapRealm ldapRealm.contextFactory.systemUsername =cn=manager,dc=charan,dc=com ldapRealm.contextFactory.systemPassword =admin ldapRealm.contextFactory.authenticationMechanism=simple ldapRealm.contextFactory.url=ldap://test1:389 ldapRealm.authorizationEnabled=true #ldapRealm.pagingSize = 20000 ldapRealm.searchBase= ldapRealm.userSearchBase= ldapRealm.groupSearchBase= ldapRealm.userObjectClass= ldapRealm.userSearchAttributeName = uid ldapRealm.userSearchScope = subtree ldapRealm.groupSearchScope = subtree ldapRealm.userSearchFilter= ldapRealm.memberAttribute = member ldapRealm.memberAttributeValueTemplate=(name={0})

Scharan · ‎10-24-2019

@IrenaKon Refer below link https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.6.5/index.html

Scharan · ‎10-23-2019

@mkobe Check is Postgres i up and running and make sure pg_hba.conf file is connfigured correctly under /var/lib/psql/pg_hba.conf

Scharan · ‎10-22-2019

@Peruvian81 You need to update ranger, You can follow the below steps to reset the password in postgres: 1.Login into postgres 2. postgres=# \connect ranger 3. ranger=# update x_portal_user set password = 'ceb4f32325eda6142bd65215f4c0f371' where login_id = 'admin'; Above would reset the password to 'admin'. 4. Login to Ranger UI using the above password 5. Go to User Profile and change the password 6. Open Ambari UI Ranger Configs 7. Update 'admin_password' in Advanced ranger-env with the newly set password

Scharan · ‎10-22-2019

@Peruvian81 The following method could be used to work this around. 1. Login to the Ranger repository database 2.Run the following DML command to update the Ranger admin's password to 'admin' update x_portal_user set password = 'ceb4f32325eda6142bd65215f4c0f371' where login_id = 'admin'; The above would reset the password to 'admin'. 3. Login to Ranger UI using the above password 4. Go to User Profile and change the password 5. Open Ambari UI Ranger Configs 6. Update 'admin_password' in Advanced ranger-env with the newly set password

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

Online	Offline
Last Visited	‎12-09-2019 02:15 AM

Date Registered	‎07-09-2019 07:05 AM
Last Visited	‎12-09-2019 02:15 AM
Total Messages Posted	76
Total Kudos Received	39

Re: how to add the queue name zeppelin jdbc interp...

Re: Zeppelin 0.8 on HDP 3.1.0.0 class org.apache.z...

Re: Where can I download HDP 2.6.5

Re: Ranger Password reset

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

Re: How to configure Superset to use LDAP?

Re: Hbase shell error

Re: Zeppelin-Livy-Spark: Connection refused from Y...

Re: how to add the queue name zeppelin jdbc interp...

Re: Compatibility CEntos 7.7 with AMBARI last ver...

Re: Hbase shell error

Re: Hbase shell error

Re: Hbase shell error

Re: Hbase shell error

Re: SSL error for Livy

Re: SSL error for Livy

Re: unable to start the data node in hdp3.1 amabri...

Re: unable to start the data node in hdp3.1 amabri...

Re: Zeppelin 0.8 on HDP 3.1.0.0 class org.apache.z...

Re: Where can I download HDP 2.6.5

Re: Error While Trying to Test Connection to Hive ...

Re: Ranger Password reset

Re: Ranger Password reset

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...