Re: 500 status code received on GET method for API...

deepak_s2 · ‎05-24-2019

Step 1: cat /etc/ambari-server/conf/ambari.properties | grep ambari-server.user. Know the user from above command. Step 2: change user /var/run/ambari-server chown -R <output of above command> /var/run/ambari-server

deepak_s2 · ‎03-14-2019

Hey Thanks alot @Jay Kumar SenSharma it did work after reboot. But Now i'm facing different issue HST agent is redirecting to fail mode after restart. can you please help on this.

deepak_s2 · ‎03-14-2019

Hi all, i was able to to login yesterday but when im trying to login today i'm facing this issue. Here is the output of ambari-server status from terminal Screen Shot of /var/log/ambari-server Also, here i attach the amabri-server.log ambari-server.txt Any help is appreciated a lot. Thanks in advance @Jay Kumar SenSharma @Geoffrey Shelton Okot

deepak_s2 · ‎08-28-2018

Hi All, I found the solution for this, in the ListDatabaseTables properties we must specify table schema as [rms|lut|mst]_% to fetch only those particular tables from the database. If anyone get helps by this click approved. Thanks, Deepak

deepak_s2 · ‎08-28-2018

Hi All, i'm trying to fetch schema from RDBMS(SqlServer) to hive using Nifi, i'm using ListdatabaseTables to fetch the database tables but in my case I have different tables with names say, dbo.rms.***, dbo.lut.*** , dbo.mst.*** and dbo.bk.**** , dbo.cad.***. I'm trying to fetch only tables with name dbo.rms, dbo.lut and dbo.mst. Please can anyone help me out on how to set properties in ListaDatabaseTables to fetch above output. @Matt Burgess @Shu @Geoffrey Shelton Okot @Jay Kumar SenSharma @Matt Burgess Thanks, Deepak

deepak_s2 · ‎08-22-2018

Hi @Jay Kumar SenSharma @Matt Burgess @Geoffrey Shelton Okot, please can any one help me out on this. any help will appreciated alot. Thanks, Deepak

deepak_s2 · ‎08-22-2018

Hi @Jay Kumar SenSharma Thanks lot for quick response, here i attach document with all the details you have asked above. please take a look and let me know if you need any other further information. Thanks, Deepaknifi-hcc.txt

deepak_s2 · ‎08-21-2018

Hi all, I'm trying to create secured nifi and when i restart it says, " INFO [NiFi Bootstrap Command Listener] org.apache.nifi.bootstrap.RunNiFi Apache NiFi now running and listening for Bootstrap requests on port 40512 2018-08-21 16:22:24,527 ERROR [NiFi logging handler] org.apache.nifi.StdErr Failed to start web server: Unresolved address 2018-08-21 16:22:24,527 ERROR [NiFi logging handler] org.apache.nifi.StdErr Shutting down... 2018-08-21 16:22:25,894 INFO [main] org.apache.nifi.bootstrap.RunNiFi NiFi never started. Will not restart NiFi" I even tried removing the flowfile, contents and provenance repositories and tried restarting the nifi, even though i,m getting the same error. Any please help me out. Thanks in advance @Matt Burgess @Matt Clarke @Jay Kumar SenSharma @Geoffrey Shelton Okot @Artem Ervitsnifi-bootstrap.txtapplog.txt

deepak_s2 · ‎08-14-2018

Hi @Geoffrey Shelton Okot, In nifi.properties i have, nifi.zookeeper.session.timeout =3 secs and nifi.zookeeper.connect.timeout= 3 secs and which logs do i need to share in /var/log/nifi? nifi-user.log, nifi-bootstrap.log, nifi-app.log? and NTPD is running.

deepak_s2 · ‎08-14-2018

I configured 3 node Nifi cluster it was working fine till yesterday. But from today morning it was showing exclamation mark for NIFI in ambari UI, i tried to restart several times but it starts and then it stop automatically for nifi instance on one node. nifi-error.png nifi-error.txt @Matt Clarke @Geoffrey Shelton Okot @Greg Keys

deepak_s2 · ‎08-01-2018

Hi @Ali Bajwa @Vinicius Higa Murakami, Here in initial admin identity CN= nifiadmin, OU= CLOUD.HORTONWORKS.COM is it common for everyone? my FQDN is ARIES-HDP-NifiNode1.ariessystem.us, if so OU varies for everyone depending on their FQDN can you please tell my OU with respective of my FQDN.

deepak_s2 · ‎07-31-2018

Thanks a lot @Vinicius Higa Murakami @Geoffrey Shelton Okot issue resolved. i appreciate for helping me.

deepak_s2 · ‎07-31-2018

Hi @Vinicius Higa Murakami , i ran that command and it got installed. can you please tell me what steps to be performed next.sqllib-java.png

deepak_s2 · ‎07-31-2018

Hi @Vinicius Higa Murakami , i'm currently using Ubuntu 14.04 i don't see that option in MySQL.com when I'm trying to download manually and when i ran the command by changing the version to apt-get install -y mysql-connector-java_8.0.12-1ubuntu14.04_all.deb, I'm getting the following error.mysql-error2.png can you please help me out.

deepak_s2 · ‎07-31-2018

Hi @Vinicius Higa Murakami @Geoffrey Shelton Okot when i ran this command "apt-get install -y mysql-connector-java " mysqlerror.pngI'm getting this error.

