The easiest and most common way to install the application is through the web installer located at https://127.0.0.1/Install if you put it into your apache2 directory. Alternatively you can also install it through a command line interface (cli).
- Server Recommendations
- Quick Installation Guide
- Webserver and Database
- Php
- Software
- Application Instllation
The server recommendations strongly depend on your individual needs, in the following you will find some general recommendations.
| Type | Minimum requirements | Recommendations |
|---|---|---|
| Storage | SSD 1 GB +space for documents | SSD 10 GB +space for documents |
| CPU | i5 3.2 GHz / Xeon E3 3.8 GHz (4 cores) | Xeon Silver 2.40 GHz (10 cores) min. 4 cores dedicated to the application |
| RAM | 4GB DDR3 3000 MHz | 32 GB DDR4 3200 |
| Operating System | Linux or Windows | Linux |
The above mentioned recommendations are for the basic application use case without additional tools and software which you maybe want to install or have already running on the server. Furthermore, the amount of concurrent users also impacts which hardware requirements are necessary (above we calculated with 50 concurrent users)
The following commands give an overview of how to setup your server for the application. Some of the steps may not be necessary or require changes depending on your server environment.
add-apt-repository ppa:ondrej/php
apt-get update
apt-get upgrade
apt-get install snap software-properties-common
apt-get install php8.3 php8.3-dev php8.3-cli php8.3-common php8.3-intl php8.3-mysql php8.3-pgsql php8.3-opcache php8.3-pdo php8.3-sqlite php8.3-mbstring php8.3-curl php8.3-imap php8.3-bcmath php8.3-zip php8.3-dom php8.3-xml php8.3-phar php8.3-gd php-pear apache2 libapache2-mpm-itk apache2-utils mariadb-server mariadb-client xvfb libfontconfig wkhtmltopdf tesseract-ocr poppler-utils imagemagick redis-server wget
phpenmod redis
phpenmod mbstring
mkdir -p /var/cache/apache2
chown -R www-data:www-data /var/cache/apache2
systemctl enable apache2
a2enmod rewrite
a2enmod expires
a2enmod headers
a2enmod cache
a2enmod cache_disk
a2enmod mpm_itk
systemctl restart apache2
systemctl start apache-htcacheclean
mysql_secure_installation
# IMPORTANT: Update my.cnf file with log_bin_trust_function_creators = 1
systemctl start mariadb
systemctl enable mariadb
mysql -u root -p
CREATE USER 'YOUR_DB_USERNAME'@'%' IDENTIFIED BY 'YOUR_DB_PASSWORD';
CREATE DATABASE oms';
GRANT ALL PRIVILEGES ON oms.* TO 'YOUR_DB_USERNAME'@'%';
cat << EOF > /etc/apache2/sites-available/000-jingga.conf
<VirtualHost *:80>
ServerAdmin [email protected]
DocumentRoot /var/www/html/jingga
ServerName your_server.com
SetEnv OMS_STRIPE_SECRET 0
SetEnv OMS_STRIPE_PUBLIC 0
SetEnv OMS_STRIPE_WEBHOOK 0
SetEnv OMS_PRIVATE_KEY_I 0
<Directory /var/www/html/jingga>
Options Indexes FollowSymLinks
AllowOverride All
Require all granted
</Directory>
<IfModule mpm_itk_module>
AssignUserId www-jingga www-data
</IfModule>
ErrorLog \${APACHE_LOG_DIR}/error.log
CustomLog \${APACHE_LOG_DIR}/access.log combined
</VirtualHost>
EOF
useradd www-jingga
usermod -a -G www-data www-jingga
usermod -d /var/jingga www-jingga
mkdir -p /var/jingga
chown www-jingga:www-data /var/jingga
sudo -u www-jingga mkdir /var/www/html/jingga
chown -R www-data:www-data /var/www
a2ensite 000-jingga.conf
# You may have to install a ssl certification
snap install --classic certbot
ln -s /snap/bin/certbot /usr/bin/certbot
certbot --apache
certbot renew --dry-run
systemctl reload apache2
systemctl restart apache2- The commands above do the following:
- Install the necessary software (incl. a web server and database)
- Setup the web server and database:
- Creates a new website configuration
- Creates a database user
- Creates a database
- Creates a new user for the web server
- Setup ssl certificate (for https)
- Now you can put the application data into the
/var/www/html/jinggadirectory - Visit the application in your browser
your_ip/Install - Follow the installation steps in your browser
If you don't have a web server already installed please install the web server of your choice. Web servers which are supported are apache2 and nginx. Databases which are supported are mysql/mariadb, postgres and mssql/sqlsrv.
If you are on Windows you may want to download and install the newest version of Xampp / Bitnami. During the installation please make sure your install php and mysql.
On linux you may want to install apache2 and mysql/mariadb. Please note you can also use this application with nginx and postgres:
sudo add-apt-repository ppa:ondrej/php
sudo apt-get update
sudo apt-get install software-properties-common apache2 mariadb-server mariadb-client
sudo a2enmod rewrite
sudo a2enmod headers
sudo service apache2 restartThe minimum php version requirement in the following installation guide is version 8.2.
On Windows php should already be installed with the web servers mentioned above just like the various extensions.
The following extensions are recommended and sometimes even mandatory:
sudo apt-get install php8.3 php8.3-dev php8.3-cli php8.3-common php8.3-mysql php8.3-pgsql php8.3-opcache php8.3-pdo php8.3-sqlite php8.3-mbstring php8.3-curl php8.3-imap php8.3-bcmath php8.3-zip php8.3-dom php8.3-xml php8.3-phar php8.3-gd php-pear sqlite3
sudo service apache2 restartSome modules in the application may need text recognition of scanned files (e.g. DocumentManagement). If you don't use such a module you don't need to install this.
Download and install tesseract-ocr. Download and install pdftotext. Download and install pdftoppm.
sudo apt-get install tesseract-ocr poppler-utilsCaching allows the application to store data in memory instead of re-calculating it again and again. This can speed up the general behavior of the application. Supported caching are redis and memcached (not memcache)
On windows you may want to download and install redis.
For caching you may install redis or memcached:
sudo apt install redis-server
sudo phpenmod redisOn windows you may want to download and install wget
sudo apt-get install wgetOn windows you may want to download and install wkhtmltopdf
sudo apt-get install xvfb libfontconfig wkhtmltopdfsudo apt-get install imagemagickBefore you can install the application you need to put the application files into the web server directory. This directory depends on the web server which you used and the web server configuration.
By default the windows directory should be C:/xampp/htdocs. Remove all files in this directory and put all the files of the Jingga application into this directory.
By default the linux directory should be /var/www/htm. Remove all files in this directory and put all the files of the Jingga application into this directory.
File permissions should only be an issue on linux. You can change the file permissions of directories as follows:
sudo chown -R www-data:www-data .
sudo find . -type d -exec chmod 755 {} \;
sudo find . -type f -exec chmod 644 {} \;
sudo chmod 640 config.phpIf you installed the application on your local computer you can open a browser window and navigate to http://127.0.0.1/Install. If you installed it on a remote server, navigate to the URL of that server.
Click yourself through the installation and fill out the forms during the installation process.
On the page called pre-installation check the installation script will check and inform you if the necessary php extensions and file permissions are available. Only requirements marked as optional can be missing. If any other requirements fail please don't continue with the installation and fix these requirements first. Once you fixed the requirements reload the installation script!
If the extension is already installed you can just add it to your php.ini file of extension loading files in conf.d/. e.g.:
extension=mbstring.dll // Example in case you are installing on Windows
extension=mbstring.so // Example in case you are installing on LinuxThe
php.inifile can be often found at C:/xampp/php/php.ini on Windows and /etc/php/X.X/apache2/php.ini on Linux.Sometimes the ending .dll and .so must be omitted depending on the version and configuration of your php installation.
If the extension is not installed and not activated you can alternatively run the following commands on Linux (just as example):
sudo apt-get install php8.3-mbstring
sudo phpenmod mbstringOn windows you may follow the php installation guide or the installation guide of your chosen web server which maybe already includes php.
On this page you must enter the database information which the application can use to store data.
The address for the database server usually is 127.0.0.1
The database type depends on which database you used. If you followed this installation you probably used mysql or mariadb
The port depends on the database you installed. Different database vendors use different ports. If you followed this installation you probably used mysql or mariadb, in this case the port is 3306. If you used another database, please check the documentation of that database to find the default port.
The recommended database name is oms. Please note that this database must be manually created by you. If you've not already done so during the database installation process, please create that database now. In order to create this database please check the documentation of your database vendor. On windows you might be able to log into phpmyadmin and create this database.
For security purposes we recommend that you create 5 different users in your database application who only have access to oms database and each one of the users may only have the following permissions. The application installation script cannot create these users, please make sure you already created them:
- One user may only be able to do schema changes
- One user may only create data
- One user may only read/select data
- One user may only update/modify data
- One user may only delete/remove data
It is possible to always input the same user and same password for all users in the installation script but this is not recommended. If you just want to get started you may input the user and password which you defined during the database installation. Nevertheless, please change this in the future.
On the last page you can define the name of your organization/company.
Here you must define the admin login name, the admin password and email.
The top level domain is the domain name where you installed the application. If you only installed it locally, it is 127.0.0.1. If you installed it on your web server, then you input the domain name e.g. jingga.app
The web subdirectory by default is /. If you installed the application in a subdirectory instead of the main directory of your web server you input the name of the subdirectory here e.g. /subdir/.
After clicking install you will either receive a message that something went wrong e.g. some configurations are wrong (please fix them) or the installation will redirect you to the login if everything went smoothly. Please make sure to delete the Install directory so that no-one else can use it.
Navigate to the Install directory, modify the cli.php and config.php and then run the cli.php as www-data
sudo -u www-data php cli.php