Posts

Showing posts from 2018

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