Knowage 6.2 Installer in Ubuntu 18.04

I will follow this step for make sure it can work correctly

This video use Knowage 6.2.1 on Ubuntu 18 and Use Oracle JDK 8 and MySQL Server 5.7

Step 1. Install Java / Step 2. Configure System Variables

sudo apt install software-properties-common
sudo add-apt-repository ppa:webupd8team/java
sudo apt update

sudo apt install oracle-java8-installer
sudo apt install oracle-java8-set-default

# Setup JAVA_HOME
export JAVA_HOME=/usr/lib/jvm/java-8-oracle
export PATH=$JAVA_HOME/bin:$PATH

# Verify JDK is Installed
java -version

# java version "1.8.0_201"
# Java(TM) SE Runtime Environment (build 1.8.0_201-b09)
# Java HotSpot(TM) 64-Bit Server VM (build 25.201-b09, mixed mode)

Reference: Command [add-apt-repository] Missing | Install Java 8 | Setup System Variables

Step 3. Install MySQL

sudo apt install mysql-server
sudo mysql_secure_installation

# Add user and grant privileges
mysql -u root -p

# create user 'username'@'localhost' identified by 'password';
create user 'knowage'@'localhost' identified by 'knowage';

# grant all privileges on *.* to 'username@'localhost' identified by 'password';
grant all privileges on *.* to 'knowage'@'localhost' identified by 'knowage';

exit;

Reference: MySQL Add User and Grant | MySQL Grant Detail

Step 4,5,6. Download Knowage, Uncompress the file, Execute the file

unzip Knowage-6_2_1-CE-Installer-Unix-20180926.zip
chmod +x Knowage-6_2_1-CE-Installer-Unix-20180926.sh
./Knowage-6_2_1-CE-Installer-Unix-20180926.sh

Then follow the process. ;)

---

Use HTTPS Reverse Proxy with Apache

Reference: Knowage Question - HTTPS Reverse Proxy with Apache

sudo apt install apache2

sudo a2enmod proxy
sudo a2enmod proxy_http
sudo a2enmod proxy_balancer
sudo a2enmon lbmethod_byrequests

sudo a2enmod ssl
sudo a2ensite default-ssl

Then edit files 000-default.conf and default-ssl.conf

# Knowage Service Name

#01 knowage
#02 knowagebirtreportengine
#03 knowagecockpitengine
#04 knowagecommonjengine
#05 knowagedataminingengine
#06 knowagegeoreportengine
#07 knowagejasperreportengine
#08 knowagekpiengine
#09 knowagemeta
#10 knowagenetworkengine
#11 knowageqbeengine
#12 knowagesvgviewerengine
#13 knowagetalendengine
#14 knowagewhatifengine

HTTP

sudo nano /etc/apache2/sites-enabled/000-default.conf

<VirtualHost *:80>
  ProxyRequests Off
  ProxyPreserveHost On

  Redirect /knowage /knowage/

  # Force to HTTPS
  # Redirect /knowage https://[this-domain-name]/knowage/
  # Redirect /knowage/ https://[this-domain-name]/knowage/

  ProxyPass /knowage/ http://192.168.1.245:8080/knowage/
  ProxyPass /knowagebirtreportengine/ http://192.168.1.245:8080/knowagebirtreportengine/
  ProxyPass /knowagecockpitengine/ http://192.168.1.245:8080/knowagecockpitengine/
  ProxyPass /knowagecommonjengine/ http://192.168.1.245:8080/knowagecommonjengine/
  ProxyPass /knowagedataminingengine/ http://192.168.1.245:8080/knowagedataminingengine/
  ProxyPass /knowagegeoreportengine/ http://192.168.1.245:8080/knowagegeoreportengine/
  ProxyPass /knowagejasperreportengine/ http://192.168.1.245:8080/knowagejasperreportengine/
  ProxyPass /knowagekpiengine/ http://192.168.1.245:8080/knowagekpiengine/
  ProxyPass /knowagemeta/ http://192.168.1.245:8080/knowagemeta/
  ProxyPass /knowagenetworkengine/ http://192.168.1.245:8080/knowagenetworkengine/
  ProxyPass /knowageqbeengine/ http://192.168.1.245:8080/knowageqbeengine/
  ProxyPass /knowagesvgviewerengine/ http://192.168.1.245:8080/knowagesvgviewerengine/
  ProxyPass /knowagetalendengine/ http://192.168.1.245:8080/knowagetalendengine/
  ProxyPass /knowagewhatifengine/ http://192.168.1.245:8080/knowagewhatifengine/

  ProxyPassReverse /knowage/ http://192.168.1.245:8080/knowage/
  ProxyPassReverse /knowagebirtreportengine/ http://192.168.1.245:8080/knowagebirtreportengine/
  ProxyPassReverse /knowagecockpitengine/ http://192.168.1.245:8080/knowagecockpitengine/
  ProxyPassReverse /knowagecommonjengine/ http://192.168.1.245:8080/knowagecommonjengine/
  ProxyPassReverse /knowagedataminingengine/ http://192.168.1.245:8080/knowagedataminingengine/
  ProxyPassReverse /knowagegeoreportengine/ http://192.168.1.245:8080/knowagegeoreportengine/
  ProxyPassReverse /knowagejasperreportengine/ http://192.168.1.245:8080/knowagejasperreportengine/
  ProxyPassReverse /knowagekpiengine/ http://192.168.1.245:8080/knowagekpiengine/
  ProxyPassReverse /knowagemeta/ http://192.168.1.245:8080/knowagemeta/
  ProxyPassReverse /knowagenetworkengine/ http://192.168.1.245:8080/knowagenetworkengine/
  ProxyPassReverse /knowageqbeengine/ http://192.168.1.245:8080/knowageqbeengine/
  ProxyPassReverse /knowagesvgviewerengine/ http://192.168.1.245:8080/knowagesvgviewerengine/
  ProxyPassReverse /knowagetalendengine/ http://192.168.1.245:8080/knowagetalendengine/
  ProxyPassReverse /knowagewhatifengine/ http://192.168.1.245:8080/knowagewhatifengine/
