Install JOGET for Ubuntu

Joget DX is a next generation open source application platform for faster, simpler digital transformation (DX).

Joget DX combines the best of business process automationworkflow management and low code application development in a simple, flexible and open platform. Business and technical teams can collaborate to rapidly build full-fledged enterprise applications visually, anywhere, anytime.

  • Web-based visual approach empowers non-coders to build and maintain apps anytime, anywhere
  • Reduces time to market, from months to weeks or days
  • Apps built are mobile ready, cloud ready
  • APIs for integration and plugin architecture for extensibility
  • “App Store” for enterprise apps – Joget Marketplace
Source : https://www.joget.org/product/joget-dx/

Step 1 : Install Java
---------------------

$ sudo mkdir /usr/local/java
$ cd /usr/local/java
$ wget https://javadl.oracle.com/webapps/download/AutoDL?BundleId=244058_89d678f2be164786b292527658ca1605
$ sudo tar xzvf jre-8u281-linux-x64.tar.gz
$ sudo chown -R root:root /usr/local/java/jre1.8.0_281/
$ sudo update-alternatives --install "/usr/bin/java" "java" "/usr/local/java/jre1.8.0_281/bin/java" 1
$ java -version
java version "1.8.0_281"
Java(TM) SE Runtime Environment (build 1.8.0_281-b09)
Java HotSpot(TM) 64-Bit Server VM (build 25.281-b09, mixed mode)

 

Step 2 : Install MySQL
----------------------
$ sudo apt-get install gnupg2
$ wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
$ sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb
$ sudo apt-get update
$ sudo apt-get install percona-server-server-5.7
$ sudo vi /etc/mysql/percona-server.conf.d/mysqld.cnf

[mysqld]
server-id = 1
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
explicit_defaults_for_timestamp

log-error = /var/log/mysql/error.log

# Recommended in standard MySQL setup
#sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_ALL_TABLES
sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links = 0

#--- TUNNING ---#
log-bin
log_slave_updates
expire_logs_days = 7
character-set-server = utf8
collation-server = utf8_general_ci
character-set-client-handshake = false
init-connect = 'SET NAMES utf8'
transaction-isolation = READ-COMMITTED

#--- Settings / Tunning Options ---#
bind-address = 127.0.0.1
performance_schema = ON

# INNODB #
innodb_file_format = Barracuda
innodb_file_per_table = ON
innodb_large_prefix = 1

innodb_flush_method = O_DIRECT
innodb_log_files_in_group = 2
innodb_log_file_size = 512M
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table = 1
innodb_buffer_pool_size = 40G
innodb_locks_unsafe_for_binlog = 1
innodb_autoinc_lock_mode = 2
innodb_flush_log_at_timeout = 8
innodb_read_io_threads = 64
innodb_write_io_threads = 64
innodb_doublewrite = OFF
join_buffer_size = 40G

# SAFETY #
#default-time-zone = 'Asia/Jakarta'
max_allowed_packet = 1024M
max_connect_errors = 9999999
#skip_name_resolve
skip-external-locking
slow_query_log = 1
event_scheduler = on
sysdate_is_now = 1
#innodb = FORCE
#innodb_strict_mode = 1
##pxc_strict_mode = DISABLED

# CACHES AND LIMITS #
tmp_table_size = 1024M
max_heap_table_size = 5120M
query_cache_type = 0
query_cache_size = 0
max_connections = 100000
thread_cache_size = 50
open_files_limit = 65535
table_definition_cache = 4096
table_open_cache = 10000
#allow_persistent = Off
thread_pool_size = 32
#thread_pool_max_thread = 65535
max_user_connections = 100000
connect_timeout = 1800
wait_timeout = 1800
lock_wait_timeout = 3600
interactive_timeout = 1800
query_cache_limit = 102400
$ sudo systemctl restart mysql
$ mysql -u root -p
create database db_joget;
grant all on db_joget.* to [email protected] identified by 'PasswordJoget';
flush privileges;
quit;

 

Step 3 : Install Joget
———————–
Download file Joget https://sourceforge.net/projects/jogetworkflow/files/joget-linux-7.0.14.tar.gz/download dan upload ke server
copykan file joget-linux-7.0.14.tar.gz ke folder /opt

$ cd ~
$ sudo useradd -r -m -U -d /opt/tomcat -s /bin/false tomcat
$ cd /opt
$ sudo tar xzvf joget-linux-7.0.14.tar.gz
$ sudo chown -R tomcat:tomcat /opt/joget-linux-7.0.14/

Setup Database Joget

$ cd /opt/joget-linux-7.0.14/
$ sudo ./setup.sh

pada tahapan ini sesuaikan isian dengan database yang telah dibuat diatas

$ sudo vi /etc/systemd/system/tomcat.service
[Unit]
Description=Tomcat 8.5.63 servlet container
After=network.target

[Service]
Type=forking

User=tomcat
Group=tomcat

WorkingDirectory=/opt/joget-linux-7.0.14

Environment="JAVA_HOME=/usr/local/java/jre1.8.0_281"
Environment="JAVA_OPTS=-Djava.security.egd=file:///dev/urandom -Djava.awt.headless=true"

Environment="CATALINA_BASE=/opt/joget-linux-7.0.14/apache-tomcat-8.5.58"
Environment="CATALINA_HOME=/opt/joget-linux-7.0.14/apache-tomcat-8.5.58"

ExecStart=/opt/joget-linux-7.0.14/tomcat8.sh start
ExecStop=/opt/joget-linux-7.0.14/tomcat8.sh stop

[Install]
WantedBy=multi-user.target
$ sudo systemctl daemon-reload
$ sudo systemctl start tomcat
$ sudo systemctl enable tomcat

Step 4 : Browsing Joget
-----------------------
URL : http://<ipserver>:8080/jw/