Skip to main content

Vikunja on Google Cloud Run

Vikunja on Google Cloud Run

Vikunja is an open-source, self-hosted to-do and project management application — lists, kanban boards, gantt charts, calendars, reminders, and team sharing via a REST API and web UI. This module deploys Vikunja on Cloud Run v2 on top of the App_CloudRun foundation, which provisions and manages the shared Google Cloud infrastructure.

This guide focuses on the cloud services Vikunja uses and how to explore and operate them from the Google Cloud Console and the command line. For the mechanics common to every Cloud Run application — service identity, ingress and load balancing, scaling and concurrency, CI/CD, Cloud Armor, IAP, Binary Authorization, VPC Service Controls, backups, and the deployment lifecycle — refer to the App_CloudRun foundation guide rather than repeating them here.


1. Overview

Vikunja runs as a single Go container on Cloud Run v2. The deployment wires together a focused set of Google Cloud services:

CapabilityGoogle Cloud serviceNotes
ComputeCloud Run v2Go service, 1 vCPU / 512 MiB by default, single instance
DatabaseCloud SQL for PostgreSQL 15Required — Vikunja does not support MySQL in this module
Container buildCloud Build + Artifact RegistryWraps the scratch upstream image with a grafted busybox
SecretsSecret ManagerAuto-generated VIKUNJA_SERVICE_JWTSECRET; database password
IngressCloud Run URL / Cloud Load BalancingDefault run.app URL; optional external HTTPS load balancer + custom domain

Sensible defaults worth knowing up front:

  • PostgreSQL 15 is mandatory. The database engine is fixed by the shared application layer; selecting any other engine breaks startup.
  • The app connects over the Cloud SQL private IP, not the socket. Vikunja builds a postgres:// URL internally, and the Auth Proxy socket path's colons break URL parsing. The entrypoint connects over the private IP with sslmode=require.
  • The image is scratch-based and gets a busybox graft. The upstream vikunja/vikunja image has no shell, so the custom build copies in a static busybox to run the entrypoint. container_image_source defaults to "custom".
  • VIKUNJA_SERVICE_JWTSECRET is generated automatically and stored in Secret Manager. Rotating it after first boot invalidates all active user sessions.
  • cpu_always_allocated = true by default. Vikunja runs an in-process reminder/cron scheduler that must run without an inbound request, so CPU is not throttled between requests. This keeps a single instance warm.
  • Single instance by default (min_instance_count = 1, max_instance_count = 1). Vikunja has no built-in coordination for multiple concurrent instances.
  • Public ingress by default. ingress_settings = "all" so the UI and API are reachable. Enable IAP to require Google sign-in.
  • NFS is disabled by default. Vikunja stores data in PostgreSQL; enable NFS only if you need durable file attachments at /app/vikunja/files.
  • VIKUNJA_SERVICE_PUBLICURL is set at runtime from the actual CLOUDRUN_SERVICE_URL, so links and the frontend always use the real service URL.

2. Google Cloud Services & How to Explore Them

All commands assume PROJECT and REGION are set. Service and resource names are reported in the deployment Outputs.

A. Cloud Run — the Vikunja service

Vikunja runs as a Cloud Run v2 service. Each deployment creates an immutable revision; traffic can be split across revisions for safe rollouts.

  • Console: Cloud Run → select the service for revisions, traffic, logs, and metrics.
  • CLI:
    gcloud run services list --project "$PROJECT" --region "$REGION"
    gcloud run services describe <service-name> --project "$PROJECT" --region "$REGION"
    gcloud run revisions list --service <service-name> --project "$PROJECT" --region "$REGION"

See App_CloudRun for scaling, concurrency, execution environment, and traffic splitting.

B. Cloud SQL for PostgreSQL 15

Vikunja stores all application data (tasks, projects, boards, users, teams) in a managed Cloud SQL for PostgreSQL 15 instance. The db-init Job connects through the Cloud SQL Auth Proxy over a Unix socket; the running application connects over the Cloud SQL private IP with sslmode=require (its URL builder cannot use the socket path). No public IP is exposed.

  • Console: SQL → select the instance for connections, backups, flags, metrics.
  • CLI:
    gcloud sql instances list --project "$PROJECT"
    gcloud sql instances describe <instance-name> --project "$PROJECT"
    gcloud sql connect <instance-name> --user=<db-user> --database=<db-name> --project "$PROJECT"

