SolidTime

Stack

Time Management

The modern Open-Source Time Tracker

Configuration

Type

Compose

Platform

linux

Source

Repo

Template by xneo1·Source

Services

solidtime

Configuration

Image

solidtime/solidtime:latest

Ports

${PORT:-8000}:8000

Volumes

/var/www/html/storage : /portainer/Files/AppData/Config/solidtime/storage/var/www/html/bootstrap/cache : /portainer/Files/AppData/Config/solidtime/bootstrap-cache

Env vars

CONTAINER_MODE=httpAUTO_DB_MIGRATE=trueAPP_URL=${APP_URL}APP_KEY=${APP_KEY}APP_ENV=productionAPP_DEBUG=falseAPP_ENABLE_REGISTRATION=${APP_ENABLE_REGISTRATION:-false}SUPER_ADMINS=${SUPER_ADMINS}DB_CONNECTION=pgsqlDB_HOST=solidtime-postgresDB_PORT=5432DB_DATABASE=${DB_DATABASE:-solidtime}DB_USERNAME=${DB_USERNAME:-solidtime}DB_PASSWORD=${DB_PASSWORD}QUEUE_CONNECTION=databaseCACHE_STORE=redisSESSION_DRIVER=redisREDIS_HOST=solidtime-redisREDIS_PORT=6379MAIL_MAILER=${MAIL_MAILER:-smtp}MAIL_HOST=${MAIL_HOST}MAIL_PORT=${MAIL_PORT:-587}MAIL_USERNAME=${MAIL_USERNAME}MAIL_PASSWORD=${MAIL_PASSWORD}MAIL_ENCRYPTION=${MAIL_ENCRYPTION:-tls}MAIL_FROM_ADDRESS=${MAIL_FROM_ADDRESS:-noreply@localhost}MAIL_FROM_NAME=${MAIL_FROM_NAME:-solidtime}PASSPORT_PRIVATE_KEY=${PASSPORT_PRIVATE_KEY}PASSPORT_PUBLIC_KEY=${PASSPORT_PUBLIC_KEY}S3_ACCESS_KEY_ID=${S3_ACCESS_KEY_ID}S3_SECRET_ACCESS_KEY=${S3_SECRET_ACCESS_KEY}S3_BUCKET=${S3_BUCKET}S3_ENDPOINT=${S3_ENDPOINT}S3_REGION=${S3_REGION:-us-east-1}S3_USE_PATH_STYLE_ENDPOINT=${S3_USE_PATH_STYLE_ENDPOINT:-false}

Restart

unless-stopped

Image details

Pulls: 875k

User: solidtime

Created: Apr 03, 2024

Updated: 8 days ago

Status: active

solidtime-scheduler

Configuration

Image

solidtime/solidtime:latest

Env vars

CONTAINER_MODE=schedulerAPP_URL=${APP_URL}APP_KEY=${APP_KEY}APP_ENV=productionDB_CONNECTION=pgsqlDB_HOST=solidtime-postgresDB_PORT=5432DB_DATABASE=${DB_DATABASE:-solidtime}DB_USERNAME=${DB_USERNAME:-solidtime}DB_PASSWORD=${DB_PASSWORD}QUEUE_CONNECTION=databaseCACHE_STORE=redisSESSION_DRIVER=redisREDIS_HOST=solidtime-redisREDIS_PORT=6379MAIL_MAILER=${MAIL_MAILER:-smtp}MAIL_HOST=${MAIL_HOST}MAIL_PORT=${MAIL_PORT:-587}MAIL_USERNAME=${MAIL_USERNAME}MAIL_PASSWORD=${MAIL_PASSWORD}MAIL_ENCRYPTION=${MAIL_ENCRYPTION:-tls}MAIL_FROM_ADDRESS=${MAIL_FROM_ADDRESS:-noreply@localhost}MAIL_FROM_NAME=${MAIL_FROM_NAME:-solidtime}PASSPORT_PRIVATE_KEY=${PASSPORT_PRIVATE_KEY}PASSPORT_PUBLIC_KEY=${PASSPORT_PUBLIC_KEY}

Restart

unless-stopped

Image details

Pulls: 875k

User: solidtime

Created: Apr 03, 2024

Updated: 8 days ago

Status: active

solidtime-worker

Configuration

Image

solidtime/solidtime:latest

Env vars

