Install Pentaho BI Server 4.5 on Ubuntu 12.04 LTS Desktop

Overview: What is Pentaho?

Pentaho is an open source Business Intelligence (BI) Suite that comes in with either commercial support (http://www.pentaho.com/) and or community support (http://community.pentaho.com/).

This post provides instructions for the Pentaho community edition suite.

Create a pentaho user and group

Open a terminal and run the following commands:

sudo addgroup pentaho
sudo adduser --system --ingroup pentaho --disabled-login pentaho

Install Java

Follow the JDK installation instructions that are listed in the following post: Install Java JDK 6.0 update 31 on Ubuntu 12.04 LTS

Install the Pentaho BI Server

Now that we have Java installed we can get on with our main task of installing the Pentaho BI Server.

  1. Download the Pentaho BI Server from http://wiki.pentaho.com/display/COM/Latest+Stable+Builds. I’m using the current stable build for x64 Linux which is biserver-ce-4.5.0-stable.tar.gz.
  2. Open a terminal and enter the following commands:
sudo mkdir /opt/pentaho
cd ~/Downloads
gunzip biserver-ce-4.5.0-stable.tar.gz
tar xf biserver-ce-4.5.0-stable.tar
sudo mv biserver-ce /opt/pentaho/biserver-ce-4.5.0
sudo mv administration-console /opt/pentaho/administration-console-ce-4.5.0
cd /opt/pentaho
sudo ln -s biserver-ce-4.5.0 biserver-ce
sudo ln -s administration-console-ce-4.5.0 administration-console
sudo chown -R pentaho:pentaho /opt/pentaho

Start the Pentaho Server

Open a terminal, then enter the following commands:

Note:
The following command is only required if you downloaded a Windows .zip file by accident. If this is the case, then none of the .sh files will be executable.
sudo find /opt/pentaho/ -type f -name '*.sh' -exec chmod 744 '{}' \+

cd /opt/pentaho/biserver-ce
sudo -u pentaho ./start-pentaho.sh

Login to the Pentaho User Console

  1. Open a web browser to http://localhost:8080.
  2. Click Evaluation Login and select a user type to login as.

Login to the Pentaho Administration Console

Open a terminal, then enter the following commands:

cd /opt/pentaho/administration-console
sudo -u pentaho ./start-pac.sh
  1. Open a web browser to http://localhost:8099.
  2. Enter a User Name of admin.
  3. Enter a Password of password.
  4. Click Log In.

That’s it. The core Pentaho BI server is installed and ready for development. However, a good next step is to change the database that Pentaho uses and install the Pentaho Design Studio (PDS), but we’ll leave that for future posts.

Hadoop also port 8080, so you will either need to use a different port for the Pentaho User Console or change the Hadoop MapReduce ShuffleHandler port.

Advertisements

17 Comments

    1. Thanks for the complement. The layout took trial and error, plus listening to feedback from readers.

      I’ve had a blog for a long time, but only recently started to post more frequently.

      Reply

  1. admin page was accepting admin/password then I added server-administrator,content-administrator, at end of the line in the file, which solved my issue. I am posting it here, if some one also facing same issue.

    /pentaho/server/enterprise-console/resource/config/login.properties

    Reply

  2. First of all thank you very much for this amazing tutorial. Very well written, and so easy to follow, that’s really well done.

    Please allow me one question.

    I followed your tutorial to the letter (except I installed version 4.8), my OS is Ubuntu 13.04.

    Everything worked well, I was able to log into the administration console and create a new admin user. Then I logged into the user console and went to the market place. I started to install some of the offered extensions. After each and every one, I logged out, restarted the server, logged in again and installed the next one.

    After I installed “Data Browser”, I also logged out, restarted the server and tried to log in again. Unfortunately, something broke and I can’t log in anymore, instead I get the following error message:
    *********************************************************************
    HTTP Status 404 –
    type Status report
    message
    description The requested resource () is not available.
    Apache Tomcat/6.0.29
    *********************************************************************

    Also, in the administration console, the server status shows now disconnected.

    Would you have an idea where I could start trouble shooting?

    Thank you very much!!

    Reply

  3. This was a great tutorial, thanks. I followed this in ubuntu 13.04 like the person above, however I hit a speed bump earlier than he did. I cannot access localhost:8080 for some reason. The page never loads and I eventually get a connection timeout. Any ideas about what to do?

    Reply

  4. i have a problem with the administration-console, i had follow this guide and when i log with admin-password show:
    Unable to refresh security information: Unable to refresh hibernate
    Unable to refresh database connection list: Unable to refresh hibernate

    some way to solve this?

    Reply

  5. admin / password is not working for us with an installation of 4.5.0. resource/config/login.properties has a single line.

    admin: some hash,admin

    Is there a way to manually hash a new password and set it up?

    Reply

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