@Harpreet_Singh
You are talking of hosts yet you are installing a single node cluster? If you have more than one node all the same nos issues to avoid the tricky setup of passwordless ssh run the following on all host including the Ambari server
My assumptions
You have successfully installed Ambari and it's running on port 8080
OS=Centos7/RHEL7 [Same steps and procedure]
Database= MySQL [Already installed and running]
root password= welcome1 [Replace with your current MySQL root password]
Ambari_host=tokyo.com [please replace with the output of $ hostname -f ]
Execute the below as root on all the hosts, first ensure that your /etc/host entry is the same on all host with the format if you have 4 hosts all the /etc/host entries should look like below
IP FQDN ALIAS
192.168.0.10 host1.com host1
192.168.0.13 host2.com host2
192.168.0.14 host3.com host3
192.168.0.16 host4.com host4
Install the Ambari-agent on all the hosts
# yum repolist
# yum install ambari-agent
Edit the /etc/ambari-agent/conf/ambari-agent.ini on all hosts edit the server entry and replace the hostname with the FQDN of the Ambari server save and exit
[server]
hostname= tokyo.com [Your Ambari host]
url_port=8440
secured_url_port=8441
connect_retry_delay=10
max_reconnect_retry_delay=30
Start the agent
# ambari-agent start
Validate the Ambari-agent status
# ambari-agent status
It should be running, do that above on all hosts
The components that are failing to install all need a database to hold the objects like Hive Metastore. It's very simple and here we go. I am assuming you have installed the MySQL database if you already as you have Ambari running.
Make sure you enable MySQL to startup at boot
# systemctl enable mysqld
# systemctl start mysqld
The below script can be used to create hive, oozie, ranger and rangerkms database plus users. You can simply use a notepad to replace for example all occurrences of hive with ranger then after with oozie etc.
You will notice for simplicity I have used the same name for the database, user and password just copy and paste every time as this is the first installation you can harden the security when you become familiar with the process
##################################
# As root user ...... Hive,,oozie,ranger and rangerkms
###################################
mysql -u root -pwelcome1
CREATE database hive;
CREATE USER 'hive'@'localhost' IDENTIFIED BY 'hive';
GRANT ALL PRIVILEGES ON *.* TO 'hive'@'localhost';
CREATE USER 'hive'@'%' IDENTIFIED BY 'hive';
GRANT ALL PRIVILEGES ON *.* TO 'hive'@'%';
CREATE USER 'hive'@'tokyo.com' IDENTIFIED BY 'hive';
GRANT ALL PRIVILEGES ON *.* TO 'hive'@'tokyo.com';
FLUSH PRIVILEGES;
quit;
############################################################
# Create the database for the Druid and Superset metastore
###########################################################
mysql -u root -pwelcome1
CREATE DATABASE druid DEFAULT CHARACTER SET utf8;
CREATE DATABASE superset DEFAULT CHARACTER SET utf8;
CREATE USER 'druid'@'%' IDENTIFIED BY 'druid';
CREATE USER 'superset'@'%' IDENTIFIED BY 'superset';
GRANT ALL PRIVILEGES ON *.* TO 'druid'@'%' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'superset'@'%' WITH GRANT OPTION;
commit;
quit;
After completing the above you should be having hive, oozie, ranger and rangerkms, druid and superset databases ready.
From the Ambari UI the correct values should be picked you can test the connection they should succeed, note the password will be blanked out that's normal see attached screenshot use existing databases not NEW !!
Once all you have validated the above you can now fire up the start all components from Ambari the above components should start successfully.
Please revert
HTH
