Pentaho Configuration in Linux

Pentaho Configuration in Public Server IP

Step 1:

Install Mysql Server on the system

Start Mysql Server using 
[root@localhost ~]# service mysqld start

Before importing sql file you need to create database in mysql server.

for example:  
create database adventureworks;

Then import sql file using this command,

[root@localhost ~]# mysql -u root -p  database-name < ~/ url / sql file

for example:[root@localhost ~]# mysql -u root -p  adventureworks2012 < ~/Desktop/ adventureworks.sql

Get adventureworks2012.sql file from 172.16.12.10/March/Users/Anandh/Pentaho

Step 2:

Open pentaho → biserver-ce →tomcat →webapps and copy java war file named as PentahoSampleApp.war from 172.16.12.10/March/Users/Anandh/Pentaho after copying a file refresh to see the folder with the name of “PentahoSampleApp”.

Step 3:

Start Pentaho Business Intelligence server using terminal

1. In system terminal use su – for root user

[root@localhost ~]# su -

2. Navigate to that folder

[root@localhost ~]# cd /usr/local/pentaho/biserver-ce

3. To list files in present on that folder use ls command

[root@localhost biserver-ce]# ls

4. To start pentaho server use below command

[root@localhost biserver-ce]# sh start-up.sh

DEBUG: Using JAVA_HOME

DEBUG: _PENTAHO_JAVA_HOME=/usr/local/java/jdk1.7.0_80

DEBUG: _PENTAHO_JAVA=/usr/local/java/jdk1.7.0_80/bin/java

Using CATALINA_BASE: /usr/pentaho/biserver-ce/tomcat

Using CATALINA_HOME: /usr/pentaho/biserver-ce/tomcat

Using CATALINA_TMPDIR: /usr/pentaho/biserver-ce/tomcat/temp

Using JRE_HOME: /usr/local/java/jdk1.7.0_80

Using CLASSPATH: /usr/pentaho/biserver-ce/tomcat/bin/bootstrap.jar

5. Pentaho server is started.

After pentaho server is started. Goto browser and using this URL http://localhost:8080/pentaho you can reach pentaho login screen.

Username: Admin

Password: password

Browse Files → Home →admin →Upload ( under Folder Actions) and browse to select zip file.

Step 4:

Goto browser and using this URL http://localhost/PentahoSampleApp and you can reach pentaho HelloWorld.jsp page. Click on Mysql Dashboard menu to see the sample dashboard.