Hi guys,
In this post you'll learn about the installation pentaho BI CE server 5.0.1 in ubuntu server and then C-Tools(CDE,CDA,CDF,Saiku Analytics) installation
PART-I : Open JDK installation
PART-II : Pentaho 5.0.1 CE installation
PART-III : C-Tools,Saiku Analytics installation
Pr-requisites
1)Ubuntu Server
Find OS: lsb_release -a
Outupt :
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 12.04.3 LTS
Release: 12.04
Codename: precise
2) Windows 7 64 bit -PuTTY
Login to the PuTTY using given username and password
Username would be : IP address ( for eg :71.221.143.168)
Password would be : Password (for eg : adminsadakar)
3) Mozilla firefox(Preferrable for pentaho)
Version 25.0.1
If you have given .pem file convert it into .ppk file and add this file.
You need to install java and set JAVA_HOME for before you install pentaho server.
Installation of JAVA(Open JDK) in ubntu server
NOTE : You must issue sudo(Superuser do) permission before you ready to install java
Command : sudo su
In the next line : You need to issue the password that you used for log-ing using PuTTY.
* Install Open JDK and JRE using the below commands
1) JRE installation command
apt-get install openjdk-7-jre
2) JDK installation comman
3) Find whether java installed or not
which java
Ouptut
/usr/bin/java
4) Find which version installed
java -version
Ouput
java version "1.7.0_25"
OpenJDK Runtime Environment (IcedTea 2.3.10) (7u25-2.3.10-1ubuntu0.12.04.2)
OpenJDK 64-Bit Server VM (build 23.7-b01, mixed mode)
IMP: NOTE-1
You need NOT to set JAVA_HOME if you see the above message(when you issue java -version) for ubntu server, at the time of java installation it will set the JAVA_HOME.
This may differ from version to version for ubntu server.
NOTE-2
By default the open JDK install in the below location
/usr/lib/jvm/
NOTE-3 ( Optional - set java_home)
References:
1) http://blog.manishchhabra.com/2012/05/installing-oracle-sun-java-jdk-and-setting-java_home-in-ubuntu-linux/
2) http://askubuntu.com/questions/321422/how-to-setup-java-home-and-path-in-ubuntu-12-04
Open .bashrc file using an editor. If you use VI then
vi ~/.bashrc
and add the following 2 lines in your .bashrc file.
JAVA_HOME=/usr/lib/jvm/jdk1.7.0_21/
export JAVA_HOME
mkdir pentaho
2) Issue the below command to down load pentaho zip file from sourceforgesite
wget http://sourceforge.net/projects/pentaho/files/Business Intelligence Server/5.0.1-stable/biserver-ce-5.0.1-stable.zip/
3) Unzip the file
i) Once the down load is completed you will be getting "biserver-ce-5.0.1-stable.zip" zip file under pentaho
ii) unzip the file using below command
unzip biserver-ce-5.0.1-stable.zip
NOTE: if unzip is not installed in ubuntu server issue the below command to install unzip package
i) Once unzip completed you will be getting a folder biserver-ce
ii) Do the follwoing
root@SADA-KAR-167:/home/pentaho# cd biserver-ce
root@SADA-KAR-167:/home/pentaho/biserver-ce# ls
OUTPUT
data import-export.sh pentaho-solutions set-pentaho-env.bat start-pentaho.bat start-pentaho-debug.sh stop-pentaho.bat third-party-tools
import-export.bat licenses promptuser.js set-pentaho-env.sh start-pentaho-debug.bat start-pentaho.sh stop-pentaho.sh tomcat
NOTE : You need to give the permissions to the .sh files to run
Issue below command : chmod -R 777
For full information of chmod refer here :
5) Start the bi server using below command
root@SADA-KAR-167:/home/pentaho/biserver-ce# ./start-pentaho.sh
OUTPUT
/home/pentaho/biserver-ce
/home/pentaho/biserver-ce
WARNING: Using java from path
DEBUG: _PENTAHO_JAVA_HOME=
DEBUG: _PENTAHO_JAVA=java
Using CATALINA_BASE: /home/pentaho/biserver-ce/tomcat
Using CATALINA_HOME: /home/pentaho/biserver-ce/tomcat
Using CATALINA_TMPDIR: /home/pentaho/biserver-ce/tomcat/temp
Using JRE_HOME: /usr
Using CLASSPATH: /home/pentaho/biserver-ce/tomcat/bin/bootstrap.jar
NOTE: stop the server by issuing this command
root@SADA-KAR-167:/home/pentaho/biserver-ce# ./stop-pentaho.sh
/home/pentaho/biserver-ce
/home/pentaho/biserver-ce
WARNING: Using java from path
DEBUG: _PENTAHO_JAVA_HOME=
DEBUG: _PENTAHO_JAVA=java
Using CATALINA_BASE: /home/pentaho/biserver-ce/tomcat
Using CATALINA_HOME: /home/pentaho/biserver-ce/tomcat
Using CATALINA_TMPDIR: /home/pentaho/biserver-ce/tomcat/temp
Using JRE_HOME: /usr
Using CLASSPATH: /home/pentaho/biserver-ce/tomcat/bin/bootstrap.jar
6) Go the web-browser and give the below URL
http://YourHost:8080/pentaho
Example : 71.221.143.168:8080/pentaho
NOTE: pentaho by default uses 8080 port number.
Credentials you need to supply once you get the home page are :
User name : Admin
Password : password
References :
JAVA installation : http://openjdk.java.net/install/
Pentaho installaton : http://community.pentaho.com/
Thank you for reading this post.
If you have any queries drop your comments in comments box.
In this post you'll learn about the installation pentaho BI CE server 5.0.1 in ubuntu server and then C-Tools(CDE,CDA,CDF,Saiku Analytics) installation
PART-I : Open JDK installation
PART-II : Pentaho 5.0.1 CE installation
PART-III : C-Tools,Saiku Analytics installation
Pr-requisites
1)Ubuntu Server
Find OS: lsb_release -a
Outupt :
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 12.04.3 LTS
Release: 12.04
Codename: precise
2) Windows 7 64 bit -PuTTY
Login to the PuTTY using given username and password
Username would be : IP address ( for eg :71.221.143.168)
Password would be : Password (for eg : adminsadakar)
3) Mozilla firefox(Preferrable for pentaho)
Version 25.0.1
If you have given .pem file convert it into .ppk file and add this file.
You need to install java and set JAVA_HOME for before you install pentaho server.
PART- I JAVA (Open - JDK)- Installation
Installation of JAVA(Open JDK) in ubntu server
NOTE : You must issue sudo(Superuser do) permission before you ready to install java
Command : sudo su
In the next line : You need to issue the password that you used for log-ing using PuTTY.
* Install Open JDK and JRE using the below commands
1) JRE installation command
apt-get install openjdk-7-jre
2) JDK installation comman
apt-get install
openjdk-7-jdk3) Find whether java installed or not
which java
Ouptut
/usr/bin/java
4) Find which version installed
java -version
Ouput
java version "1.7.0_25"
OpenJDK Runtime Environment (IcedTea 2.3.10) (7u25-2.3.10-1ubuntu0.12.04.2)
OpenJDK 64-Bit Server VM (build 23.7-b01, mixed mode)
IMP: NOTE-1
You need NOT to set JAVA_HOME if you see the above message(when you issue java -version) for ubntu server, at the time of java installation it will set the JAVA_HOME.
This may differ from version to version for ubntu server.
NOTE-2
By default the open JDK install in the below location
/usr/lib/jvm/
NOTE-3 ( Optional - set java_home)
References:
1) http://blog.manishchhabra.com/2012/05/installing-oracle-sun-java-jdk-and-setting-java_home-in-ubuntu-linux/
2) http://askubuntu.com/questions/321422/how-to-setup-java-home-and-path-in-ubuntu-12-04
Open .bashrc file using an editor. If you use VI then
vi ~/.bashrc
and add the following 2 lines in your .bashrc file.
JAVA_HOME=/usr/lib/jvm/jdk1.7.0_21/
export JAVA_HOME
PART- II Pentaho 5.0.1 CE installation
1) Create a folder under homemkdir pentaho
2) Issue the below command to down load pentaho zip file from sourceforgesite
wget http://sourceforge.net/projects/pentaho/files/Business Intelligence Server/5.0.1-stable/biserver-ce-5.0.1-stable.zip/
3) Unzip the file
i) Once the down load is completed you will be getting "biserver-ce-5.0.1-stable.zip" zip file under pentaho
ii) unzip the file using below command
unzip biserver-ce-5.0.1-stable.zip
NOTE: if unzip is not installed in ubuntu server issue the below command to install unzip package
sudo apt-get install unzip4) biserver-ce folder
i) Once unzip completed you will be getting a folder biserver-ce
ii) Do the follwoing
root@SADA-KAR-167:/home/pentaho# cd biserver-ce
root@SADA-KAR-167:/home/pentaho/biserver-ce# ls
OUTPUT
data import-export.sh pentaho-solutions set-pentaho-env.bat start-pentaho.bat start-pentaho-debug.sh stop-pentaho.bat third-party-tools
import-export.bat licenses promptuser.js set-pentaho-env.sh start-pentaho-debug.bat start-pentaho.sh stop-pentaho.sh tomcat
NOTE : You need to give the permissions to the .sh files to run
Issue below command : chmod -R 777
For full information of chmod refer here :
5) Start the bi server using below command
root@SADA-KAR-167:/home/pentaho/biserver-ce# ./start-pentaho.sh
OUTPUT
/home/pentaho/biserver-ce
/home/pentaho/biserver-ce
WARNING: Using java from path
DEBUG: _PENTAHO_JAVA_HOME=
DEBUG: _PENTAHO_JAVA=java
Using CATALINA_BASE: /home/pentaho/biserver-ce/tomcat
Using CATALINA_HOME: /home/pentaho/biserver-ce/tomcat
Using CATALINA_TMPDIR: /home/pentaho/biserver-ce/tomcat/temp
Using JRE_HOME: /usr
Using CLASSPATH: /home/pentaho/biserver-ce/tomcat/bin/bootstrap.jar
NOTE: stop the server by issuing this command
root@SADA-KAR-167:/home/pentaho/biserver-ce# ./stop-pentaho.sh
root@ONE-DMZ-SRV161:/home/pentaho/biserver-ce# ./stop-pentaho.sh/home/pentaho/biserver-ce
/home/pentaho/biserver-ce
WARNING: Using java from path
DEBUG: _PENTAHO_JAVA_HOME=
DEBUG: _PENTAHO_JAVA=java
Using CATALINA_BASE: /home/pentaho/biserver-ce/tomcat
Using CATALINA_HOME: /home/pentaho/biserver-ce/tomcat
Using CATALINA_TMPDIR: /home/pentaho/biserver-ce/tomcat/temp
Using JRE_HOME: /usr
Using CLASSPATH: /home/pentaho/biserver-ce/tomcat/bin/bootstrap.jar
6) Go the web-browser and give the below URL
http://YourHost:8080/pentaho
Example : 71.221.143.168:8080/pentaho
NOTE: pentaho by default uses 8080 port number.
Credentials you need to supply once you get the home page are :
User name : Admin
Password : password
PART- III C-Tools(CDE, CDF & CDA) & Saiku Analytics installation.
1) Go to the Market place ( HOME--> MarketPlace)
2) Install CDF first( by default it installs with pentaho installation - if you have any latest version in the detail list upgrade to new one).
3) Click on Install to install CDA with the latest version.
Version
TRUNK-SNAPSHOT
4) Click on Install to install CDE with the latest version.
Version
TRUNK-SNAPSHOT
5) Click on Install for Saiku installaiton
Version
2.6-PENTAHO5-SNAPSHOT
NOTE : CDF, CDA are two dependencies you must install before installing CDE.
6) Once you install the required tools from Market place you must restart the petnaho server other wise you can not find the installation of tools.
Stop server:
root@SADA-KAR-167:/home/pentaho/biserver-ce# ./stop-pentaho.sh
Start server:
root@SADA-KAR-167:/home/pentaho/biserver-ce# ./start-pentaho.sh
JAVA installation : http://openjdk.java.net/install/
Pentaho installaton : http://community.pentaho.com/
Thank you for reading this post.
If you have any queries drop your comments in comments box.
No comments:
Post a Comment