</VirtualHost>

HTTPS

sudo nano /etc/apache2/site-enabled/default-ssl.conf

<VirtualHost *:443>
  ProxyRequests Off
  ProxyPreserveHost On

  Redirect /knowage /knowage/

  ProxyPass /knowage/ http://192.168.1.245:8080/knowage/
  ProxyPass /knowagebirtreportengine/ http://192.168.1.245:8080/knowagebirtreportengine/
  ProxyPass /knowagecockpitengine/ http://192.168.1.245:8080/knowagecockpitengine/
  ProxyPass /knowagecommonjengine/ http://192.168.1.245:8080/knowagecommonjengine/
  ProxyPass /knowagedataminingengine/ http://192.168.1.245:8080/knowagedataminingengine/
  ProxyPass /knowagegeoreportengine/ http://192.168.1.245:8080/knowagegeoreportengine/
  ProxyPass /knowagejasperreportengine/ http://192.168.1.245:8080/knowagejasperreportengine/
  ProxyPass /knowagekpiengine/ http://192.168.1.245:8080/knowagekpiengine/
  ProxyPass /knowagemeta/ http://192.168.1.245:8080/knowagemeta/
  ProxyPass /knowagenetworkengine/ http://192.168.1.245:8080/knowagenetworkengine/
  ProxyPass /knowageqbeengine/ http://192.168.1.245:8080/knowageqbeengine/
  ProxyPass /knowagesvgviewerengine/ http://192.168.1.245:8080/knowagesvgviewerengine/
  ProxyPass /knowagetalendengine/ http://192.168.1.245:8080/knowagetalendengine/
  ProxyPass /knowagewhatifengine/ http://192.168.1.245:8080/knowagewhatifengine/

  ProxyPassReverse /knowage/ http://192.168.1.245:8080/knowage/
  ProxyPassReverse /knowagebirtreportengine/ http://192.168.1.245:8080/knowagebirtreportengine/
  ProxyPassReverse /knowagecockpitengine/ http://192.168.1.245:8080/knowagecockpitengine/
  ProxyPassReverse /knowagecommonjengine/ http://192.168.1.245:8080/knowagecommonjengine/
  ProxyPassReverse /knowagedataminingengine/ http://192.168.1.245:8080/knowagedataminingengine/
  ProxyPassReverse /knowagegeoreportengine/ http://192.168.1.245:8080/knowagegeoreportengine/
  ProxyPassReverse /knowagejasperreportengine/ http://192.168.1.245:8080/knowagejasperreportengine/
  ProxyPassReverse /knowagekpiengine/ http://192.168.1.245:8080/knowagekpiengine/
  ProxyPassReverse /knowagemeta/ http://192.168.1.245:8080/knowagemeta/
  ProxyPassReverse /knowagenetworkengine/ http://192.168.1.245:8080/knowagenetworkengine/
  ProxyPassReverse /knowageqbeengine/ http://192.168.1.245:8080/knowageqbeengine/
  ProxyPassReverse /knowagesvgviewerengine/ http://192.168.1.245:8080/knowagesvgviewerengine/
  ProxyPassReverse /knowagetalendengine/ http://192.168.1.245:8080/knowagetalendengine/
  ProxyPassReverse /knowagewhatifengine/ http://192.168.1.245:8080/knowagewhatifengine/
</VirtualHost>

After save file, restart apache

sudo systemctl restart apache2