The instance name, database, user, and password secret are in the Outputs. See App_CloudRun for the connection model, backups, and password rotation.

C. Cloud Build & Artifact Registry

Because the upstream Vikunja image is scratch-based, the module builds a wrapper image via Cloud Build (grafting in a static busybox and the entrypoint) and pushes it to Artifact Registry.

  • Console: Cloud Build → History; Artifact Registry → Repositories.
  • CLI:
    gcloud builds list --project "$PROJECT" --limit 5
    gcloud artifacts docker images list <region>-docker.pkg.dev/$PROJECT/<repo> --project "$PROJECT"

D. Secret Manager

One cryptographic secret is generated automatically and stored in Secret Manager: VIKUNJA_SERVICE_JWTSECRET (used to sign user session JWTs). The database password is managed separately by the foundation.

  • Console: Security → Secret Manager.
  • CLI:
    gcloud secrets list --project "$PROJECT"
    gcloud secrets versions access latest --secret=<secret-name> --project "$PROJECT"

See App_CloudRun for injection and rotation details.

E. Cloud Storage & file attachments (optional)

Vikunja stores file attachments on the container filesystem at /app/vikunja/files, which is ephemeral on Cloud Run. Enable NFS and mount it over that path for durable attachments; the module declares no dedicated GCS bucket by default.

  • Console: Filestore / Compute Engine (NFS VM) when enable_nfs = true.
  • CLI:
    gcloud storage buckets list --project "$PROJECT"

See App_CloudRun for NFS and GCS Fuse options.

F. Networking & ingress

The service is reachable at its run.app URL by default. An external HTTPS load balancer with a custom domain, Cloud CDN, and Cloud Armor can be layered on; ingress settings and VPC egress control connectivity (the app reaches Cloud SQL over private-range VPC egress).

  • Console: Cloud Run (service URL); Network services → Load balancing.
  • CLI:
    gcloud run services describe <service-name> --region "$REGION" --format='value(status.url)'
    gcloud compute addresses list --project "$PROJECT"

See App_CloudRun.

G. Cloud Logging & Monitoring

Container logs flow to Cloud Logging; Cloud Run and Cloud SQL metrics flow to Cloud Monitoring, with optional uptime checks and alert policies.

  • Console: Logging → Logs Explorer; Monitoring → Dashboards / Alerting.
  • CLI:
    gcloud run services logs read <service-name> --project "$PROJECT" --region "$REGION" --limit 50

3. Vikunja Application Behaviour

  • First-deploy database setup. An initialization Job runs create-db-and-user.sh using postgres:15-alpine. It connects through the Cloud SQL Auth Proxy and idempotently creates the application database and role and grants privileges. The job is safe to re-run.
  • Schema migrations on start. Vikunja applies its own schema migrations automatically on the first application startup — the db-init job only provisions an empty database, so allow extra time on the first revision to become healthy.
  • VIKUNJA_SERVICE_JWTSECRET is immutable after first boot. It is generated once and written to Secret Manager. Changing it invalidates all active user sessions. Only rotate during a planned maintenance window.
  • First registered account becomes the owner. Vikunja ships no pre-seeded admin. Open $SERVICE_URL and register — the first account owns the instance. Then disable open registration:
    # add VIKUNJA_SERVICE_ENABLEREGISTRATION="false" to environment_variables and Update
  • Health path. Startup and liveness probes target /health — a public, unauthenticated endpoint that returns 200 once the server binds its port.
  • Inspect job execution:
    gcloud run jobs list --project "$PROJECT" --region "$REGION"
    gcloud run jobs executions list --job <job-name> --project "$PROJECT" --region "$REGION"

4. Configuration Variables

Variables are grouped exactly as they appear on the deployment platform. Only settings specific to or notable for Vikunja are listed; every other input is inherited from App_CloudRun with its standard behaviour.

Group 1 — Project & Identity

VariableDefaultDescription
project_id(required)Target Google Cloud project.
regionus-central1Region for the service and regional resources.

Group 2 — Deployment Environment

VariableDefaultDescription
tenant_deployment_iddemoShort suffix that makes resource names unique per environment.
support_users[]Emails granted project access and monitoring alerts.
resource_labels{}Labels applied to all resources.

Group 3 — Application Identity

