# OpenProject Management

> Enterprise project management with Gantt charts, boards, and time tracking.

- Category: Productivity & Collaboration
- Difficulty: intermediate
- Components: openproject, postgresql, memcached
- Tags: project-management, gantt, openproject, enterprise
- Source: https://docker.recipes/productivity/openproject-pm

## Overview

OpenProject is an open-source, web-based project management software that has been in active development since 2011 as a fork of ChiliProject/Redmine. It combines traditional project management methodologies with agile practices, offering comprehensive features including Gantt charts, Kanban boards, time tracking, wikis, forums, and budget management. OpenProject serves as a complete alternative to proprietary solutions like Microsoft Project or Jira, with strong emphasis on data privacy and self-hosting capabilities.

This deployment configuration creates a three-tier architecture with OpenProject version 14 as the main application server, PostgreSQL 15 as the relational database backend, and Memcached for high-performance caching. The setup uses Alpine Linux variants where possible for reduced container size and improved security. The OpenProject container connects to the PostgreSQL database for persistent data storage while leveraging Memcached to accelerate page loads and reduce database queries for frequently accessed content.

This stack is ideal for organizations seeking enterprise-grade project management capabilities with full data control and customization options. The combination provides excellent performance for teams ranging from 10 to 1000+ users, with PostgreSQL handling complex project hierarchies and relationships while Memcached ensures responsive user interfaces even under heavy load. The configuration supports LDAP integration, custom workflows, and extensive plugin ecosystem that makes it suitable for both technical and non-technical project management scenarios.

## Features

- Interactive Gantt charts with dependency management and critical path analysis
- Agile boards with customizable workflows, swimlanes, and backlog management
- Time tracking with detailed reporting, budgets, and cost analysis per project
- Multi-project hierarchies with cross-project dependencies and portfolio views
- Built-in wiki system with version control and document management capabilities
- Advanced permission system with role-based access control and project-level security
- PostgreSQL-backed full-text search across projects, work packages, and documents
- Memcached acceleration for dashboard widgets, project listings, and user sessions

## Use cases

- Software development teams managing sprints, releases, and bug tracking workflows
- Construction and engineering projects requiring detailed Gantt scheduling with resource allocation
- Consulting firms tracking billable hours across multiple client projects simultaneously
- Non-profit organizations coordinating grant-funded projects with budget oversight
- Educational institutions managing research projects and academic collaboration
- Marketing agencies planning campaigns with creative workflows and client approval processes
- IT departments handling internal projects, change requests, and infrastructure deployments

## Prerequisites

- Minimum 2GB RAM recommended for PostgreSQL and OpenProject containers under normal load
- Docker host with at least 4GB available disk space for application data and database storage
- Port 8080 available on the host system for web interface access
- Basic understanding of project management concepts like work packages, phases, and Gantt charts
- Environment variables configured for OPENPROJECT_HOST, SECRET_KEY, and DB_PASSWORD
- Email server configuration knowledge if planning to enable notification features

## docker-compose.yml

```yaml
services:
  openproject:
    image: openproject/openproject:14
    container_name: openproject
    environment:
      - OPENPROJECT_HOST__NAME=${OPENPROJECT_HOST}
      - OPENPROJECT_SECRET_KEY_BASE=${SECRET_KEY}
      - OPENPROJECT_HTTPS=false
      - DATABASE_URL=postgres://openproject:${DB_PASSWORD}@db/openproject
      - RAILS_CACHE_STORE=memcache
      - OPENPROJECT_CACHE__MEMCACHE__SERVER=memcached:11211
      - OPENPROJECT_RAILS__RELATIVE__URL__ROOT=
    volumes:
      - openproject-data:/var/openproject/assets
    ports:
      - "8080:80"
    depends_on:
      - db
      - memcached
    networks:
      - openproject-network
    restart: unless-stopped

  db:
    image: postgres:15-alpine
    container_name: openproject-db
    environment:
      - POSTGRES_USER=openproject
      - POSTGRES_PASSWORD=${DB_PASSWORD}
      - POSTGRES_DB=openproject
    volumes:
      - postgres-data:/var/lib/postgresql/data
    networks:
      - openproject-network
    restart: unless-stopped

  memcached:
    image: memcached:alpine
    container_name: openproject-memcached
    networks:
      - openproject-network
    restart: unless-stopped

volumes:
  openproject-data:
  postgres-data:

networks:
  openproject-network:
    driver: bridge
```

## .env

```bash
# OpenProject
OPENPROJECT_HOST=localhost:8080

# Generate with: openssl rand -hex 32
SECRET_KEY=your_secret_key_here
DB_PASSWORD=secure_openproject_password
```

## Usage notes

- Web UI at http://localhost:8080
- Default admin: admin / admin
- Change password on first login
- Gantt charts, boards, wiki, time tracking
- LDAP and SSO support

## Troubleshooting

- Database connection errors on startup: Ensure PostgreSQL container is fully initialized before OpenProject starts, check DB_PASSWORD environment variable matches between services
- Slow page loading despite Memcached: Verify memcached container is running and OpenProject can connect to port 11211, check OPENPROJECT_CACHE__MEMCACHE__SERVER configuration
- OpenProject container fails with asset compilation errors: Clear openproject-data volume and restart container to trigger fresh asset compilation
- Cannot access web interface: Confirm port 8080 mapping is correct and OPENPROJECT_HOST__NAME matches your access URL
- PostgreSQL data corruption after unexpected shutdown: Stop all containers, backup postgres-data volume, restart db container and check logs for automatic recovery
- Memory issues with large projects: Increase PostgreSQL shared_buffers and OpenProject worker processes via additional environment variables