CONTAINER_MODE=workerAPP_URL=${APP_URL}APP_KEY=${APP_KEY}APP_ENV=productionDB_CONNECTION=pgsqlDB_HOST=solidtime-postgresDB_PORT=5432DB_DATABASE=${DB_DATABASE:-solidtime}DB_USERNAME=${DB_USERNAME:-solidtime}DB_PASSWORD=${DB_PASSWORD}QUEUE_CONNECTION=databaseCACHE_STORE=redisSESSION_DRIVER=redisREDIS_HOST=solidtime-redisREDIS_PORT=6379MAIL_MAILER=${MAIL_MAILER:-smtp}MAIL_HOST=${MAIL_HOST}MAIL_PORT=${MAIL_PORT:-587}MAIL_USERNAME=${MAIL_USERNAME}MAIL_PASSWORD=${MAIL_PASSWORD}MAIL_ENCRYPTION=${MAIL_ENCRYPTION:-tls}MAIL_FROM_ADDRESS=${MAIL_FROM_ADDRESS:-noreply@localhost}MAIL_FROM_NAME=${MAIL_FROM_NAME:-solidtime}PASSPORT_PRIVATE_KEY=${PASSPORT_PRIVATE_KEY}PASSPORT_PUBLIC_KEY=${PASSPORT_PUBLIC_KEY}

Restart

unless-stopped

Image details

Pulls: 875k

User: solidtime

Created: Apr 03, 2024

Updated: 8 days ago

Status: active

solidtime-postgres

Configuration

Image

postgres:15-alpine

Volumes

/var/lib/postgresql/data : /portainer/Files/AppData/Config/solidtime/postgres

Env vars

POSTGRES_DB=${DB_DATABASE:-solidtime}POSTGRES_USER=${DB_USERNAME:-solidtime}POSTGRES_PASSWORD=${DB_PASSWORD}

Restart

unless-stopped

Image details

Pulls: 11.2B

User: stackbrew

Created: Jun 05, 2014

Updated: 1 hour ago

Status: active

solidtime-redis

Configuration

Image

redis:7-alpine

Volumes

/data : /portainer/Files/AppData/Config/solidtime/redis

Restart

unless-stopped

Image details

Pulls: 11.1B

User: stackbrew

Created: Jun 05, 2014

Updated: 9 days ago

Status: active

Standalone Install

Select an install method, to see config/commands for deploying SolidTime

Installation method

Docker Run

Docker Compose

Install on Portainer

Import all app templates into your Portainer instance, for easy 1-click deploys

Ensure both Docker and Portainer are installed, and up-to-date
Log into your Portainer web UI
Under Settings → App Templates, paste the below URL
Head to Home → App Templates, and the list of apps will show up
Select SolidTime, fill in any config options, and hit Deploy

Template Import URL

https://raw.githubusercontent.com/Lissy93/portainer-templates/main/templates.json

Show Me

Original stackfile

The compose file this template deploys, straight from its repo:

version: '3.8'

