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 and over |
|
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 and over |
PHP 7.0 to PHP 8.2 |
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