cambium-hosting

What problem does it solve?

Provides clear, actionable operational guidance to deploy, manage, and replicate the Cambium platform across three environments (shop server, Phteah-Pi home replica, and Railway cloud replica), reducing downtime and preventing schema drift or misconfiguration when updating APIs, services, tunnels, or databases.

Core Features & Use Cases

• Authoritative on-prem deployment: Step-by-step manual publish and service replacement workflow for the shop server where the shop is the source of truth.
• Windows Service operations: Guidance for checking, stopping, and starting the CambiumApi Windows Service and where the service publish artifacts must be placed.
• Database replication and sync: Patterns for pg_dump/pg_restore workflows, ownership fixes, recommended restore flags for Railway dumps, and scheduled SyncCli replication to the Pi.
• Cloud and remote access: Cloudflare tunnel and SSH-tunnel notes for remote access, Railway connection quirks and schema checks, and WireGuard VPN topology for secure replication.
• Operational safety practices: Warnings about treating Railway as a replica, enforcing schema-checks before pushes, handling BCrypt and password rotation quirks, and avoiding CI/CD to the shop server.

Quick Start

Build the API publish output, stop the CambiumApi service with administrative privileges, copy the publish folder to the service publish location on the shop server, and restart the service to deploy the new API.