Skip to main content

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
Back to top