services:
  solidtime:
    image: solidtime/solidtime:latest
    container_name: solidtime
    restart: unless-stopped
    ports:
      - ${PORT:-8000}:8000
    environment:
      - CONTAINER_MODE=http
      - AUTO_DB_MIGRATE=true
      - APP_URL=${APP_URL}
      - APP_KEY=${APP_KEY}
      - APP_ENV=production
      - APP_DEBUG=false
      - APP_ENABLE_REGISTRATION=${APP_ENABLE_REGISTRATION:-false}
      - SUPER_ADMINS=${SUPER_ADMINS}
      - DB_CONNECTION=pgsql
      - DB_HOST=solidtime-postgres
      - DB_PORT=5432
      - DB_DATABASE=${DB_DATABASE:-solidtime}
      - DB_USERNAME=${DB_USERNAME:-solidtime}
      - DB_PASSWORD=${DB_PASSWORD}
      - QUEUE_CONNECTION=database
      - CACHE_STORE=redis
      - SESSION_DRIVER=redis
      - REDIS_HOST=solidtime-redis
      - REDIS_PORT=6379
      - MAIL_MAILER=${MAIL_MAILER:-smtp}
      - MAIL_HOST=${MAIL_HOST}
      - MAIL_PORT=${MAIL_PORT:-587}
      - MAIL_USERNAME=${MAIL_USERNAME}
      - MAIL_PASSWORD=${MAIL_PASSWORD}
      - MAIL_ENCRYPTION=${MAIL_ENCRYPTION:-tls}
      - MAIL_FROM_ADDRESS=${MAIL_FROM_ADDRESS:-noreply@localhost}
      - MAIL_FROM_NAME=${MAIL_FROM_NAME:-solidtime}
      - PASSPORT_PRIVATE_KEY=${PASSPORT_PRIVATE_KEY}
      - PASSPORT_PUBLIC_KEY=${PASSPORT_PUBLIC_KEY}
      - S3_ACCESS_KEY_ID=${S3_ACCESS_KEY_ID}
      - S3_SECRET_ACCESS_KEY=${S3_SECRET_ACCESS_KEY}
      - S3_BUCKET=${S3_BUCKET}
      - S3_ENDPOINT=${S3_ENDPOINT}
      - S3_REGION=${S3_REGION:-us-east-1}
      - S3_USE_PATH_STYLE_ENDPOINT=${S3_USE_PATH_STYLE_ENDPOINT:-false}
    volumes:
      - /portainer/Files/AppData/Config/solidtime/storage:/var/www/html/storage
      - /portainer/Files/AppData/Config/solidtime/bootstrap-cache:/var/www/html/bootstrap/cache
    depends_on:
      solidtime-postgres:
        condition: service_healthy
      solidtime-redis:
        condition: service_started
    networks:
      - solidtime-network

  solidtime-scheduler:
    image: solidtime/solidtime:latest
    container_name: solidtime-scheduler
    restart: unless-stopped
    environment:
      - CONTAINER_MODE=scheduler
      - APP_URL=${APP_URL}
      - APP_KEY=${APP_KEY}
      - APP_ENV=production
      - DB_CONNECTION=pgsql
      - DB_HOST=solidtime-postgres
      - DB_PORT=5432
      - DB_DATABASE=${DB_DATABASE:-solidtime}
      - DB_USERNAME=${DB_USERNAME:-solidtime}
      - DB_PASSWORD=${DB_PASSWORD}
      - QUEUE_CONNECTION=database
      - CACHE_STORE=redis
      - SESSION_DRIVER=redis
      - REDIS_HOST=solidtime-redis
      - REDIS_PORT=6379
      - MAIL_MAILER=${MAIL_MAILER:-smtp}
      - MAIL_HOST=${MAIL_HOST}
      - MAIL_PORT=${MAIL_PORT:-587}
      - MAIL_USERNAME=${MAIL_USERNAME}
      - MAIL_PASSWORD=${MAIL_PASSWORD}
      - MAIL_ENCRYPTION=${MAIL_ENCRYPTION:-tls}
      - MAIL_FROM_ADDRESS=${MAIL_FROM_ADDRESS:-noreply@localhost}
      - MAIL_FROM_NAME=${MAIL_FROM_NAME:-solidtime}
      - PASSPORT_PRIVATE_KEY=${PASSPORT_PRIVATE_KEY}
      - PASSPORT_PUBLIC_KEY=${PASSPORT_PUBLIC_KEY}
    depends_on:
      solidtime-postgres:
        condition: service_healthy
      solidtime-redis:
        condition: service_started
    networks:
      - solidtime-network

  solidtime-worker:
    image: solidtime/solidtime:latest
    container_name: solidtime-worker
    restart: unless-stopped
    environment:
      - CONTAINER_MODE=worker
      - APP_URL=${APP_URL}
      - APP_KEY=${APP_KEY}
      - APP_ENV=production
      - DB_CONNECTION=pgsql
      - DB_HOST=solidtime-postgres
      - DB_PORT=5432
      - DB_DATABASE=${DB_DATABASE:-solidtime}
      - DB_USERNAME=${DB_USERNAME:-solidtime}
      - DB_PASSWORD=${DB_PASSWORD}
      - QUEUE_CONNECTION=database
      - CACHE_STORE=redis
      - SESSION_DRIVER=redis
      - REDIS_HOST=solidtime-redis
      - REDIS_PORT=6379
      - MAIL_MAILER=${MAIL_MAILER:-smtp}
      - MAIL_HOST=${MAIL_HOST}
      - MAIL_PORT=${MAIL_PORT:-587}
      - MAIL_USERNAME=${MAIL_USERNAME}
      - MAIL_PASSWORD=${MAIL_PASSWORD}
      - MAIL_ENCRYPTION=${MAIL_ENCRYPTION:-tls}
      - MAIL_FROM_ADDRESS=${MAIL_FROM_ADDRESS:-noreply@localhost}
      - MAIL_FROM_NAME=${MAIL_FROM_NAME:-solidtime}
      - PASSPORT_PRIVATE_KEY=${PASSPORT_PRIVATE_KEY}
      - PASSPORT_PUBLIC_KEY=${PASSPORT_PUBLIC_KEY}
    depends_on:
      solidtime-postgres:
        condition: service_healthy
      solidtime-redis:
        condition: service_started
    networks:
      - solidtime-network

  solidtime-postgres:
    image: postgres:15-alpine
    container_name: solidtime-postgres
    restart: unless-stopped
    environment:
      - POSTGRES_DB=${DB_DATABASE:-solidtime}
      - POSTGRES_USER=${DB_USERNAME:-solidtime}
      - POSTGRES_PASSWORD=${DB_PASSWORD}
    volumes:
      - /portainer/Files/AppData/Config/solidtime/postgres:/var/lib/postgresql/data
    networks:
      - solidtime-network
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U ${DB_USERNAME:-solidtime} -d ${DB_DATABASE:-solidtime}"]
      interval: 5s
      timeout: 5s
      retries: 5

  solidtime-redis:
    image: redis:7-alpine
    container_name: solidtime-redis
    restart: unless-stopped
    volumes:
      - /portainer/Files/AppData/Config/solidtime/redis:/data
    networks:
      - solidtime-network

