DigitalOcean Cloud Config

Initial Config

1. Create a Droplet of Centos7
2. Add SSH before create Croplet
3. Add domain

Local Time

sudo cp /usr/share/zoneinfo/Asia/Dhaka /etc/localtime
date
cal

YUM Update

sudo su
yum -y update
yum -y install yum-utils
yum -y groupinstall development

Install Ruby 2.0

yum install ruby
ruby -v

Install PHP 5.4

yum install httpd
yum install php

apachectl restart
systemctl status httpd

Update PHP 7.0

cd ~
curl 'https://setup.ius.io/' -o setup-ius.sh
bash setup-ius.sh
rm -rf setup-ius.sh 

yum remove php-cli mod_php php-common
yum install mod_php70u php70u-cli php70u-mysqlnd

apachectl restart
systemctl status httpd

mkdir -p /var/www/html/test
# write phpinfo() code here
vi /var/www/html/test/test.php

Install Python 3.6

# centos7.iuscommunity.org
yum -y install https://centos7.iuscommunity.org/ius-release.rpm
yum -y install python36u

# check your python version
python3.6 -V

# install pip for Python 3.6 
yum -y install python36u-pip
yum -y install python36u-devel

# configure virtual env
cd /opt/;mkdir dev pro;cd dev
python3.6 -m venv venv
source venv/bin/activate

# check version of python & pip
pip -V
python -V
deactivate

Install MySQL

cd ~
yum install wget
wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
md5sum mysql57-community-release-el7-9.noarch.rpm
rpm -ivh mysql57-community-release-el7-9.noarch.rpm
rm -rf mysql57-community-release-el7-9.noarch.rpm 

yum install mysql-server
systemctl start mysqld
systemctl status mysqld

grep 'temporary password' /var/log/mysqld.log
mysql_secure_installation
mysqladmin -u root -p version

mysql -u root -p
mysql -h localhost -u root -p
mysql -h 127.0.0.1 -u root -p

Install Oracle JDK

cd ~
wget --no-cookies --no-check-certificate --header \
"Cookie: gpw_e24=http%3A%2F%2Fwww.oracle.com%2F; oraclelicense=accept-securebackup-cookie" \
"http://download.oracle.com/otn-pub/java/jdk/8u152-b16/aa0333dd3019491ca4f6ddbe78cdb6d0/jdk-8u152-linux-x64.rpm"

yum localinstall jdk-8u152-linux-x64.rpm
java  -version
javac -version

# remove to free cloud storage
rm -rf jdk-8u152-linux-x64.rpm

Install Apache Ant

cd /opt/cli/
wget http://www-us.apache.org/dist//ant/binaries/apache-ant-1.9.9-bin.zip
unzip  apache-ant-1.9.9-bin.zip
rm -rf apache-ant-1.9.9/manual/
rm -rf apache-ant-1.9.9-bin.zip

# ant home and path setting to ~/.bash_profile
export ANT_HOME="/opt/cli/apache-ant-1.9.9"
export PATH="$PATH:$ANT_HOME/bin"
ant -version

Install Apache Maven

cd /opt/cli/
wget https://repo.maven.apache.org/maven2/org/apache/maven/apache-maven/3.3.9/apache-maven-3.3.9-bin.zip
unzip   apache-maven-3.3.9-bin.zip
rm -rf  apache-maven-3.3.9-bin.zip

# m2 home and path setting to ~/.bash_profile
export M2_HOME="/opt/cli/apache-maven-3.3.9"
export PATH="$PATH:$M2_HOME/bin"
mvn -v

Oracle Instant Client

See the Instant Client Home Page for more information about Instant Client. The installation instructions are at the foot of the page. Following zip files download from Instant Client for Linux x86-64

1. instantclient-basic-linux.x64-12.2.0.1.0.zip
2. instantclient-odbc-linux.x64-12.2.0.1.0-2.zip
3. instantclient-sdk-linux.x64-12.2.0.1.0.zip
4. instantclient-sqlplus-linux.x64-12.2.0.1.0.zip
5. instantclient-tools-linux.x64-12.2.0.1.0.zip

scp ~/Downloads/instantclient-*.zip  dev.chorke.org:/opt/cli/oracle/oracle12c/
ssh dev.chorke.org

cd /opt/cli/oracle/oracle12c/
unzip instantclient-basic-linux.x64-12.2.0.1.0.zip
unzip instantclient-odbc-linux.x64-12.2.0.1.0-2.zip
unzip instantclient-sdk-linux.x64-12.2.0.1.0.zip
unzip instantclient-sqlplus-linux.x64-12.2.0.1.0.zip
unzip instantclient-tools-linux.x64-12.2.0.1.0.zip
rm -rf instantclient-*.zip

cd instantclient_12_2/
ln -s libocci.so.12.1 libocci.so
ln -s libclntsh.so.12.1 libclntsh.so
mkdir -p /opt/cli/oracle/oracle12c/instantclient_12_2/network/admin

yum install libaio
sh -c "echo /opt/cli/oracle/oracle12c/instantclient_12_2 > /etc/ld.so.conf.d/oracle-instantclient.conf"
ldconfig

# export LD_LIBRARY_PATH="/opt/cli/oracle/oracle12c/instantclient_12_2:$LD_LIBRARY_PATH"
export LD_LIBRARY_PATH="/opt/cli/oracle/oracle12c/instantclient_12_2"
export PATH="$LD_LIBRARY_PATH:$PATH"

Kill Process

# kill -9 pid
kill -9 10151

Bash History

# clear all
history -c

# overwrite 
history -w

# delete by offset
history -d 2013
history -w