deepak_s2 · ‎07-31-2018

Hi @Geoffrey Shelton Okot @Vinicius Higa Murakami , i'm using Ubuntu so my command will be 1. apt-get install -y mysql-connector-java 2. ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar Is this right? Thank you for you help all of you.

deepak_s2 · ‎07-31-2018

Hi @Vinicius Higa Murakami, just to confirm I need to just download the mysql-connector-java.jar, am i correct??

deepak_s2 · ‎07-31-2018

mysql-jdbc-connector-error.pngHI @Vinicius Higa Murakami, Thank you for your reply. I don't see any MySQL-connector-java.jar when i run this command " find / -name "mysql-connector-java.jar" -type f ". I'm getting this error when i ran this command " #[root@node1 ~]# ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar #I made my setup with this jdbc-driver". Please look at the attached screen shot and cloud you please help me out in how to install those MySQL-jdbc conector. Thanks in advance and i appreciate your help.

deepak_s2 · ‎07-26-2018

Hi all, I have installed ambari and every service was running good, but im getting 2 alerts on hive. i tried to resolve but i'm unable to do that. can anyone help me out? - i'm able to login to mysql and beeline also. ================== Hive error ========================================================================================== root@ARIES-HDP-WNODE1:/etc# beeline -u "jdbc:hive2://aries-hdp-wnode1.ariessystem.us:2181,aries-hdp-mnode.ariessystem.us:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2" Connecting to jdbc:hive2://aries-hdp-wnode1.ariessystem.us:2181,aries-hdp-mnode.ariessystem.us:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 Error: org.apache.hive.jdbc.ZooKeeperHiveClientException: Unable to read HiveServer2 configs from ZooKeeper (state=,code=0) Beeline version 1.2.1000.2.6.5.0-292 by Apache Hive 0: jdbc:hive2://aries-hdp-wnode1.ariessystem. (closed)> ============================================================================================== Here i attach the hive server log and alert pictures from ambarihive-metastore-log.txt hive-alert1.pnghive-alert-2.pngalert-3.png @Jay Kumar SenSharma

deepak_s2 · ‎07-23-2018

Issue resolved: I had reset the password for root, it solved my issue. Thanks

deepak_s2 · ‎07-18-2018

Hey can you please share the commands modified in /etc/sudoers. Even i'm facing the same problem since 3 days. please any help me out this.

deepak_s2 · ‎07-18-2018

Hello, thank you for your response. Initially i did ssh root@hostname but i got error saying permission denied and later i followed the steps you given even though I'm getting another error saying permission denied. Here I attach the error please take a look. ambari-errorr.png @Jay Kumar SenSharma @Geoffrey Shelton Okot @Vinicius Higa Murakami

deepak_s2 · ‎07-18-2018

I am trying to install a 5node cluster using ambari Machine 1 : Master Node + Local repository + Ambari Server Machine 2: Name node Machine 3,4 & 5 : SlaveNode Local repository is on the same system as master node and ambari-server. I am using ambari server 2.6.2 to install hdp 2.6.5 repolist command lists : 1) HDP-2.6.5 2) HDP-UTILS-1.1.0.22 3) Updates-ambari-2.6.5.0 I have generated public by logging in as root sudo su and i placed the public key in home directory of the slave node, even though i was able to do password less SSH between slave and master but I'm getting this error. ========================== Creating target directory... ========================== Command start time 2018-07-17 17:01:51 Permission denied (publickey,password). SSH command execution finished host=aries-hdp-mnode.so.cccounty.us, exitcode=255 Command end time 2018-07-17 17:01:51 ERROR: Bootstrap of host aries-hdp-mnode.so.cccounty.us fails because previous action finished with non-zero exit code (255) ERROR MESSAGE: Permission denied (publickey,password). STDOUT: Permission denied (publickey,password). @Geoffrey Shelton Okot @Vinicius Higa Murakami ambari-error.pngserver-log.txt Kindly Please help me out. Thanks in advance.

Online	Offline
Last Visited	‎05-24-2019 08:49 PM

Date Registered	‎07-18-2018 12:51 AM
Last Visited	‎05-24-2019 08:49 PM
Total Messages Posted	23
Total Kudos Received	1

Re: 500 status code received on GET method for API...

Re: AMBARI UI LOGIN ISSUE : SERVER ERROR : VERY UR...

AMBARI UI LOGIN ISSUE : SERVER ERROR : VERY URGENT

Re: How to fetch schema for particular tables from...

How to fetch schema for particular tables from rdb...

Re: Nifi web server failing to start

Re: Nifi web server failing to start

Nifi web server failing to start

Re: Nifi starts and stop automatically

Nifi starts and stop automatically

Re: HDF 2.x/3.x: enable SSL for Apache Nifi from A...

Re: unable to read hiveserver2 configs from zookee...

Re: unable to read hiveserver2 configs from zookee...

Re: unable to read hiveserver2 configs from zookee...

Re: unable to read hiveserver2 configs from zookee...

Re: unable to read hiveserver2 configs from zookee...

Re: unable to read hiveserver2 configs from zookee...

Re: unable to read hiveserver2 configs from zookee...

unable to read hiveserver2 configs from zookeeper ...

Re: problem at confirm hosts

Re: Ambari automatic registration failed (Step 3: ...

Re: problem at confirm hosts

problem at confirm hosts