System Administration

Ubuntu Linux — Open Connection to All Hosts Prerequisites Fresh Ubuntu instance (20.04, 22.04, or 24.04) Sudo privileges Internet access Step 1 — Add the PostgreSQL APT Repository Install dependencies and import the official PostgreSQL signing key: sudo apt install…

Overview, Download, and Installation Guide for Linux 1. Overview Cisco AnyConnect Secure Mobility Client is an enterprise VPN solution used to provide secure remote access to private networks. It establishes an encrypted connection between a user’s device and an organisation’s…

Technical Implementation Guide Overview This document describes the successful implementation of direct communication between a laboratory analyzer and custom middleware, bypassing traditional laboratory middleware solutions like REMISOL Advance. Architecture Laboratory Analyzer (Client) ↓ ASTM Protocol over TCP/IP Middleware/Script Communicator (Server)…

Prerequisites Install sqlcmd (Linux/Ubuntu) # Add Microsoft repository curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add – # For Ubuntu 22.04 curl https://packages.microsoft.com/config/ubuntu/22.04/prod.list | sudo tee /etc/apt/sources.list.d/mssql-release.list # For Ubuntu 20.04 curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list | sudo tee /etc/apt/sources.list.d/mssql-release.list # Install sudo apt-get update…

Provide secure, auditable access to internal servers by routing admin SSH sessions through a hardened bastion host. Prerequisites SSH keypair present (private key kept secure). Bastion host reachable from your client. Bastion user account with key-based auth and, ideally, multi-factor…

Add persistent swap space to prevent OOM errors on memory-constrained VPS. Quick Setup # Create 4GB swap file sudo fallocate -l 4G /swapfile sudo chmod 600 /swapfile sudo mkswap /swapfile sudo swapon /swapfile # Make persistent across reboots echo ‘/swapfile…

Overview This guide covers setting up Cloudflare Origin Certificates with custom SSL paths for Docker Compose applications. Origin Certificates are free and included in Cloudflare’s free tier. Prerequisites Domain managed by Cloudflare (free plan or higher) Docker Compose application with…

Prerequisites Docker and Docker Compose installed Nginx running in Docker container Certbot installed on host Sudo access Step 1: Configure Passwordless Sudo Install certbot sudo apt install certbot Allow certbot to run without password prompts: # Create sudoers entry echo…

Step 1: Check for existing SSH keys Check if you already have an SSH key: ls -al ~/.ssh Look for files like id_rsa, id_ed25519, or id_ecdsa. Step 2: Generate a new SSH key (if needed) If you don’t have an SSH key, generate…