********************************************************************************
**********************
##########Take a ubuntu(18.04) machine for Hosting###############
sudo apt update
DOWNLOAD REPO ON UBUNTU MACHINE
wget https://archive.cloudera.com/cm7/7.4.4/repo-as-tarball/cm7.4.4-redhat7.tar.gz
tar -zxvf cm7.4.4-redhat7.tar.gz
sudo apt install apache2 -y
sudo mv cm7.4.4 /var/www/html/
Take The IP Of Webserver(UBUNTU) & Go To Browser Type webserver-ip/cm7
####Launch a Centos 7 machine taking m4 with storage 60########
-----------------------------------------------------------------------
*Download and install MYSQL server
wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
md5sum mysql57-community-release-el7-9.noarch.rpm
sudo rpm -ivh mysql57-community-release-el7-9.noarch.rpm
sudo yum install mysql-server --nogpgcheck -y
sudo systemctl start mysqld
sudo systemctl status mysqld
sudo grep 'temporary password' /var/log/mysqld.log
(it's generates the temporary password)
sudo mysql_secure_installation
(give the password like Pratap@2023)
Change the root password? [Y/n] [ENTER]
Remove anonymous users? [Y/n] y
Disallow root login remotely? [Y/n] y
Remove test database and access it? [Y/n] n
Reload privilege tables now? [Y/n] y
sudo chmod 600 security.pem
###connectors
check if java is installed
java -version
If not installed then install java with this command:
sudo yum install java-1.8.0-openjdk-devel -y
wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.46.tar.gz
tar -zxvf mysql-connector-java-5.1.46.tar.gz
sudo mkdir -p /usr/share/java/
cd mysql-connector-java-5.1.46
sudo cp /home/centos/mysql-connector-java-5.1.46/mysql-connector-java-5.1.46-bin.jar
/usr/share/java/mysql-connector-java.jar
*Create SCM Database
mysql -u root -p
CREATE DATABASE scm DEFAULT CHARACTER SET utf8 DEFAULT COLLATE
utf8_general_ci;
GRANT ALL ON scm.* TO 'scm'@'%' IDENTIFIED BY 'P@ssw0rd';
show databases;
exit;
*Setup the Cloudera Manager Server(On CM Host)
login as a cm
----use webserver ip here--
sudo nano /etc/yum.repos.d/cloudera-manager.repo
[cloudera-manager]
# Packages for Cloudera Manager, Version 7, on RedHat or CentOS 7 x86_64
name=Cloudera Manager
baseurl=http://ip-172-31-36-7.ap-south-1.compute.internal/cm7.4.4/
gpgkey =http://ip-172-31-36-7.ap-south-1.compute.internal/cm7.4.4/RPM-GPG-KEY-cloudera
gpgcheck = 0
sudo yum clean all
sudo yum makecache
sudo yum install cloudera-manager-server cloudera-manager-daemons -y
sudo find / -name *database.sh*
---use database ip here-----
sudo /opt/cloudera/cm/schema/scm_prepare_database.sh mysql -h ip-172-31-0-113.ap-south-
1.compute.internal scm scm P@ssw0rd
sudo service cloudera-scm-server start
sudo service cloudera-scm-server status
sudo tail -f /var/log/cloudera-scm-server/cloudera-scm-server.log
*To check the status of CDM
sudo netstat -tulnp
sudo netstat -tulnp | grep 7180
*Setup Database
create database hive DEFAULT CHARACTER SET utf8;
grant all on hive.* TO 'hive'@'%' IDENTIFIED BY 'P@ssw0rd';
create database hue DEFAULT CHARACTER SET utf8;
grant all on hue.* TO 'hue'@'%' IDENTIFIED BY 'P@ssw0rd';
create database rman DEFAULT CHARACTER SET utf8;
grant all on rman.* TO 'rman'@'%' IDENTIFIED BY 'P@ssw0rd';
create database oozie DEFAULT CHARACTER SET utf8;
grant all on oozie.* TO 'oozie'@'%' IDENTIFIED BY 'P@ssw0rd';
create database navs DEFAULT CHARACTER SET utf8;
grant all on navs.* TO 'navs'@'%' IDENTIFIED BY 'P@ssw0rd';
create database navms DEFAULT CHARACTER SET utf8;
grant all on navms.* TO 'navms'@'%' IDENTIFIED BY 'P@ssw0rd';
create database actmo DEFAULT CHARACTER SET utf8;
grant all on actmo.* TO 'actmo'@'%' IDENTIFIED BY 'P@ssw0rd';
create database ranger DEFAULT CHARACTER SET utf8;
grant all on ranger.* TO 'ranger'@'%' IDENTIFIED BY 'P@ssw0rd';
CREATE USER 'temp'@'%' IDENTIFIED BY 'P@ssw0rd';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS,
REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES,
LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW,
SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON
*.* TO 'temp'@'%' WITH GRANT OPTION;
show databases;
exit ;
*Login---->using CM Public IP
-------------------------------------------------------
END----------------------------------------------------------------
