To setup and run ProjeQtOr, a simple PHP / MySql stack is needed: use your favorite stack (EasyPHP, ZEND, WAMP, XAMPP) and enjoy the collaborative web mode.
The required components and their versions are:
- Apache V2 or higher (latest stable version recommended)
- MySQL V5 or higher (latest stable version recommended)
ATTENTION, ProjeQtOr is compatible with MySql V8.0.20 and over only since V8.6
or PostgreSQL : V9.1 or greater required (latest stable recommended) - PHP: V5.6 or higher required (V7.3 or over advised).
Compatibility Matrix Versions of ProjeQtOr Versions of PHP Version of MySql ProjeQtOr V1.0 to V6.4 PHP 5.2 to PHP 7.0 MySql 5.6 to MySql 8.0.19 ProjeQtOr V6.5 PHP 5.2 to PHP 7.1 ProjeQtOr V7.0 to V8.3 PHP 5.4 to PHP 7.3 ProjeQtOr V8.4 to V8.5 PHP 5.4 to PHP 7.4 ProjeQtOr V8.6 MySql 5.6 to MySql 8.3 ProjeQtOr V9.0 to V9.5 PHP 5.6 to PHP 8.0 ProjeQtOr V10.0 PHP 5.6 to PHP 8.1 ProjeQtOr V10.1 to V10.2 PHP 7.0 to PHP 8.1 ProjeQtOr V10.3 to V11.1 PHP 7.0 to PHP 8.2 ProjeQtOr V11.2 and over PHP 7.4 to PHP 8.3
Required PHP extensions (usually installed by default ) are :
- gd ⇒ for the graphical reports
- imap ⇒ to retreive replies from emails
- mbstring ⇒ for UTF-8 compatibility (required)
- mysql ⇒ to access the MySql database
- openssl ⇒ for sending mails, if authenticated access to the SMTP server is used
- pdo_mysql ⇒ to access the MySql database
- pdo_pqsql ⇒ to access the PostgreSQL database (if choosing PostgreSql as database)
- pgsql ⇒ to access the PostgreSQL database (if choosing PostgreSql as database)
- php-xml ⇒ for XML parsing
- zip ⇒ ZipArchive class is mandatory to manage plug-ins and exports to Excel format
- curl ⇒ mandatory for some plugins
Recommended PHP configuration (php.ini ) is :
- max_input_vars = 4000 ; (must be greater than 2000 to run "real work allocation" with high number on lines)
- max_execution_time = 30; (recommended as a minimum)
- memory_limit = 512M ; (recommended as a minimum for PDF generation)
- file_uploads = On; (to allow file attachments and document management)
- error_reporting = E_ALL & ~E_DEPRECATED & ~E_STRICT
Recommended MySql configuration (in my.ini ou my.cnf) :
- innodb-default-row-format=dynamic
- collation when creating the database :
- For ProjeQtOr < V10.0 : utf8_general_ci
- For ProjeQtOr >= V10.0 : utf8mb4_general_ci
Advice on choosing a PHP / MySql stack
- In an Test or Validation environment: EasyPHP (Windows) is easy to install and works great
- For a Production environment: ZEND + MySql Server (all OS) is a reliable and efficient solution
Size of server
- All will depend on your use of ProjeQtOr :
- how many connected users on same time,
- what operation they do (planning calculation for several projects is much more complex than just read a ticket)
- how many projects, activities, tickets
- ...
- We advise to have at least 2 CPUs, moreover if MySql and Apache/PHP are on same server. Higher frequency the better.
- HDD size : about 100 MB for application, from 100MB to 1GB for DB (depending on volumetrics), enough place to store attachments. SSD advised.
- RAM : at least 4 GB.
- For example, our hosting servers are :
- Intel® Xeon E3 1245v5 : 4 cores - double threaded = 8 CPUs, 3.5-3.9 GHz
- 32 GB RAM
- 3 x 250 GB SSD drives in RED 5
- Network : 1 Gbit/sec
- Actual Max Volumetrics : 1000 identified users, 10000 projects, 40000 activities, 5000 tickets