# OpenProject

> Open source project management software.

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

## Overview

OpenProject is a comprehensive open-source project management platform that combines traditional project planning with modern agile methodologies. Originally launched in 2012 as a fork of ChiliProject, it has evolved into a full-featured enterprise-ready solution offering Gantt charts, work package management, agile boards, time tracking, and specialized modules for construction projects through BIM (Building Information Modeling) integration. The platform serves as a complete alternative to proprietary tools like Microsoft Project, Jira, and Asana while maintaining full control over your project data.

This Docker deployment creates a three-container architecture with the OpenProject application server, a dedicated PostgreSQL database for reliable data persistence, and Memcached for session and query caching to improve performance. The PostgreSQL database ensures ACID compliance and data integrity for complex project relationships, while Memcached reduces database load during peak usage periods with multiple concurrent users accessing project data.

This configuration is ideal for teams ranging from small startups to large enterprises who need a self-hosted project management solution with advanced features like resource management, budget tracking, and custom workflows. The combination of OpenProject's rich feature set with PostgreSQL's reliability makes it particularly suitable for organizations handling complex, long-term projects requiring detailed documentation and compliance tracking.

## Features

- Work package management with custom fields, relationships, and hierarchical task structures for complex project organization
- Interactive Gantt charts with drag-and-drop scheduling, critical path visualization, and dependency management
- Agile boards with Scrum and Kanban support, sprint planning, and burndown charts for iterative development
- Time tracking and cost reporting with detailed logging, approval workflows, and budget monitoring capabilities
- BIM module for construction projects with 3D model viewing, issue tracking directly on models, and BCF format support
- Multi-project dashboards with customizable widgets, cross-project reporting, and portfolio management views
- Advanced user management with role-based permissions, LDAP/SAML integration, and project-specific access controls
- Wiki and document management with version control, collaborative editing, and integration with work packages

## Use cases

- Software development teams managing sprints, releases, and bug tracking with integrated version control workflows
- Construction companies coordinating complex building projects with BIM models, subcontractor management, and compliance tracking
- Consulting firms tracking billable hours, project budgets, and client deliverables across multiple concurrent engagements
- Non-profit organizations managing grant-funded projects with detailed reporting requirements and volunteer coordination
- Manufacturing companies planning product development cycles with resource allocation and cross-departmental collaboration
- Educational institutions coordinating research projects, thesis supervision, and academic program management
- Government agencies handling public works projects with transparency requirements and multi-stakeholder coordination

## Prerequisites

- Docker and Docker Compose installed with at least 2GB available RAM for the complete stack
- Port 8080 available for OpenProject web interface access
- Generated SECRET_KEY_BASE using openssl rand -hex 64 for secure session management
- Environment variables configured for DB_PASSWORD and SECRET_KEY in .env file
- Basic understanding of project management concepts like work packages, Gantt charts, and agile methodologies
- Administrative access for initial setup and user management configuration

## docker-compose.yml

```yaml
services:
  openproject:
    image: openproject/community:latest
    container_name: openproject
    restart: unless-stopped
    environment:
      OPENPROJECT_SECRET_KEY_BASE: ${SECRET_KEY}
      OPENPROJECT_HOST__NAME: localhost:8080
      OPENPROJECT_HTTPS: "false"
      DATABASE_URL: postgres://openproject:${DB_PASSWORD}@db/openproject
    ports:
      - "8080:80"
    volumes:
      - openproject_data:/var/openproject/assets
    depends_on:
      - db
      - memcached

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

  memcached:
    image: memcached:alpine
    container_name: openproject-memcached

volumes:
  openproject_data:
  openproject_db:
```

## .env

```bash
SECRET_KEY=generate-long-random-key
DB_PASSWORD=changeme
```

## Usage notes

- Docs: https://www.openproject.org/docs/
- Access at http://localhost:8080 - default: admin/admin
- Gantt charts, work packages, agile boards, time tracking
- BIM (Building Information Modeling) module for construction
- LDAP/SAML authentication for enterprise
- Generate SECRET_KEY: openssl rand -hex 64

## Troubleshooting

- OpenProject container fails to start with database connection errors: Verify DB_PASSWORD matches between openproject and db services in environment variables
- Web interface shows 'Application failed to start' error: Check that SECRET_KEY_BASE environment variable is properly set and contains a valid 64-character hex string
- Slow page loading and timeouts during peak usage: Monitor memcached container status and consider increasing memory limits if cache evictions are frequent
- PostgreSQL container exits with permission denied errors: Ensure openproject_db volume has proper ownership and the postgres user can write to mounted directories
- Email notifications not working after setup: Configure SMTP settings through OpenProject admin panel as the default configuration uses local delivery only
- File uploads failing with 413 entity too large errors: Increase client_max_body_size in any reverse proxy configuration or modify OpenProject's upload limits

