Index: .well-known/assetlinks.json =================================================================== --- .well-known/assetlinks.json (revision b5bae2470a5cdf5ae561708274d413dbf680523b) +++ .well-known/assetlinks.json (revision b5bae2470a5cdf5ae561708274d413dbf680523b) @@ -0,0 +1,12 @@ +[ + { + "relation": ["delegate_permission/common.handle_all_urls"], + "target": { + "namespace": "android_app", + "package_name": "com.roboburr.app", + "sha256_cert_fingerprints": [ + "92:2F:55:C4:36:4C:8D:DA:99:0C:63:18:BA:78:A3:76:AD:B9:AD:77:E5:AA:68:54:16:FE:FB:28:62:11:EB:DB" + ] + } + } +] Index: deploy/DEPLOY.md =================================================================== --- deploy/DEPLOY.md (revision b5bae2470a5cdf5ae561708274d413dbf680523b) +++ deploy/DEPLOY.md (revision b5bae2470a5cdf5ae561708274d413dbf680523b) @@ -0,0 +1,224 @@ +# PrutCMS v10 — Deployment Guide + +End-to-end production install on a fresh Ubuntu 22.04 / Debian 12 VPS +(TransIP, Hetzner, etc.). Assumes a non-root user with sudo. + +--- + +## 0. Prerequisites + +- VPS with Ubuntu 22.04 LTS or Debian 12. +- DNS A/AAAA records for your domain pointing at the server's IP. Wait for + propagation (`dig +short YOUR-DOMAIN` should return the right IP) before + running certbot. +- SSH access as a non-root user (e.g. `robin`). + +--- + +## 1. System packages + +```bash +sudo apt update && sudo apt upgrade -y +sudo apt install -y curl ca-certificates git nginx ufw sqlite3 +``` + +Install Node.js 20 LTS via NodeSource (don't use the OS-default — it's old): + +```bash +curl -fsSL https://deb.nodesource.com/setup_20.x | sudo -E bash - +sudo apt install -y nodejs +node --version # should print v20.x.x +``` + +Install PM2 globally: + +```bash +sudo npm install -g pm2 +``` + +--- + +## 2. Firewall + +```bash +sudo ufw allow OpenSSH +sudo ufw allow 'Nginx Full' # opens 80 + 443 +sudo ufw enable +``` + +--- + +## 3. App user + project clone + +```bash +# As root or via sudo, create a deploy user if you don't already have one +# (skip if you're already on a non-root user) + +# As your user: +mkdir -p ~/prutcms +cd ~/prutcms +# Clone or rsync your code here. e.g. via git: +# git clone . + +npm ci --omit=dev +``` + +`ensureLocalHtmx()` in `server.js` will copy the bundled HTMX from +`node_modules/htmx.org/dist/htmx.min.js` to `src/assets/js/htmx.min.js` on +first boot. You don't have to do that step manually. + +--- + +## 4. Environment variables + +Create `.env` in the project root: + +```ini +NODE_ENV=production +PORT=3000 + +# 32+ random hex chars — required, the app refuses to boot without it. +# Generate: openssl rand -hex 32 +SESSION_SECRET= + +# Optional: pin the audio HMAC secret instead of letting the app generate one +# in storage/.audio-secret. Generate the same way as SESSION_SECRET. +# AUDIO_SECRET= + +# Optional: override storage paths +# DATABASE_PATH=/home/robin/prutcms/storage/database.sqlite +# AUDIO_PATH=/home/robin/prutcms/storage/audio +# AVATAR_PATH=/home/robin/prutcms/storage/media/avatars +# COVER_PATH=/home/robin/prutcms/storage/media/audio-covers +# MEDIA_PATH=/home/robin/prutcms/storage/media +``` + +`chmod 600 .env` — keep it readable only by your user. + +--- + +## 5. First boot + +```bash +npm run migrate # creates storage/database.sqlite + tables +``` + +Then start with PM2: + +```bash +pm2 start ecosystem.config.cjs --env production +pm2 save +pm2 startup # follow the printed command to make PM2 survive reboots +``` + +Check it's up: + +```bash +curl -I http://127.0.0.1:3000/ # expect 200 / 302 +pm2 logs prutcms # live logs; Ctrl-C to detach +``` + +Register your first user (becomes god) by visiting +`http://YOUR-SERVER-IP:3000/auth/register` BEFORE you point nginx at it +(or just wait until SSL is up — registration works the same). + +--- + +## 6. nginx + SSL + +```bash +sudo cp deploy/nginx.conf.example /etc/nginx/sites-available/prutcms +sudo $EDITOR /etc/nginx/sites-available/prutcms # replace +sudo ln -s /etc/nginx/sites-available/prutcms /etc/nginx/sites-enabled/ +sudo rm -f /etc/nginx/sites-enabled/default +sudo nginx -t +sudo systemctl reload nginx +``` + +Install certbot and provision certs: + +```bash +sudo apt install -y certbot python3-certbot-nginx +sudo mkdir -p /var/www/letsencrypt +sudo certbot --nginx -d YOUR-DOMAIN -d www.YOUR-DOMAIN +``` + +Certbot edits the nginx config in place to wire in the certificate paths. +Renewals run automatically via the certbot systemd timer; verify with: + +```bash +sudo systemctl status certbot.timer +``` + +Now visit `https://YOUR-DOMAIN/`. You should see your site over HTTPS, with +HSTS active and Prutter WebSocket working (browser dev-tools → Network → +filter "WS" → see the `wss://YOUR-DOMAIN/ws/prutter` connection). + +--- + +## 7. Backups + +```bash +chmod +x deploy/backup.sh +mkdir -p ~/backups/prutcms ~/prutcms/logs + +# Test it once +./deploy/backup.sh + +# Schedule nightly at 03:00 +( crontab -l 2>/dev/null ; \ + echo "0 3 * * * /home/$USER/prutcms/deploy/backup.sh >> /home/$USER/prutcms/logs/backup.log 2>&1" \ +) | crontab - + +crontab -l # verify +``` + +Restore is a tar -xzf into a clean directory + `npm ci` + start. + +--- + +## 8. Updating + +```bash +cd ~/prutcms +git pull +npm ci --omit=dev +pm2 reload prutcms # zero-downtime within fork mode +``` + +The DB schema migrates automatically on boot (`ensureColumn` adds new columns +idempotently). For destructive changes you'd need to write an explicit +migration — not yet needed. + +--- + +## 9. Multi-tenant setup + +After your first user/site is created (auto on first registration), use +`/admin/sites` to create more sites. Each site gets its own URL prefix +(`/sites//`) and its own PWA scope, so installing the PWA from one +site won't navigate into another. + +--- + +## 10. Troubleshooting + +| Symptom | Check | +|---|---| +| `❌ FATAL: SESSION_SECRET is required` | `.env` missing or unreadable. `pm2 stop prutcms && pm2 start ecosystem.config.cjs --env production`. | +| `❌ FATAL: SESSION_SECRET too weak for production` | Make it 32+ chars: `openssl rand -hex 32`. | +| WS disconnects every minute | Check nginx `proxy_read_timeout` is ≥ 90s in `/ws/` block. | +| Audio plays but seek stutters | nginx must have `proxy_buffering off` on `/audio/stream/`. | +| 502 from nginx | `pm2 list` — is the app up? `pm2 logs prutcms --lines 100`. | +| HTMX 404s on `/assets/js/htmx.min.js` | `ls node_modules/htmx.org/dist/htmx.min.js` — if missing, `npm install htmx.org`. The boot-copy step needs the package. | + +--- + +## 11. What's NOT included + +- Email sending (password reset prints the URL to the console / page in + non-production). Hook up an SMTP or transactional service when needed. +- Cluster mode / horizontal scaling. Single fork only — see comments in + `ecosystem.config.cjs` for what would have to change first. +- Off-site backup replication. The local rotation keeps 14 days; copy the + tar.gz files off-server with rsync/restic/whatever you prefer. Index: deploy/backup.sh =================================================================== --- deploy/backup.sh (revision b5bae2470a5cdf5ae561708274d413dbf680523b) +++ deploy/backup.sh (revision b5bae2470a5cdf5ae561708274d413dbf680523b) @@ -0,0 +1,52 @@ +#!/usr/bin/env bash +# +# PrutCMS v10 — nightly backup script. +# +# Snapshots: +# • SQLite database (uses .backup so it's safe while the app is running) +# • storage/audio/ (uploaded MP3s — files outside /media for security) +# • storage/media/ (avatars, audio covers — public files) +# • storage/.audio-secret (HMAC secret — needed to verify old signed URLs) +# +# Output: a single tar.gz per run in $BACKUP_DIR, named by timestamp. +# Rotation: keeps the last $KEEP_DAYS dumps, prunes older. +# +# Recommended cron: +# 0 3 * * * /home/robin/prutcms/deploy/backup.sh >> /home/robin/prutcms/logs/backup.log 2>&1 + +set -euo pipefail + +# ── Config ──────────────────────────────────────────────────────── +APP_DIR="${APP_DIR:-/home/robin/prutcms}" +BACKUP_DIR="${BACKUP_DIR:-/home/robin/backups/prutcms}" +KEEP_DAYS="${KEEP_DAYS:-14}" +TS="$(date +%Y%m%d-%H%M%S)" + +mkdir -p "$BACKUP_DIR" + +# ── DB snapshot via sqlite3 .backup (consistent under WAL) ──────── +DB_FILE="$APP_DIR/storage/database.sqlite" +DB_SNAPSHOT="$BACKUP_DIR/db-$TS.sqlite" +if [ -f "$DB_FILE" ]; then + sqlite3 "$DB_FILE" ".backup '$DB_SNAPSHOT'" +else + echo "WARN: $DB_FILE not found, skipping DB backup" >&2 +fi + +# ── Tar the snapshot + storage subdirs ──────────────────────────── +ARCHIVE="$BACKUP_DIR/prutcms-$TS.tar.gz" +tar -czf "$ARCHIVE" \ + -C "$BACKUP_DIR" "$(basename "$DB_SNAPSHOT")" \ + -C "$APP_DIR/storage" \ + $( [ -d "$APP_DIR/storage/audio" ] && echo audio ) \ + $( [ -d "$APP_DIR/storage/media" ] && echo media ) \ + $( [ -f "$APP_DIR/storage/.audio-secret" ] && echo .audio-secret ) + +# Remove the loose db-XXX.sqlite (it's inside the tarball now) +rm -f "$DB_SNAPSHOT" + +# ── Rotation ─────────────────────────────────────────────────────── +find "$BACKUP_DIR" -type f -name 'prutcms-*.tar.gz' -mtime "+$KEEP_DAYS" -delete + +SIZE="$(du -h "$ARCHIVE" | cut -f1)" +echo "[$TS] backup OK: $ARCHIVE ($SIZE)" Index: deploy/nginx.conf.example =================================================================== --- deploy/nginx.conf.example (revision b5bae2470a5cdf5ae561708274d413dbf680523b) +++ deploy/nginx.conf.example (revision b5bae2470a5cdf5ae561708274d413dbf680523b) @@ -0,0 +1,126 @@ +# ────────────────────────────────────────────────────────────────── +# PrutCMS v10 — nginx reverse proxy +# +# Place this in /etc/nginx/sites-available/prutcms and symlink to +# /etc/nginx/sites-enabled/. Replace with the real host. +# +# Key points: +# • SSL termination here; Node listens on 127.0.0.1:3000 only. +# • WebSocket upgrade headers wired through (Prutter live messaging). +# • Static assets cached aggressively (Node gives them 1y maxAge anyway). +# • Audio streaming endpoint /audio/stream/* must NOT be cached by nginx — +# each request carries a different signed token and is byte-range based. +# • HSTS + security headers added at the proxy. +# +# After installing: +# sudo ln -s /etc/nginx/sites-available/prutcms /etc/nginx/sites-enabled/ +# sudo nginx -t +# sudo systemctl reload nginx +# +# Then provision SSL: +# sudo certbot --nginx -d -d www. +# certbot will edit this file in place to insert the cert paths. +# ────────────────────────────────────────────────────────────────── + +# WebSocket connection upgrade map (let nginx set it once globally) +map $http_upgrade $connection_upgrade { + default upgrade; + '' close; +} + +# Redirect HTTP → HTTPS +server { + listen 80; + listen [::]:80; + server_name www.; + + # Let's Encrypt http-01 challenge path + location /.well-known/acme-challenge/ { + root /var/www/letsencrypt; + } + + location / { + return 301 https://$host$request_uri; + } +} + +server { + listen 443 ssl http2; + listen [::]:443 ssl http2; + server_name www.; + + # certbot will fill these in: + # ssl_certificate /etc/letsencrypt/live//fullchain.pem; + # ssl_certificate_key /etc/letsencrypt/live//privkey.pem; + ssl_protocols TLSv1.2 TLSv1.3; + ssl_ciphers ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305; + ssl_prefer_server_ciphers off; + ssl_session_cache shared:SSL:10m; + ssl_session_timeout 1d; + ssl_stapling on; + ssl_stapling_verify on; + + # Security headers (Helmet adds them at the app too — these are belt+braces) + add_header Strict-Transport-Security "max-age=31536000; includeSubDomains; preload" always; + add_header X-Frame-Options "SAMEORIGIN" always; + add_header X-Content-Type-Options "nosniff" always; + add_header Referrer-Policy "no-referrer-when-downgrade" always; + + # Reasonable body size — accommodates 50 MB MP3 uploads with headroom + client_max_body_size 60M; + + # Compression + gzip on; + gzip_types text/plain text/css application/json application/javascript application/xml application/atom+xml application/rss+xml image/svg+xml; + gzip_min_length 256; + + # ── Static assets: serve via Node, but tell upstream they're long-cached. + location /assets/ { + proxy_pass http://127.0.0.1:3000; + proxy_set_header Host $host; + proxy_cache_valid 200 1y; + add_header Cache-Control "public, max-age=31536000, immutable"; + } + + # ── Audio streaming: pass through, no caching, no buffering (HTML5