Pentaho in a Virtual Machine

We have prepared virtual servers with a preconfigured installation of Pentaho, the well-known open source platform for Business Intelligence (BI Pentaho PCI).
You can freely download a virtual machine ready with the virtualization software VirtualBox 2.0 Sun, and another with VM 2.0 server software:

Download Image Virtual Pentaho Downloading virtual machine for Virtual Box
Download Image Virtual Pentaho Downloading virtual machine for VMware
(Patience with the download, the files are very large)

 

The Pentaho Installation

This is an installation of Pentaho BI Suite PCI, with Pentaho preconfigured with version 1.7 GA (stable) from the suite, and with a database Hypersonic (HSQLDB) operational, with test data to run reports and 'applications' you have at the portal of example available when the server starts.

You can use this facility to test the platform on your own machine / server exploring the options of the portal, or even as a base to build you own BI system with Pentaho.

You just have to create a new virtual machine with virtualization software and make it boot from the downloaded files.
Enter to the system with the user dataprix, password dataprix.

On boot the machine raise the BI server automatically, so all we have to do is to open Firefox, which have Pentaho local portal as home page. Portal users already have the password entered, so with only two clicks we can begin to explore the reports.

Pentaho running on CentOS on VirtualBox

However, we indicate how to stop and start the server in case anyone wants to do it manually:

To start:

  1. Double-click the desktop icon Terminal
  2. In the terminal window run the following commands:
    $ dd pentaho-demo (the demo directory)
    $ ./start-pentaho.sh (shell to boot the platform)
  3. Wait for the terminal message Pentaho BI server ready
  4. Open Firefox browser (icon next to menu system)
    Url to access the portal is http://localhost:8080/pentaho

To stop Pentaho server, opening another terminal:

$ cd pentaho-demo
$ ./stop-pentaho.sh 

 

Virtualization Tools

VirtualBox

Virtual Box is available for Linux, OS X (Mac) and Windows, and has a free edition of evaluation and personal use, and another Open Source subject to the terms of the GPL. In this way our image may be used freely in any environment, provided to licence conditions.

It is easy to install, and its operation is very intuitive, but I attach the user manual for anyone who don't know the tool, or want to use advanced options.
In order to use our virtual server you can follow these steps:

  1. Install VirtualBox
  2. Download the virtual disk from Download Image Virtual PentahoPentaho VirtualBox virtual image
  3. Unzip it in the directory of VirtualBox virtual disks, usually called VDI
  4. Run VirtualBox and create a new machine with the wizard, choosing the type of Operating System Red Hat, 512 MB of memory (this is a suggestion), and downloaded as a virtual disk bootable disk.
  5. Booting the machine by double-clicking on it.

Thanks to Oscar Osta for preparing the virtual image with CentOS.

VMware

Surely is the most widely used virtualization software, and also have versions that can be used freely, though not for all operating systems. Because there are several products that enable working with our VMWare virtual machine (VMware Player, VMware Server, VMware Infrastructure ..), refer to the website of WMware to download any of them or read the documentation.

However, with most of these products the steps are very similar:

  1. Installing a product that allows to boot VMWare virtual machines
  2. Download the virtual machine from Download Image Virtual Pentaho VMware virtual image Pentaho
  3. Unzip into the VMware virtual disk .., normally My virtual machines, in the user document folder.
  4. Run VMware.. and add a new machine to the inventory of downloaded files by selecting the .vmx extension.
  5. Boot the machine by double-clicking on it.

 

The Operating System

CentOS 5 is the Operating System we have choose as a base for the installation of Pentaho. The reasons have to do with the use can be given to this image. This OS is based on the Open Source Code used by Red Hat Enterprise Linux and for practical purposes, works the same way that this Enterprise version of Linux, and is also geared to corporate use, but it's totally under free distribution. It coul'd be used even in a production environment, and most of the RedHat documentation and practices are applicable to CentOS.

We have created the user dataprix. The password for this user and also for root user is dataprix.

CentOS installed on VirtualBox

 

This is the most basic installation of Pentaho, which is configured to operate in localhost and with an Hypersonic database, perfect for evaluating the potential of this Open Source Business Intelligence Software, or for a simple first contact without complications. It also serves as a basis for preparing more complex things, and I hope in future be able to expand this virtual machine with new features, configurations, testing or interesting demos.

If someone uses this image as a basis for doing something interesting, we appreciate if you tell us, or contact us if you want we host your 'release'. Any comments, questions, ideas or suggestions are welcome in our forum on the topic Virtual Image with Pentaho.

AttachmentSize
VirtualBoxUserManual.pdf4.41 MB
 

Admin console password

What's the password for administration console? I tried the default pentaho's admin/password but it didn't work. Thanks.

Try with user Joe

The admin user provided by Pentaho is Joe, select it in the Login page and you will have access to administration options

WOrks only on User Console

 Thanks for the answer, but user Joe seems working only on User Console, on Admin console, at http://localhost:8099/admin, a web login is required to gain access, otherwise you get a 401 error.

The password is not the problem

I've found a thread at Pentaho forums about the same problem, but with version 2.0. A user get also a 401 error when tries to login on Admin Console, and in the terminal gets a warning about Property File. His real problem is with java versions, and he finally fix the problem adding the correct path to $PATH

I've started Admin Console on my virtual server with Pentaho BI 2.0 and when I try to login get the same warning: No property file found.
If I type
>java -version
I get
>java version "1.4.2"
And I installed version "1.5.0" before installing Pentaho BI!

The problem is that I added the java 1.5.0 path at the end of $PATH variable and hadn't removed 1.4.2 path. I've fix it adding the path at the begining and it works!

  • I start Admin Console:
    >cd /home/dataprix/biserver-ce/administration-console
    >. ./start.sh 
  • Open a new Firefox tab with http://localhost:8099
  • Login with admin/password and..

Consola de Administracion de Pentaho

I hope to find enough time to upload new virtual machine versions with the correct PATH defined. Meanwhile try to correct it in your virtual machine and tell us if it works. 

how do we fix the path?

 So this is a confirmed problem in the virtual machine image but what are the steps to fix it?

Nice to know that the java path is incorrect but would be great if you're post actually included the step to fix it.

 

little help?

 

Aaron.

 

 I fixed this by renaming an

 I fixed this by renaming an old java binary file in /usr/bin using command mv /usr/bin/java /usr/bin/javaold

I can login to the admin console now, not sure if it breaks/fixes anything else.

hope this helps somebody

 

Aaron

Fixing PATH variable

I had set JAVA environment variables at /etc/profile. Then, to fix the 'bug' you can edit this file from a terminal session:

> su -
Password: (type dataprix)
> vi /etc/profile
Edit and change PATH="$PATH:/usr/local/jdk/bin"
for PATH="/usr/local/jdk/bin:$PATH"

I hope this help you

I have the same problem. I

I have the same problem. I have done what you suggested, but still can't get into the admin console.

I hope you can help me.
 
Thank's.

I've solved the problem

Remember to check the JAVA version and start the console with root user.

But if you continue having problems, finally I've modified the virtual image but with version 2.0 and you can download the corrected version here, or with the original link.

The console start with the virtual machine, after downloading you only have to start and type http://localhost:8099 in the browser and enter the default Pentaho user/pasword: admin/password

Sorry for the delay and I hope this version works better

A link to a collection of tutorials and videos on MySQL.

 A link to a collection of tutorials and videos on MySQL.

Tutorials:

http://www.dataminingtools.net/browsetutorials.php?tag=mys

videos:

 

A link to a collection of videos on Pentaho.