วันเสาร์ที่ 6 เมษายน พ.ศ. 2562

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

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
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

?
1
2
3
4
5
6
7
8
9
10
11
12
13
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

?
1
2
3
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
?
1
2
3
4
5
6
7
8
9
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
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
# 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
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
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
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
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
?
1
sudo systemctl restart apache2
on
ป้ายกำกับ: , , ,

ไม่มีความคิดเห็น:

แสดงความคิดเห็น

สมัครสมาชิก: ส่งความคิดเห็น (Atom)