networks:
  solidtime-network:
    driver: bridge

Or deploy it directly from the source:

git clone https://github.com/xneo1/portainer_templates
cd portainer_templates
docker compose -f Template/Stack/solidtime.yml up -d

More install options in our documentation.

Container Documentation

solidtime Documentation

solidtime is a modern open source timetracker for Freelancers and Agencies

solidtime-scheduler Documentation

solidtime is a modern open source timetracker for Freelancers and Agencies

solidtime-worker Documentation

solidtime is a modern open source timetracker for Freelancers and Agencies

solidtime-postgres Documentation

The PostgreSQL object-relational database system provides reliability and data integrity.

solidtime-redis Documentation

Redis is the world’s fastest data platform for caching, vector search, and NoSQL databases.

Check the logs first

Nine times out of ten the logs tell you exactly what went wrong.

In Portainer, go to Containers, click the container, then Logs. Or run docker logs <container>
Exit codes help too: 137 means killed, usually out of memory. 126 or 127 means the command inside the image is broken.

Permission denied on volumes

If the logs show "permission denied", the app can't write to its data folder on the host.

Fix the ownership: sudo chown -R 1000:1000 /portainer/Files/AppData/Config/solidtime/storage (and the same for the other mapped folders)

Image won't pull

Test the pull directly on the host: docker pull solidtime/solidtime:latest

"manifest unknown" means the tag no longer exists. This template uses latest, so try pinning a specific version instead.
"toomanyrequests" is the Docker Hub rate limit. Log in with docker login to raise it.
"no space left on device" means a full disk. Reclaim space with docker system prune

"exec format error"

This means the image was built for a different CPU architecture than your server.

Check yours with uname -m: x86_64 is amd64, aarch64 is arm64. Raspberry Pi and other ARM boards are the usual culprits.

Container keeps restarting

The unless-stopped restart policy relaunches the app after every crash, so the real error can scroll past.

Check the logs right after a restart, the last few lines before it died are the useful ones.
Get the exit code with docker inspect <container> --format '{{.State.ExitCode}}'
Still stuck? Redeploy once with the restart policy set to no so the failure stays visible.

Stack won't deploy

Compose stacks fail fast on small mistakes, and Portainer shows the reason just above the editor.

YAML only accepts spaces for indentation, a single tab breaks the whole file.

Raise an issue

Found something which isn't working as it should? Here's how to report it.

Bug within the app: Open an issue within solidtime's repo
Template not working: Open an issue on xneo1/portainer_templates
This website not working: Open an issue on lissy93/portainer-templates

A Compose stack

SolidTime is a Compose stack, a set of containers (5 of them) defined in one file and brought up together by Portainer, then started and stopped as a single app.

The services

This stack is built from 5 containers that run side by side. Here's each one, with the image it runs and anything it waits for first:

