Sebelum mulai, pastikan dulu OS anda terupdate dan install package yang dibutuhkan:

$ sudo apt update
$ sudo apt upgrade
$ sudo apt install unzip

Selanjutnya, install JDK 8 dan setting JAVA_HOME variable environment:

$ sudo apt install default-jre
$sudo vim /etc/environment

# tambahkan entry berikut (sesuaikan dengan JDK anda):
JAVA_HOME="/usr/lib/jvm/java-8-openjdk-amd64"
#reload
$ source /etc/environment
$ echo $JAVA_HOME

Selanjutnya, download Pentaho Server 8.3 CE:

$ wget https://nchc.dl.sourceforge.net/project/pentaho/Pentaho%208.3/server/pentaho-server-ce-8.3.0.0-371.zip
# extract
$ unzip pentaho-server-ce-8.3.0.0-371.zip
$ sudo mkdir /opt/pentaho
$ sudo mv pentaho-server /opt/pentaho

Buat pentaho group dan user:

$ sudo addgroup pentaho
$ sudo adduser --system --ingroup pentaho --disabled-login pentaho
$ sudo chown -R pentaho:pentaho /opt/pentaho

Install PostgreSQL dan update pg_hba.conf:

$ sudo apt-get install postgresql
$ sudo -u postgres psql postgres
$ \password 
$ \q 
$ sudo vim /etc/postgresql/11/main/pg_hba.conf

# cari baris berikut:
# local all all peer
# ganti peer dengan md5

Kemudian restart PostgreSQL server.

$ sudo systemctl restart postgresql

Jalankan SQL Script berikut. Jika anda diminta mengisi password, gunakan ‘password’, kecuali anda memodifikasi default passwordnya:

$ cd /opt/pentaho/pentaho-server/data/postgresql
$ psql -U postgres -h 127.0.0.1 -p 5432 -f create_jcr_postgresql.sql
$ psql -U postgres -h 127.0.0.1 -p 5432 -f create_quartz_postgresql.sql
$ psql -U postgres -h 127.0.0.1 -p 5432 -f create_repository_postgresql.sql

Kemudian sesuaikan konfigurasi koneksi JDBC Pentaho ke database:

$ cd /opt/pentaho/pentaho-server/tomcat/webapps/pentaho/META-INF
$ sudo vim context.xml

<?xml version="1.0" encoding="UTF-8"?>
<Context path="/pentaho" docbase="webapps/pentaho/">
   <Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource" 
     factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" maxActive="20" minIdle="0" 
     maxIdle="5" initialSize="0" maxWait="10000" username="hibuser" password="password" 
     driverClassName="org.postgresql.Driver" 
     url="jdbc:postgresql://127.0.0.1:5432/hibernate" validationQuery="select count(*) FROM INFORMATION_SCHEMA.SYSTEM_SEQUENCES" />
   <Resource name="jdbc/Quartz" auth="Container" type="javax.sql.DataSource" 
     factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" maxActive="20" minIdle="0" 
     maxIdle="5" initialSize="0" maxWait="10000" username="pentaho_user" 
     password="password" driverClassName="org.postgresql.Driver" 
     url="jdbc:postgresql://127.0.0.1:5432/quartz" validationQuery="select count(*) from INFORMATION_SCHEMA.SYSTEM_SEQUENCES" />
</Context>

Jalankan Pentaho Server:

$ cd /opt/pentaho/pentaho-server
$ sudo ./start-pentaho.sh

Buka halaman http://localhost:8080, login dengan menggunakan akun admin dan password password. Segera ganti password jika anda menginstall di production environment.

LEAVE A REPLY

Please enter your comment!
Please enter your name here