venopsis / docker-projeqtor

Dockerized Projeqtor with PHP extensions

Docker-Projeqtor

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.5.4

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 use 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 tyou wnat 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