solidtime runs solidtime/solidtime:latest, starts after solidtime-postgres, solidtime-redis
solidtime-scheduler runs solidtime/solidtime:latest, starts after solidtime-postgres, solidtime-redis
solidtime-worker runs solidtime/solidtime:latest, starts after solidtime-postgres, solidtime-redis
solidtime-postgres runs postgres:15-alpine
solidtime-redis runs redis:7-alpine

Volumes

A volume is where SolidTime keeps its files so they survive an update or a restart. Without one, anything it saves would sit inside the container and vanish the moment it's recreated. This template mounts:

/var/www/html/storage from /portainer/Files/AppData/Config/solidtime/storage on the host
/var/www/html/bootstrap/cache from /portainer/Files/AppData/Config/solidtime/bootstrap-cache on the host
/var/lib/postgresql/data from /portainer/Files/AppData/Config/solidtime/postgres on the host
/data from /portainer/Files/AppData/Config/solidtime/redis on the host

Environment variables

Environment variables are the settings you hand over when you deploy, things like a password or a timezone. SolidTime takes 38 of them, all with defaults you can leave alone or tweak:

CONTAINER_MODE, defaults to worker
AUTO_DB_MIGRATE, defaults to true
APP_URL, pulled from your own environment
APP_KEY, pulled from your own environment
APP_ENV, defaults to production
APP_DEBUG, defaults to false
APP_ENABLE_REGISTRATION, defaults to false
SUPER_ADMINS, pulled from your own environment
DB_CONNECTION, defaults to pgsql
DB_HOST, defaults to solidtime-postgres
DB_PORT, defaults to 5432
DB_DATABASE, defaults to solidtime
DB_USERNAME, defaults to solidtime
DB_PASSWORD, pulled from your own environment
QUEUE_CONNECTION, defaults to database
CACHE_STORE, defaults to redis
SESSION_DRIVER, defaults to redis
REDIS_HOST, defaults to solidtime-redis
REDIS_PORT, defaults to 6379
MAIL_MAILER, defaults to smtp
MAIL_HOST, pulled from your own environment
MAIL_PORT, defaults to 587
MAIL_USERNAME, pulled from your own environment
MAIL_PASSWORD, pulled from your own environment
MAIL_ENCRYPTION, defaults to tls
MAIL_FROM_ADDRESS, defaults to noreply@localhost
MAIL_FROM_NAME, defaults to solidtime
PASSPORT_PRIVATE_KEY, pulled from your own environment
PASSPORT_PUBLIC_KEY, pulled from your own environment
S3_ACCESS_KEY_ID, pulled from your own environment
S3_SECRET_ACCESS_KEY, pulled from your own environment
S3_BUCKET, pulled from your own environment
S3_ENDPOINT, pulled from your own environment
S3_REGION, defaults to us-east-1
S3_USE_PATH_STYLE_ENDPOINT, defaults to false
POSTGRES_DB, defaults to solidtime
POSTGRES_USER, defaults to solidtime
POSTGRES_PASSWORD, pulled from your own environment

Restart policy

The restart policy here is unless-stopped, so Docker restarts SolidTime after a crash or reboot, but leaves it off when you stop it on purpose. You can change this on the deploy screen. The choices are no (never restart), on-failure (only after a crash), unless-stopped (restart unless you stop it), and always (bring it back no matter what).

Networking

Portainer puts these services on one shared private network, so they can find each other by name (like solidtime) while only the ports above are open to you.

Platform

The platform is linux, the kind of system the container is built to run on. Docker and Portainer handle this on a normal Linux server.

Portainer app templates

Zooming out, this whole page comes from a Portainer app template: a short recipe telling Portainer how to set SolidTime up. Add the template list to Portainer once, then deploying SolidTime is a click rather than a wall of config.

SolidTime

Configuration

Services

solidtime

Configuration

Image details

solidtime-scheduler

Configuration

Image details

solidtime-worker

Configuration

Image details

solidtime-postgres

Configuration

Image details

solidtime-redis

Configuration

Image details

Standalone Install

Install on Portainer

Template Import URL

Container Documentation

solidtime Documentation

solidtime-scheduler Documentation

solidtime-worker Documentation

solidtime-postgres Documentation

solidtime-redis Documentation

Troubleshooting

Check the logs first

Permission denied on volumes

Image won't pull

"exec format error"

Container keeps restarting

Stack won't deploy

Raise an issue

Config glossary

A Compose stack

The services

Volumes

Environment variables

Restart policy

Networking

Platform

Portainer app templates