agalan

list all services running

initctl list

service --status-all

apt update

Installing services

 apt install nginx postgresql nodejs

nano /etc/nginx/sites-enabled/default

root /data/rw3/agalan/html;
index index.html index.htm;

list files installed by nginx using the package manager

sudo dpkg -L nginx

make sure that nginx is up, running and listening to port 80

sudo netstat -anp | grep 80

make sure that Postgresql is up

pidof postgresql
sudo netstat -anp | grep postgres

create a database
using port forwarding, access this database using the pgadmin3 GUI from your workstation

sudo passwd postgres
psql -d postgres




CREATE USER agalan ;
ALTER ROLE agalan PASSWORD 'xxxxx';
CREATE ROLE agalan SUPERUSER;
ALTER ROLE agalan LOGIN; (without password);
CREATE DATABASE mr1;
CREATE SCHEMA mr1;
GRANT ALL ON DATABASE mr1 TO agalan;
GRANT ALL ON SCHEMA mr1 TO agalan;

  ssh -L 5432:localhost:5432 agalan@lcert