Update Server: apt update && apt upgrade -y Install Focalboard: sudo apt install wget VER=$(curl -s https://api.github.com/repos/mattermost/focalboard/releases/latest|grep tag_name | cut -d '"' -f 4) wget https://github.com/mattermost/focalboard/releases/download/${VER}/focalboard-server-linux-amd64.tar.gz tar -xvzf focalboard-server-linux-amd64.tar.gz sudo mv focalboard /opt Install and Configure NGINX: sudo apt update sudo apt install nginx sudo vi /etc/nginx/sites-available/focalboard paste ------ upstream focalboard { server localhost:8000; keepalive 32; } server { listen 80 default_server; server_name server _ip; location ~ /ws/* { proxy_set_header Upgrade $http_upgrade; proxy_set_header Connection "upgrade"; client_max_body_size 50M; proxy_set_header Host $http_host; proxy_set_header X-Real-IP $remote_addr; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header X-Forwarded-Proto $scheme; proxy_set_header X-Frame-Options SAMEORIGIN; proxy_buffers 256 16k; proxy_buffer_size 16k; client_body_timeout 60; send_timeout 300; lingering_timeout 5; proxy_connect_timeout 1d; proxy_send_timeout 1d; proxy_read_timeout 1d; proxy_pass http://focalboard; } location / { client_max_body_size 50M; proxy_set_header Connection ""; proxy_set_header Host $http_host; proxy_set_header X-Real-IP $remote_addr; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header X-Forwarded-Proto $scheme; proxy_set_header X-Frame-Options SAMEORIGIN; proxy_buffers 256 16k; proxy_buffer_size 16k; proxy_read_timeout 600s; proxy_cache_revalidate on; proxy_cache_min_uses 2; proxy_cache_use_stale timeout; proxy_cache_lock on; proxy_http_version 1.1; proxy_pass http://focalboard; } } -------------- Remove the default Nginx site: sudo rm /etc/nginx/sites-enabled/default Enable the site: sudo ln -s /etc/nginx/sites-available/focalboard /etc/nginx/sites-enabled/focalboard sudo nginx -t sudo systemctl restart nginx Install PostgreSQL: sudo apt install postgresql postgresql-contrib sudo --login --user postgres psql CREATE DATABASE boards; CREATE USER boardsuser WITH PASSWORD 'Passw0rd'; \q exit Configure Focalboard to use the database: vi /opt/focalboard/config.json update "dbtype": "postgres", "dbconfig": "postgres://boardsuser:Passw0rd@localhost/boards?sslmode=disable&connect_timeout=10", Manage the Focalboard Service: sudo vi /lib/systemd/system/focalboard.service paste ------------ [Unit] Description=Focalboard server [Service] Type=simple Restart=always RestartSec=5s ExecStart=/opt/focalboard/bin/focalboard-server WorkingDirectory=/opt/focalboard [Install] WantedBy=multi-user.target ---------- sudo systemctl daemon-reload sudo systemctl start focalboard.service sudo systemctl enable focalboard.service systemctl status focalboard.service Access the Focalboard Web UI: http://server _ip ... https://www.youtube.com/watch?v=NJyXi0pQBGg

Update Server: apt update && apt upgrade -y Install Monit: apt install monit -y systemctl status monit Configure Monit: nano /etc/monit/monitrc uncomment set httpd port 2812 and allow admin:yourpassword monit -t Install apache and mariadb: apt install apache2 mariadb-server -y ln -s /etc/monit/conf-available/apache2 /etc/monit/conf-enabled/ ln -s /etc/monit/conf-available/mysql /etc/monit/conf-enabled/ systemctl restart monit ss -plunt | grep 2812 http://server_ip:2812 ... https://www.youtube.com/watch?v=wrwUOMpFtQo

Update System: apt update && apt upgrade -y Install Docker: sudo apt-get install \ ca-certificates \ curl \ gnupg \ lsb-release # Add Docker’s official GPG key curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo gpg --dearmor -o /usr/share/keyrings/docker-archive-keyring.gpg # Set up stable repository ##### i'm replacing angled bracke with square bracket########### echo \ "deb [arch=$(dpkg --print-architecture) signed-by=/usr/share/keyrings/docker-archive-keyring.gpg] https://download.docker.com/linux/ubuntu \ $(lsb_release -cs) stable" | sudo tee /etc/apt/sources.list.d/docker.list ] /dev/null # Install Docker Engine sudo apt-get update sudo apt-get install docker-ce docker-ce-cli containerd.io # Install Docker Compose sudo curl -L "https://github.com/docker/compose/releases/download/1.29.2/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose sudo chmod +x /usr/local/bin/docker-compose sudo ln -s /usr/local/bin/docker-compose /usr/bin/docker-compose # Test the installation docker-compose --version Install npm: mkdir -p npm # Make sure you're in the Nginx Proxy Manager directory cd npm # Create a docker-compose configuration file touch docker-compose.yml # Editing the file nano docker-compose.yml paste version: '3' services: app: image: 'jc21/nginx-proxy-manager:latest' restart: unless-stopped ports: - '80:80' - '81:81' - '443:443' volumes: - ./data:/data - ./letsencrypt:/etc/letsencrypt docker-compose up -d http://server_ip:81 Default admin user: Email: admin@example.com Password: changeme ... https://www.youtube.com/watch?v=1S7f03ruubA

Update Server: apt update && apt upgrade -y Add PostgreSQL 13 repository: sudo apt install curl gpg gnupg2 software-properties-common apt-transport-https lsb-release ca-certificates curl -fsSL https://www.postgresql.org/media/keys/ACCC4CF8.asc|sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/postgresql.gpg echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" |sudo tee /etc/apt/sources.list.d/pgdg.list Install PostgreSQL 13: sudo apt update sudo apt install postgresql-13 postgresql-client-13 systemctl status postgresql@13-main.service Test PostgreSQL Connection: sudo su - postgres psql CREATE DATABASE mytestdb; CREATE USER mytestuser WITH ENCRYPTED PASSWORD 'your_password'; GRANT ALL PRIVILEGES ON DATABASE mytestdb to mytestuser; \q exit Add pgAdmin4 repository: curl -fsSL https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/pgadmin.gpg sudo sh -c 'echo "deb ### I'm replacing angled bracket with square bracket ### https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" ] /etc/apt/sources.list.d/pgadmin4.list' cat /etc/apt/sources.list.d/pgadmin4.list Install pgAdmin4: sudo apt update sudo apt install pgadmin4 systemctl status apache2 Configure Apache Web Server: sudo /usr/pgadmin4/bin/setup-web.sh Access pgAdmin 4 Web interface: sudo ufw allow http sudo ufw allow https server_ip/pgadmin4 ... https://www.youtube.com/watch?v=m4TDO34a6vQ