VariableDefaultDescription
application_namevikunjaBase name for resources. Do not change after first deploy.
application_display_nameVikunjaHuman-readable name shown in the Console.
application_descriptionVikunja task manager on Cloud RunService description.
application_versionlatestVikunja image version tag; latest builds a pinned recent release (2.3.0).
application_database_namevikunjaPostgreSQL database name. Immutable after first deploy.
application_database_uservikunjaApplication database user. Password auto-generated in Secret Manager.

Group 4 — Runtime & Scaling

VariableDefaultDescription
deploy_applicationtrueSet false to provision infrastructure only.
container_image_sourcecustomBuilds the busybox-grafted wrapper via Cloud Build; prebuilt deploys the official image.
container_imagevikunja/vikunjaUpstream image the custom build wraps.
cpu_limit1000mCPU per instance.
memory_limit512MiMemory per instance; gen2 enforces a 512Mi floor.
container_port3456Port Vikunja's Go server listens on.
min_instance_count1Kept at 1 so the reminder scheduler stays warm.
max_instance_count1Single instance — Vikunja has no multi-instance coordination.
cpu_always_allocatedtrueKeeps CPU allocated so the in-process reminder scheduler runs between requests.
execution_environmentgen2Gen2 required for the 512Mi floor and NFS/GCS mounts.
enable_cloudsql_volumetrueAuth Proxy socket for the db-init job; the app itself uses the private IP.
enable_image_mirroringtrueMirror the wrapper image into Artifact Registry.

Group 5 — Access & Ingress Control

VariableDefaultDescription
ingress_settingsallPublic ingress for the UI/API.
vpc_egress_settingPRIVATE_RANGES_ONLYRoute only RFC 1918 traffic via VPC (reaches Cloud SQL private IP).
enable_iapfalseRequire Google sign-in in front of Vikunja.
iap_authorized_users / iap_authorized_groups[]Who may access through IAP.

Group 6 — Environment Variables & Secrets

VariableDefaultDescription
environment_variables{}Extra VIKUNJA_* settings (e.g. VIKUNJA_SERVICE_ENABLEREGISTRATION). Do not set VIKUNJA_DATABASE_* or VIKUNJA_SERVICE_JWTSECRET here.
secret_environment_variables{}Map of env var → Secret Manager secret name.
secret_propagation_delay30Seconds to wait after secret creation before proceeding.
secret_rotation_period2592000sSecret Manager rotation notification frequency.

Group 7 — Backup & Restore

VariableDefaultDescription
backup_schedule0 2 * * *Automated Cloud SQL backup cron (UTC).
backup_retention_days7Retention; raise for production/compliance.
enable_backup_import / backup_source / backup_uri / backup_formatrestore optionsRestore from a backup on deploy.

Group 8 — CI/CD & Binary Authorization

Standard App_CloudRun Cloud Build / Cloud Deploy integration — see App_CloudRun. Key inputs: enable_cicd_trigger, github_repository_url, github_token, enable_cloud_deploy, enable_binary_authorization.

Group 9 — Custom SQL Scripts

enable_custom_sql_scripts, custom_sql_scripts_bucket, custom_sql_scripts_path, custom_sql_scripts_use_root — run SQL from a GCS bucket after provisioning.

Group 10 — Load Balancer, CDN & Image Retention

VariableDefaultDescription
enable_cloud_armorfalseProvision Global HTTPS LB + Cloud Armor WAF.
admin_ip_ranges[]CIDR ranges exempted from WAF rules.
application_domains[]Custom domain names for the HTTPS LB.
enable_cdnfalseEnable Cloud CDN on the HTTPS LB backend.
max_images_to_retain / delete_untagged_images / image_retention_days(set)Artifact Registry cleanup policy.

Group 11 — Storage & Filesystem

VariableDefaultDescription
create_cloud_storagetrueCreate GCS buckets defined in storage_buckets.
storage_buckets[]Vikunja declares no bucket by default.
enable_nfsfalseEnable for durable file attachments at /app/vikunja/files.
nfs_mount_path/mnt/nfsMount path inside the container.
gcs_volumes[]GCS Fuse volume mounts (requires gen2).
manage_storage_kms_iam / enable_artifact_registry_cmekfalseCMEK options.

Group 12 — Database Password

VariableDefaultDescription
database_password_length32Generated password length (16–64).
enable_auto_password_rotation / rotation_propagation_delay_secoffDB password rotation.

Group 13 — Jobs & Scheduled Tasks

VariableDefaultDescription
initialization_jobs[]Leave empty to use the built-in db-init job.
cron_jobs[]Optional Cloud Scheduler + Cloud Run Jobs.

