Forem: Dbaport

Free SSL enable on website on cloud server !

Dbaport — Wed, 04 Mar 2020 05:08:53 +0000

Here I'm writing some step as demo.
My website on AWS server.Pleas read carefully , this is easiest way.

1.Download .pem file (db_Oregon_Keypair.pem)

2.Given Execute Permission to .pem file (read/write)

Step:
1- open terminal
2- sudo chmod 777 db_Oregon_Keypair.pem

3.sudo ssh -i db_Oregon_Keypair.pem ubuntu@www.dbaport.com
4.sudo certbot certonly (Select 1 -Apache Plugin)
5.sudo certbot (Select 1,4- dbaport domain)

Easy way to Install Docker on Ubuntu

Dbaport — Wed, 04 Mar 2020 05:00:43 +0000

curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add -
sudo add-apt-repository "deb [arch=amd64] https://download.docker.com/linux/ubuntu $(lsb_release -cs) stable"
sudo apt-get update
sudo apt install docker.io - For Official Ubuntu Repositories
--------next step ->>>
sudo docker ps
sudo chmod 777 /var/run/docker.sock
sudo docker container ls
sudo docker image ls
sudo docker run hello-world - for normal test
docker-compose up
project setup according to developer:-
mvn openmrs-sdk:setup -DserverId=dserver1 -Ddistro=nwhdistribution-package:1.0.3-SNAPSHOT
Wait untill finish

Mysql 5.6 isn't supported on ubuntu 18.04 version

Dbaport — Wed, 04 Mar 2020 04:58:54 +0000

sudo add-apt-repository 'deb http://archive.ubuntu.com/ubuntu trusty universe'
sudo apt-get update
sudo apt install mysql-server-5.6 mysql-client-5.6
sudo service mysql restart / sudo /etc/init.d/mysql restart
mysql -u root -p

sudo /etc/mysql/mysql.conf.d/mysqld.cnf
Then -> bind-address = 127.0.0.1 to bind-address = 0.0.0.0
sudo systemctl restart mysql.service
sudo apt install mysql-workbench

OpenVPN Installation step by step

Dbaport — Wed, 04 Mar 2020 04:56:12 +0000

sudo apt install openvpn easy-rsa
cd /etc/openvpn
sudo chmod 400 /etc/openvpn

Paste crt , conf and other file in /etc/openvpn

cd /usr/bin/
sudo nano vpn.sh
sudo /usr/bin/vpn.sh
sudo nano /usr/bin/vpn.sh

!/bin/bash

cd /etc/openvpn
nohup openvpn --config sumant.conf &
sudo chmod +x /usr/bin/vpn.sh
sudo /usr/bin/vpn.sh

you can also use best GUI tool Pritunl

GUI Remote Desktop For Windows and Linux

Dbaport — Wed, 04 Mar 2020 04:52:47 +0000

sudo apt-get update

sudo apt install xrdp

sudo systemctl enable xrdp

Grant user remote accesse on client machine.

sudo apt-get install xauth

Then use username and passord.

rdesktop -d dbaport.com -u sumantk -fP remote IP

Domain join in linux step by step

Dbaport — Wed, 04 Mar 2020 04:50:25 +0000

Install the Centrify DC then run the below Command

Run the Centrify DC setup.

adjoin Command

sudo adjoin -w dbaport.com -u sumantk

adleave command

sudo adleave -w dbaport.com -u sumantk

Common Linux log files names and usage

Dbaport — Wed, 04 Mar 2020 04:46:36 +0000

/var/log/messages : General message and system related stuff
/var/log/auth.log : Authenication logs
/var/log/kern.log : Kernel logs
/var/log/cron.log : Crond logs (cron job)
/var/log/maillog : Mail server logs
/var/log/qmail/ : Qmail log directory (more files inside this directory)
/var/log/httpd/ : Apache access and error logs directory
/var/log/lighttpd/ : Lighttpd access and error logs directory
/var/log/boot.log : System boot log
/var/log/mysqld.log : MySQL database server log file
/var/log/secure or /var/log/auth.log : Authentication log
/var/log/utmp or /var/log/wtmp : Login records file
/var/log/yum.log : Yum command log fil

iptable any port enable

Dbaport — Wed, 04 Mar 2020 04:44:49 +0000

Login to your server and follow the below steps.
Step-1 : iptables-save > iptable.bak
Step-2 : vim iptable.bak
-> Press i and paste the below rule
-> A INPUT -p tcp -m state --state NEW -m tcp --dport -j ACCEPT
-> To paste the rule press Ctrl+Shift+V
-> Then press ESC and then enter :wq! and hit ENTER to save and exit
Step-3 : iptables-restore < iptable.bak
Step-4 : iptables-save
Step-5 : service iptables restart
Step-6 : iptables -L
Post doing the above steps, please check if you're able to access it now.

How to Encrypt a Drive on Ubuntu 18.04

Dbaport — Tue, 18 Feb 2020 10:16:36 +0000

Enable disk encryption after installation

Here I have two disk drive .

SSD as / (root partition)
HDD as /home (home partition)
Installing Cryptsetup:-

$ sudo apt-get install cryptsetup

$ sudo apt-get install lvm2

Copy /home to another location

sudo -i

sudo mkdir /data –> make directory for copy data

sudo cp -avi sumantk /data –> Copy the home

sudo vi /etc/passwd –> change the home path for unmount /home

Unmount the drive

umount /dev/sda1

Format & change to lvm type

sudo mkfs.ext4 /dev/sda1

Format & change to lvm type

pvcreate /dev/sda4

vgcreate vg_home /dev/sda4

lvcreate -n lv_home -l 100%FREE vg_home

cryptsetup luksFormat /dev/mapper/vg_home-lv_home

cryptsetup luksOpen /dev/mapper/vg_home-lv_home mycrypt

mkfs -t ext4 /dev/mapper/mycrypt

vim /etc/crypttab

mycrypt /dev/mapper/vg_home-lv_home

Make a entry in fstab file

vi /etc/fstab

/dev/mapper/mycrypt /home ext4 defaults 0 2

/dev/mapper/vg_home-lv_home /home ext4 defaults 0 2

Get to Know Our Roots

Dbaport — Tue, 18 Feb 2020 10:12:48 +0000

Dbaport Technology is carving a growing niche for itself by applying high-level skills and expertise on its clients’ behalf in the Enterprise Database Management arena.

The company has been around since 2016 and has built an outstanding reputation for its expert knowledge and delivery. Both Microsoft and Oracle rate Dbaport Technology in the top select handful of organization’s in the Enterprise Database Management area of specialization.

Our team of 40+ permanent, highly skilled Database Administrators and Consultants bring many years of experience to the table. In addition, as they interact across a range of different sites, their level of experience continues to rise, adding further value to clients.

We foster a heterogeneous Database Technology and Services strategy. Our expertise covers a comprehensive range of Database Technologies – including Microsoft SQL Server, Oracle Database, MySQL, MariaDB, MongoDB, Azure Cosmos DB, PostgreSQL and Sybase. This means that focus is always on service and suitability rather than on product.

The Dbaport Technology services are structured to allow clients the flexibility to choose the engagement model, which suits their needs.