Projeqtor

Docker Projeqtor

GitHub repo

This docker image provides a Projeqtor container with LDAP support.

This image is based on php:7.4-apache

Version of Projeqtor in this image is currently 9.4.2

Exposed ports :

80 : Projeqtor Webpanel

Volumes

They are two volume mounted on this image :

/mnt/documents /mnt/logs

Both need to have rw access

Environment

Current used environments vars :

PHP ENV

Environment variable Default Recommended PHP_MAX_INPUT_VARS 4000 Must be > 2000 for real work allocation screen PHP_REQUEST_TERMINATE_TIMEOUT 0 Must not end requests on timeout to let cron run without ending PHP_MAX_EXECUTION_TIME 30 30 is minimum advised PHP_MEMORY_LIMIT 512M 512M is minimum advised for PDF generation

Projeqtor ENV

Name Default Usage PJT_DB_TYPE mysql Database type. Can be mysql or pgsql PJT_DB_HOST 127.0.0.1 Database host (server name) PJT_DB_PORT 3306 Database port PJT_DB_USER root Database user to connect PJT_DB_PASSWORD root Database password for user PJT_DB_NAME projeqtor Database schema name PJT_DB_PREFIX empty Database prefix for table names PJT_SSL_KEY empty SSL Certificate key path PJT_SSL_CERT empty SSL Certificate path PJT_SSL_CA empty SSL Certificate CA path PJT_ATTACHMENT_MAX_SIZE_MAIL 2097152 Max file size in email PJT_LOG_LEVEL 2 Log level {'4' for script tracing, '3' for debug, '2' for general trace, '1' for error trace, '0' for none} PJT_ENFORCE_UTF8 1

Installed PHP extensions

Extension Usage qd For reports graphs imap To retrieve mails to insert replay as notes mbstring Mandatory. for UTF-8 compatibility mysqli For default MySql database pgsql If database is PostgreSql pdo BDD connector pdo_mysql For default MySql database pdo_pgsql If database is PostgreSql openssl To send mails if smtp access is authentified (with user / password) ldap Directory Access Protocol, and is a protocol used to access "Directory Servers" zip ZipArchive class is mandatory to manage plugins and export to Excel format

Ready 2 Go Stack

Here is my own compose I used to deploy Projeqtor stack with MySQL database.

First deploy may require admin login (on Projeqtor login page) to init DB.

This stack is for Docker Swarm, if you want to run it on simple docker compose, you must replace overlay in network definition by bridge

version: '3.8'

services:
  mysql_service:
    image: mysql:latest
    volumes:
      - mysql_data:/var/lib/mysql
    networks:
      - projeqtor_network
    environment:
      - MYSQL_ROOT_PASSWORD=changeme
      - MYSQL_DATABASE=projeqtor
  projeqtor_service:
    image: nospy/projeqtor:latest
    depends_on:
      - mysql_service
    volumes:
      - projeqtor_documents:/mnt/documents
      - projeqtor_logs:/mnt/logs
    ports:
      - "25:25"
      - "80:80"
    networks:
      - projeqtor_network
    environment:
      - PHP_MAX_EXECUTION_TIME=30
      - PHP_MAX_INPUT_VARS=4000
      - PHP_MAX_UPLOAD_SIZE=1G
      - PHP_MEMORY_LIMIT=512M
      - PHP_REQUEST_TERMINATE_TIMEOUT=0
      - PJT_ATTACHMENT_MAX_SIZE_MAIL=2097152
      - PJT_DB_TYPE=mysql
      - PJT_DB_HOST=mysql_service
      - PJT_DB_PORT=3306
      - PJT_DB_NAME=projeqtor
      - PJT_DB_USER=root
      - PJT_DB_PASSWORD=changeme
volumes:
  mysql_data:
  projeqtor_documents:
  projeqtor_logs:

networks:
  projeqtor_network:
    driver: overlay
    attachable: true