Group 14 — Observability & Health

VariableDefaultDescription
startup_probeHTTP /health 30s delayStartup probe; wide retry window for first-boot migrations.
liveness_probeHTTP /health 30s delayLiveness probe.
uptime_check_configdisabled, path /healthCloud Monitoring uptime check.
alert_policies[]Metric alert policies.

Group 22 — VPC Service Controls & Audit Logging

VariableDefaultDescription
enable_vpc_scfalseEnforce a VPC-SC perimeter (requires organization_id).
vpc_cidr_ranges / vpc_sc_dry_run(set)Access level CIDRs / dry-run mode.
enable_audit_loggingfalseDetailed Cloud Audit Logs.

5. Outputs

Returned on a successful deployment — the quickest way to locate and explore the running resources.

OutputDescription
service_nameCloud Run service name.
service_urlDefault run.app URL of the service.
service_locationRegion the service runs in.
stage_servicesStage-specific service URLs (Cloud Deploy).
load_balancer_ip / load_balancer_urlExternal HTTPS load balancer IP / URL (when enabled).
database_instance_nameCloud SQL instance name.
database_name / database_userApplication database name / user.
database_password_secretSecret Manager secret holding the DB password.
database_host / database_portDB endpoint / port.
storage_bucketsCreated Cloud Storage buckets.
network_name / network_exists / regionsVPC network, presence, regions.
container_image / container_registryDeployed image and Artifact Registry repo.
monitoring_enabled / monitoring_notification_channels / uptime_check_namesMonitoring status, channels, uptime checks.
initialization_jobsNames of the setup jobs.
deployment_id / tenant_id / resource_prefixNaming identifiers.
project_id / project_numberProject identifiers.
cicd_enabled / github_repository_url / github_repository_owner / github_repository_name / cicd_configurationCI/CD status and details.
artifact_registry_repository / cloudbuild_trigger_name / cloudbuild_trigger_idRegistry and build trigger.
vpc_sc_enabled / vpc_sc_perimeter_name / vpc_sc_dry_run_modeVPC-SC status.
audit_logging_enabled / artifact_registry_cmek_enabledAudit logging and CMEK status.

6. Configuration Pitfalls & Sensible Defaults

Risk: Critical (data loss / outage / security) — High (service degraded) — Medium (cost or partial degradation) — Low (minor).

Inherited plan-time validation. This module passes its configuration through the App_CloudRun foundation engine, which validates values and combinations at plan time — a read replica without its primary, IAP with no authorized identities, a gen1 runtime with NFS/GCS mounts, an out-of-range container_port/backup_retention_days. Invalid configuration fails the plan with a clear, named error before any resource is created, so most mistakes below are caught up front rather than at apply or runtime.

SettingSensible valueRiskConsequence if wrong
VIKUNJA_SERVICE_JWTSECRET (auto-generated)Never rotate after first bootCriticalRotating it invalidates all active user sessions, forcing immediate re-login for everyone.
application_database_name / application_database_userSet onceCriticalImmutable after first deploy; renaming recreates the DB/user and destroys all data.
enable_backup_importfalse unless restoringCriticalEnabling without a valid backup_uri fails the import job.
enable_nfs (for attachments)true if attachments matterHighWithout NFS, file attachments live on ephemeral disk and are lost on every revision/restart.
memory_limit512Mi (gen2 floor)HighValues below 512Mi are rejected at plan time on gen2.
cpu_always_allocatedtrueMediumFlipping to false pauses the in-process reminder scheduler while the instance is idle — reminders won't fire until the next request.
container_image_sourcecustomHighprebuilt deploys the raw scratch image with no shell/entrypoint mapping — the container cannot map DB_* and fails to connect.
ingress_settingsallMediuminternal makes the UI/API unreachable from outside the VPC.
enable_iapenable for private instancesMediumWithout IAP the UI is public; anyone with the URL can reach the login/registration page.
VIKUNJA_SERVICE_ENABLEREGISTRATION (env var)"false" after first adminHighLeaving registration open allows anyone with the URL to create an account.
backup_retention_days7 (raise for prod)MediumToo short for compliance retention.

For the foundation behaviour referenced throughout — service identity, scaling and concurrency, ingress and load balancing, CI/CD, Cloud Armor, IAP, Binary Authorization, VPC-SC, backups, and image mirroring — see App_CloudRun. Vikunja-specific application configuration shared with the GKE variant is described in Vikunja_Common.