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.
- 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.
- 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
- Open a web browser to http://localhost:8080.
- 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
- Open a web browser to http://localhost:8099.
- Enter a User Name of admin.
- Enter a Password of password.
- 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.
AkbarAhmed.com 
Wow, superb blog layout! How long have you been blogging for?
you make blogging look easy. The overall look of your website is fantastic, let alone the content!
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.
How do i set Pentaho Server and Pentaho Administration Console at start up?
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
this is fix for the case when admin page do not accept admin/password
why we have to create pentaho group and user? because, i don’t have rights to create them
You do not have to create a separate user/group for a development server, although it’s recommended for a production system.
Thanks For Quick Reply, and any Blog for Installing Pentaho Community Tools? and working with them?
Cool Tutorial. It is very usefull.
Thank you!!!
This is a great tuturial, very easy and clean.
Thank you!!
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!!
Reblogged this on Java Reblog.
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?
Thank you very much for this!
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?
This happen when you have another tomcat server running on the same machine. Disabled it and everything works fine
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?