Pentaho BI Server 3.6 in CentOS 5.3 64 bit

28 Apr

Pentaho BI Server 3.6 in CentOS 5.3 64 bit

# cat /etc/redhat-release
CentOS release 5.3 (Final)
# uname -a
Linux test41 2.6.18-128.el5 #1 SMP Wed Jan 21 10:41:14 EST 2009 x86_64 x86_64 x86_64 GNU/Linux

0. periksa port apakah dipakai oleh aplikasi lain ?
# netstat -ntlp | grep 8080
# netstat -ntlp | grep 8099

1. create directory
# mkdir -p /usr/java
# cd /usr/java

2. download    jdk-6u25-linux-x64.bin
3. download jre-6u25-linux-x64.bin

4. install jdk-6u16-linux-i586.bin dan jre-6u16-linux-i586.bin
# chmod u+x jdk-6u25-linux-x64.bin
# chmod u+x jre-6u25-linux-x64.bin

# ./jdk-6u25-linux-x64.bin
# ./jre-6u25-linux-x64.bin

5. download & extract pentaho biserver-ce-3.6.0-stable.zip
# mkdir -p /opt/pentaho
# unzip biserver-ce-3.6.0-stable.zip

6. mengubah mode x untuk semua script sh
# cd /opt/pentaho/biserver-ce
# chmod u+x *.sh

# cd /opt/pentaho/administration-console/
# chmod u+x *.sh

# cd /opt/pentaho/biserver-ce/tomcat/bin/
# chmod u+x *.sh

# cd /opt/pentaho/biserver-ce/data
# chmod u+x *.sh

7. copykan driver- driver database dari PDI
# cp  /home/oracle/jdbc/*.* /opt/pentaho/administration-console/jdbc/
# cp  /home/oracle/jdbc/*.* /opt/pentaho/biserver-ce/tomcat/common/lib

8. edit publisher_config.xml untuk bikin password
# vi /opt/pentaho/biserver-ce/pentaho-solutions/system/publisher_config.xml
<publisher-config>
<publisher-password>admin</publisher-password>
</publisher-config>

9. edit context.xml    untuk akses oracle server
# vi /opt/pentaho/biserver-ce/tomcat/webapps/pentaho/META-INF/context.xml
<Resource name=”jdbc/Oracle” auth=”Container” type=”javax.sql.DataSource”
factory=”org.apache.commons.dbcp.BasicDataSourceFactory” maxActive=”20″ maxIdle=”5″ maxWait=”10000″
username=”scott” password=”tiger”
driverClassName=”oracle.jdbc.driver.OracleDriver”
url=”jdbc:oracle:thin:@172.20.33.41:1521:test41″
validationQuery=”select 1 from dual”/>

10. edit web.xml
# vi /opt/pentaho/biserver-ce/tomcat/webapps/pentaho/WEB-INF/web.xml
a. ubah solution-path
dari :
<context-param>
<param-name>solution-path</param-name>
<param-value></param-value>
</context-param>
menjadi :
<context-param>
<param-name>solution-path</param-name>
<param-value>/opt/pentaho/biserver-ce/pentaho-solutions/</param-value>
</context-param>

b. ubah base-url
dari :
<context-param>
<param-name>base-url</param-name>
<param-value>http://localhost:8080/pentaho/</param-value&gt;
</context-param>
menjadi :
<context-param>
<param-name>base-url</param-name>
<param-value>http://172.20.33.41:8080/pentaho/</param-value&gt;
</context-param>

11. edit console.xml
# vi /opt/pentaho/administration-console/resource/config/console.xml
dari :
<?xml version=”1.0″ encoding=”UTF-8″?>
<console>
<solution-path></solution-path>
<war-path></war-path>
<platform-username>joe</platform-username>
<biserver-status-check-period-millis>30000</biserver-status-check-period-millis>
<homepage-url>http://www.pentaho.com/console_home</homepage-url&gt;
<homepage-timeout-millis>15000</homepage-timeout-millis>
<!– comma separated list of roles (no spaces) –>
<default-roles>Authenticated</default-roles>
<default-server-dir>biserver-ce</default-server-dir>
</console>
menjadi :
<?xml version=”1.0″ encoding=”UTF-8″?>
<console>
<solution-path>/opt/pentaho/biserver-ce/pentaho-solutions</solution-path>
<war-path>/opt/pentaho/biserver-ce/tomcat/webapps/pentaho</war-path>
<platform-username>joe</platform-username>
<biserver-status-check-period-millis>30000</biserver-status-check-period-millis>
<homepage-url>http://www.pentaho.com/console_home</homepage-url&gt;
<homepage-timeout-millis>15000</homepage-timeout-millis>
<!– comma separated list of roles (no spaces) –>
<default-roles>Authenticated</default-roles>
<default-server-dir>biserver-ce</default-server-dir>
</console>

12. edit script start-pentaho, tambahkan
# vi /opt/pentaho/biserver-ce/start-pentaho.sh
export CATALINA_OPTS=”….. -Djava.awt.headless=true”

13. create script service
# vi /etc/init.d/pentaho
export JAVA_HOME=”/usr/java/jdk1.6.0_25″
export JRE_HOME=”/usr/java/jre1.6.0_25″

case “$1” in
‘start’)
cd /opt/pentaho/biserver-ce
/opt/pentaho/biserver-ce/start-pentaho.sh &

cd /opt/pentaho/administration-console
/opt/pentaho/administration-console/start-pac.sh &
;;

‘stop’)
cd /opt/pentaho/biserver-ce
/opt/pentaho/biserver-ce/stop-pentaho.sh &

cd /opt/pentaho/administration-console
/opt/pentaho/administration-console/stop-pac.sh &
;;

*)
echo “Usage: $0 { start | stop }”
;; esac

export PATH=$PATH:$JAVA_HOME/bin/java
exit 0

# chmod +x /etc/init.d/pentaho
# chkconfig –add pentaho
# chkconfig pentaho on
# service pentaho start

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: