Posts

Postgresql Environment Setup

Postgresql:     PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. Installation and configuration on Ubuntu  14.04     Step 1: $ sudo apt-get update     Step 2: $ sudo apt-get install postgresql To connect the default Database:     Step 3: sudo -u postgres psql template1    To create New user :     template1>create  user <user_name> with encrypted password '<pwd>';     Ex: create User Varun with encrypted password 'varun' To grant create database permission to new user:     template1>ALTER  USER <user_name> CREATEDB     Ex : alter user Varun createdb Add new user in pg_hba.conf file with MD5 authentication     Ed...

HDP 2.5 Add Port

Image
Login with below credentials : ssh -p 2122 root@localhost username is root password is hadoop. Before do changes disable sandbox service by following command systemctl disable sandbox.service Restart Sandbox vm machine by below command:  init 6 Open start_sandbox.sh using vi edition scroll down end: vi /root/start_scripts/start_sandbox.sh -p 2222:22 \ sandbox /usr/sbin/sshd -D Add Your port For Example : 8440 like that; -p 2222:22 \ -p 8440:8440 \ sandbox /usr/sbin/sshd -D Now save the file: Press ESC key :wq! Do commit/update your changes in sandbox by below command; docker commit sandbox sandbox or docker commit Enable sandbox.service: systemctl enable sandbox.service Reboot the VM init 6 verify new ports: docker ps | grep 8440 Update vm port number: Right click virtual box settings by below mentioned in screenshot:  After selecting settings menu, select Network icon: In...

Hue Installation

Image
Hue - Hadoop User Experience What is Hue? ●      Hue is a Web interface for analyzing data with Apache Hadoop. ●      Query and visualize data directly from your Browser. Installation Prerequisites: 1.     Centos 6/7 2.     Hdp 2.3 above 3.     Apache ambari 1.7 above. Preparing Environment and downloading Hue: ●      Sudo yum groupinstall "Development Tools" ●      Sudo yum install ant ●      Sudo yum install gcc g++ ●      Sudo yum install libkrb5-dev libmysqlclient-dev ●      Sudo yum install libssl-dev libsasl2-dev libsasl2-modules-gssapi-mit ●      Sudo yum install libsqlite3-dev ●      Sudo yum install libtidy-0.99-0 libxml2-dev libxslt-dev ●      Apache maven install:       ...

RESTful Webservices Environment Setup:

Image
Prequistes: 1.  JDK 8 installation on ubuntu:                   i)  sudo add-apt-repository ppa:webupdteam/java -y                  ii) sudo apt-get update                  iii) sudo apt-get install oracle-java8-installer                    iv)  Check java version : java -version  2.  Nebeans installation on ubuntu:                             i)  Download and install Netbeans from this  URL .                   ii) Give Executable Permission:                              $ chmod +x  ~/Downloads/Netbeans-8.2-linux-*.sh         ...