How to start Pentaho server at boot time on Linux server

Hi Friends,

In this post, I would like to give you details on how we start pentaho server at boot time on linux server.

Generally we have two scripts available under below path:

                            installation_directory/pentaho/server/biserver-ee  

start-pentaho.sh & stop-pentaho.sh

How ever we also can start pentaho server through another script called ctlscript.sh which is available in the below path:

                                     installation_directory/pentaho

Now we will see how to start pentaho server at boot time.
STEP1:
Login as a root user and create a init script in the path:  /etc/rc.d/init.d  and give any name to it. In my case I have assigned a name to init script as "pentaho"

STEP2:
Include the below code in the created file to start the server at boot time and to stop the server at OS shut down time.


#!/bin/sh
### BEGIN INIT INFO
# Provides: start-pentaho stop-pentaho
# Required-Start: networking postgresql
# Required-Stop: postgresql
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Description: Pentaho BA Server
### END INIT INFO

case "$1" in
"start")
su - root -c "cd /opt/Pentaho/ && ./ctlscript.sh start"
#su - pentaho -c "cd /home/pentaho/pentaho/server/enterprise-console && ./start-pec.sh"
;;
"stop")
su - root -c "cd /opt/Pentaho/ && ./ctlscript.sh stop"
#su - pentaho -c "cd /home/pentaho/pentaho/server/enterprise-console && ./stop-pec.sh"
;;
*)
echo "Usage: $0 { start | stop }"
;;
esac
exit 0

STEP3:
Now save this file and give execution permission by executing the below command.
                     
                                           #chmod +x pentaho
where pentaho is name of the init script.

STEP4:
Now to add init script to default run levels, we have to execute below commands.

chkconfig -add pentaho    --  This command to add our files

NOTE: chkconfig  -  updates  and queries runlevel information for system ser-
       vices

after adding the init script we have set the script to run levels.

 syntax:  chkconfig [--level levels] name <on|off|reset>

chkconfig --level 35 pentaho on     --- This command will set the init script to run at boot time 

Thanks

How to install Pentaho on Linux server

Hi Friends, it is quite easy to install Pentaho on Linux server, before you proceed with downloading of pentaho from Pentaho Corporation. find out your OS type is of 32bit or 64bit.

for this try to execute the below command:

                                                  #uname -a

This command will display the details about your machine and then download the related bin file.
after once you get the installer file go to the folder location where it has downloaded.

Most probably it will be in Downloads Folder, So please navigate to that folder. and try running the installer file by using below syntax.

                   

                     Download#./pentaho-business-analytics-XXX-x64.bin

During installation it will prompts for password details and folder location where to install and proceed with agreement acceptance.

After successful installation, Console page will open for the first time and please log in as  Evaluator.

Refer the below image to get know about details:

How to disable Firewall in Linux server - Pentaho Server access problem

Hi Folks,

If you are facing any issue with accessing of any application that resides on Linux server, Please try to disable firewall and try to reload the page. try to execute the below command.  I have installed pentaho on linux machine and while accessing the Pentaho console remotely I could not able to connect So I just disabled firewall by using the below command.  Hope it will be helpful for you.


                                                   #iptables -F

iptable command: administration tool for IPv4/IPv6 packet filtering and NAT
And try to access the application now.


We use the command      "iptables"   to resolve these kind of issue, before you go directly to disable firewall on linux server better you try to know available options by executing the command

                                             #iptables -help

How to access/list/display files in USB/Flash memory through command prompt in Linux

Hi All, In this section I will be explaining how to access files that are available in USB/pen-drive through UNIX/LINUX command prompt.

First of all login as a root user.

STEP1:
We have to create a mount point, for this execute the below command
                         #mkdir -p /mnt/pen
STEP2:
Now we should mount the disk, for that run the mount command.
                        #mount /dev/sda1  /mnt/pen

This command will mount files to the targeted location.

After that use regular commands to list /mnt/pen

                                       #ls /mnt/pen

Data warehousing Concepts - Slowly changing Dimensions

Hi all,
Here in this section, I will be going to give you a brief explanation on Slowly changing dimension.

Introduction:

As the name represents it, When a dimension changes over time we call it as  a Slowly changing dimension.  We can handle this type of situation in 3 types. these are

SCD type 1
SCD type 2
SCD type 3

Say for example consider the below example.



Customer-id   Customer-name         Address
      12              Kullayappa           Kuala Lampur


Now after some months the customer's adress has been changed to Singapore. and now the data looks like below.

Customer-id   Customer-name         Address
      12              Kullayappa             Singapore

SCD Type 1: 
How SCD type1 approach deals now is, remove the historical data that has been presented and have the updated data only. In this case we could not able to track the historical data.

Example:

Customer-id   Customer-name         Address
      12              Kullayappa             Singapore

SCD Type 2:
SCD type 2 prefers to add a another record for new entry and identify those new records on version.

Example:
Customer-id   Customer-name         Address                 Version
        12              Kullayappa             Kuala Lampur           0
        12              Kullayappa             Singapore                  1

SCD Type 3:
SCD type 3 suggest to add one more column for the new record instead of adding extra record.

Example:

Customer-id   Customer-name         Previous_Address      Current_Address
        12              Kullayappa             Kuala Lampur               Singapore




Folks, I have typed on my own and excuse for my typo errors , I am providing details as per my knowledge.

How to install pentaho on Linux server - Pre-requisites

Hi All,

In this section, I will be explaining how to install Pentaho on linux server. For this please find the Pre-requisites to be present on your machine.

1.Java should be there on you machine, if not please install the java.
2.Identify the version of your machine and try to download the pentaho files from pentaho corporation.