Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
Cloud Foundry is an open source platform as a service (PaaS) for developers to deploy and scale applications without manually configuring and managing servers. The promise of “write once, run anywhere” means developers can build their apps on a programming language or framework of their choice, and be able to deploy it to any underlying cloud environment.
For example, developers could code a Java-based Spring Framework application, and “push” the application to a Cloud Foundry space. That space could be running in an on-premises OpenStack cloud, or a public cloud like Amazon AWS, Google Cloud Platform, IBM Bluemix or Microsoft Azure. The idea is that it hides away infrastructure details and services such as databases, so developers do not need to worry about managing the underlying environment.
The Cloud Foundry platform is available from either the Cloud Foundry Foundation as open source software, or as a commercial product or service from multiple providers. Pivotal Cloud Foundry (PCF) is a commercial offering from Pivotal.
As an open source low code platform to visually build enterprise web apps for coders and non-coders, Joget Workflow is a good complement for Cloud Foundry.
In this example, we will deploy Joget Workflow on PCF Dev from Pivotal. PCF Dev is a lightweight, easy to install distribution of Cloud Foundry designed to run on a developer machine, making it easier to locally develop, test and explore Cloud Foundry.
Install PCF Dev according to the instructions in the Pivotal Documentation.
Once installed, start PCF Dev using the command
Code Block |
---|
cf dev start |
and you should see the output:
Code Block |
---|
Downloading VM... Progress: |====================>| 100% VM downloaded Importing VM... Starting VM... Provisioning VM... Waiting for services to start... 40 out of 40 running _______ _______ _______ ______ _______ __ __ | || || | | | | || | | | | _ || || ___| | _ || ___|| |_| | | |_| || || |___ | | | || |___ | | | ___|| _|| ___| | |_| || ___|| | | | | |_ | | | || |___ | | |___| |_______||___| |______| |_______| |___| is now running. To begin using PCF Dev, please run: cf login -a https://api.local.pcfdev.io --skip-ssl-validation Admin user => Email: admin / Password: admin Regular user => Email: user / Password: pass |
Follow the instructions provided at the end of to connect to PCF Dev, by logging in using the admin user and choosing the pcfdev-org organization:
Code Block |
---|
cf login -a https://api.local.pcfdev.io --skip-ssl-validation |
You should have output like the following:
Code Block |
---|
API endpoint: https://api.local.pcfdev.io Email> admin Password> Authenticating... OK Select an org (or press enter to skip): 1. pcfdev-org 2. system Org> 1 Targeted org pcfdev-org Targeted space pcfdev-space |
In Cloud Foundry, all external dependencies such as databases, file systems and so on are considered services. Cloud Foundry allows administrators to provide a marketplace of services, from which users can provision reserved resources on-demand.
Here, we will create a MySQL Database Service.
In the command line, search the marketplace for MySQL plans available.
Code Block |
---|
cf marketplace -s p-mysql |
Create a service instance with the 1gb plan with the name jogetdb:
Code Block |
---|
cf create-service p-mysql 1gb jogetdb |
More detailed information can be found at https://pivotal.io/platform/pcf-tutorials/getting-started-with-pivotal-cloud-foundry-dev/connect-a-database
In Cloud Foundry, a volume service provides a reliable, persistent file system.
Create a service instance using the PCF Local Volume Service with the name jogetdata:
Code Block |
---|
cf create-service local-volume free-local-disk jogetdata |
More detailed information can be found at https://docs.cloudfoundry.org/devguide/services/using-vol-services.html and https://github.com/cloudfoundry/local-volume-release
Download Joget Workflow from https://www.joget.org/download/
Install Joget Workflow https://dev.joget.org/community/display/KBv6/Installing+Joget
Look for the Joget Workflow WAR file jw.war in joget_installation_directory/apache-tomcat/webapps.
Push the WAR to the Cloud Foundry space with a memory allocation of 1G and application name joget:
Code Block |
---|
cf push joget -p joget_installation_directory/apache-tomcat-8.5.23/webapps/jw.war -m 1G --no-start |
Note that we use the --no-start parameter to delay the start of the application, because we need to set a couple of environment variables before starting up.
Set the Apache Tomcat context path to /jw:
Code Block |
---|
cf set-env joget JBP_CONFIG_TOMCAT '{tomcat: {context_path: "/jw"}}' |
Next, disable the Spring auto reconfiguration. This is because the Joget Workflow WAR already performs the necessary initialization at startup, and the auto configuration will interfere with it:
Code Block |
---|
cf set-env joget JBP_CONFIG_SPRING_AUTO_RECONFIGURATION '[enabled: false]' |
Bind the local volume service to mount the persistent filesystem to the Joget data directory:
Code Block |
---|
cf bind-service joget jogetdata -c '{"mount":"/home/vcap/wflow"}' |
Bind the MySQL database service:
Code Block |
---|
cf bind-service joget jogetdb |
Verify that the services are bound to the Joget application:
Code Block |
---|
cf services |
For example the output shows the services bound to the joget application:
Code Block |
---|
name service plan bound apps last operation jogetdata local-volume free-local-disk joget create succeeded jogetdb p-mysql 1gb joget create succeeded |
Start the Joget application:
Code Block |
---|
cf start joget |
Now that the Joget Workflow platform has been deployed in Cloud Foundry, the final step is to setup the database schema, based on https://docs.cloudfoundry.org/devguide/services/migrate-db.html#single-migration.
Info | ||||
---|---|---|---|---|
If you are using Joget Workflow prior to version 6.0.3, you need to modify the default Joget Workflow SQL setup script due to a limitation in MySQL for PCF where explicit locking is not supported i.e. LOCK TABLES. SSH into the application:
And download the modified script:
|
At this point, we can obtain the MySQL database service credentials by viewing the environment variables:
Code Block |
---|
cf env joget |
In particular, note down the p-mysql service hostname, port, name, username and password.
Code Block |
---|
System-Provided: { "VCAP_SERVICES": { "local-volume": [ { "credentials": {}, "label": "local-volume", "name": "jogetdata", "plan": "free-local-disk", "provider": null, "syslog_drain_url": null, "tags": [ "local" ], "volume_mounts": [ { "container_dir": "/home/vcap/wflow", "device_type": "shared", "mode": "rw" } ] } ], "p-mysql": [ { "credentials": { "hostname": "mysql-broker.local.pcfdev.io", "jdbcUrl": "jdbc:mysql://mysql-broker.local.pcfdev.io:3306/cf_d13b2f40_c124_4c4b_a900_2269e10a7052?user=XMpalSAOEYcClZl2\u0026password=uSRs0B1D6NPNuLOe", "name": "cf_d13b2f40_c124_4c4b_a900_2269e10a7052", "password": "uSRs0B1D6NPNuLOe", "port": 3306, "uri": "mysql://XMpalSAOEYcClZl2:uSRs0B1D6NPNuLOe@mysql-broker.local.pcfdev.io:3306/cf_d13b2f40_c124_4c4b_a900_2269e10a7052?reconnect=true", "username": "XMpalSAOEYcClZl2" }, "label": "p-mysql", "name": "jogetdb", "plan": "1gb", "provider": null, "syslog_drain_url": null, "tags": [ "mysql" ], "volume_mounts": [] } ] } } { "VCAP_APPLICATION": { "application_id": "a450291a-0440-4727-ba78-c65f12d99961", "application_name": "joget", "application_uris": [ "joget.local.pcfdev.io" ], "application_version": "aedb8053-7288-4272-bcf7-85eab3dbd360", "cf_api": "http://api.local.pcfdev.io", "limits": { "disk": 512, "fds": 16384, "mem": 1024 }, "name": "joget", "space_id": "4376eb82-3935-49c1-b543-8df589392831", "space_name": "pcfdev-space", "uris": [ "joget.local.pcfdev.io" ], "users": null, "version": "aedb8053-7288-4272-bcf7-85eab3dbd360" } } User-Provided: JBP_CONFIG_SPRING_AUTO_RECONFIGURATION: [enabled: false] JBP_CONFIG_TOMCAT: {tomcat: {context_path: "/jw"}} |
Access Joget Workflow at http://joget.local.pcfdev.io/jw/ and you will be presented with the database setup page.
Proceed to setup the database according to the instructions at https://dev.joget.org/community/display/KBv6/Setting+Up+Database.
Once setup is complete, you will be brought to the Joget Workflow App Center.
Optionally, an application manifest file can be used to specify environment variables and bind services.
manifest.yml:
Code Block |
---|
--- applications: - name: joget memory: 1G buildpack: https://github.com/cloudfoundry/java-buildpack.git path: /path_to/jw.war services: - jogetdb - jogetdata env: JBP_CONFIG_SPRING_AUTO_RECONFIGURATION: '[enabled: false]' JBP_CONFIG_TOMCAT: '{tomcat: {context_path: "/jw"}}' |
However, there is a limitation that the current version of Cloud Foundry does not support specifying parameters when binding parameters, so binding of the local volume service to the Joget data directory has to be done manually:
Code Block |
---|
cf bind-service joget jogetdata -c '{"mount":"/home/vcap/wflow"}' cf restage joget |
View application logs:
Code Block |
---|
cf logs joget |
Restage the application after modifying service bindings or environment variables:
Code Block |
---|
cf restage joget |
Stop PCF Dev VM:
Code Block |
---|
cf dev stop |
Delete the PCF Dev VM:
Code Block |
---|
cf dev destroy |
Uninstall the PCF Dev Plugin:
Code Block |
---|
cf uninstall-plugin pcfdev |
View PCF Dev App Manager: