How to Deploy Ganib to Jelastic PAI

Ganib Enterprises is one of the world’s most popular and widely used open source project management software. The open source Ganib product suite includes an array of modules that provide project management system (PMS), project portfolio management (PPM), project plans, project dashboard, documents management, time and attendance tracking (PTO), timesheet, desktop time tracking and screen capture tool, etc.

Let’s see how to deploy Ganib to Jelastic Cloud.

A. Create an Environment

1. Open environment topology wizard by clicking Create environment button and choose Tomcat application server and MySQL database nodes. Set resource limits for them, enter environment name, and press Create. ganib 7883b5f904f95966acba7e076383da9aenv topology

2. In a few moments your new environment will appear at the panel. ganib 7883b5f904f95966acba7e076383da9anew env

B. Ganib Deployment

1. To download Ganib project management system’s community edition navigate to the Sourceforge page. ganib 7883b5f904f95966acba7e076383da9asourceforge

2. Open the latest release folder (Ganib 3.3 in our case) and download ganib.war file it contains. ganib 7883b5f904f95966acba7e076383da9aganib war

3. Navigate back to the Jelastic dashboard and upload .war file you’ve just downloaded. ganib 7883b5f904f95966acba7e076383da9auplod war

4. Finally, click Deploy to button and choose previously created environment in the list. ganib 7883b5f904f95966acba7e076383da9adeploy to

5. In a minute Ganib application will be deployed to the chosen environment. ganib 7883b5f904f95966acba7e076383da9aganib deployed

C. MySQL Configuration

1. Click Open in browser button next to the MySQL node in your environment. ganib 7883b5f904f95966acba7e076383da9amysql open

2. While you were creating the environment, Jelastic sent you the email with credentials to the database. Create a user and a database (e.g. ganib) using these credentials. ganib 7883b5f904f95966acba7e076383da9aadd db user

3. After that unpack the downloaded Ganib .war file and find ganib.sql file in the database folder. Import it to the database you’ve created at the previous step. ganib 7883b5f904f95966acba7e076383da9aimport sql

Wait for a few minutes till this operation will be completed.

D. Ganib Configuration

1. Navigate back to the dashboard and click Config button for Tomcat server: ganib 7883b5f904f95966acba7e076383da9atomcat config

2. Open the lib folder and upload MySQL connector and Java mail library. ganib 7883b5f904f95966acba7e076383da9alibs

3. Then navigate to the server > context.xml file and add the following lines at the very bottom before closing Context tag.
<Resource name=“jdbc/GanibDB” auth=“Container” type=“javax.sql.DataSource” username=“root”  password="" driverClassName=“com.mysql.jdbc.Driver”  url=""  maxActive=“125” maxIdle=“25” />

Note you should specify settings of your database in these strings:

  • credentials you’ve received while environment creation
  • URL for your database in the following format:
jdbc:mysql://mysql-{env_name}.{[hoster's_domain](https://docs.jelastic.com/jelastic-hoster-info)}:3306/{database_name}?useUnicode=true&characterEncoding=utf-8&autoReconnect=true

ganib 7883b5f904f95966acba7e076383da9acontext xml

4. Save the changes you’ve made.

5. Press Restart next to the Tomcat node in order to apply the configuration changes. ganib 7883b5f904f95966acba7e076383da9arestart tomcat

E. Start the Application

1. Finally, click Open in browser button near your environment. ganib 7883b5f904f95966acba7e076383da9aopen in browser

2. You will see the Ganib start page and can proceed to using it. ganib 7883b5f904f95966acba7e076383da9aganib welcome page

Now you have your own Ganib application deployed with Jelastic Cloud. Enjoy!