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