I’m posting this just because there seems to be a lot of confusion and misinformation on the web about getting the open source version of Pentaho’s BIServer up and running on Linux. (I know I spent several hours over the course of a week running through them.) The current version is 5.01 and you download a ZIP file that contains almost everything you need to get started.
You do NOT need to install MySQL or PostgreSQL or Oracle on your server to get Pentaho BIServer to work, nor do you need to set the PENTAHO_JAVA_HOME or JAVA_HOME system variables or create a Pentaho user account. If you want to change the repository database to something besides the embedded HSQLDB you can find directions on that on the Internet (Good luck to you). If you just want to setup a simple system for testing and low volume usage, read on…
Here is a step by step account of how I got Pentaho BIServer to run on my system:
- Install a Linux server ( I am using CentOS 64-bit). A minimum of 2GB of RAM is necessary, although 4GB or more is better.
- Remove any unneeded applications and install any system updates.
- Disable iptables and iptablesv6 (be cautious of this if you plan to use this in a production environment!)
- Edit /etc/sysconfig/selinux (RedHat based Linux distros) and set it to disabled. Restart your server for all the config changes to take effect.
- If its present, remove OpenJDK software (java -version will tell you).
- Download Oracle’s JAVA 1.7_55 RPM package from their website and install it.
- All of this above was the difficult part. 🙂
- Download the Pentaho biserver-ce from Pentaho’s website and click the Download Pentaho CE link. You be redirected to a page on SourceForge.net and the file will begin downloading. It takes a while.
- Once the download completes, create a pentaho folder in your home folder and extract the biserver-ce-5.0.1-stable.zip to it.
- At the command line, switch back to your user account if you are still running as root.
- Navigate to your /home/username/pentaho/biserver-ce folder.
- To start the server, enter this command:
- The shell script will produce several lines of output, and then return to a command prompt.
- If you are running a GUI environment on your server, open a browser, and navigate to http://localhost:8080/pentaho. Otherwise open a browser on a machine on the same network and access the IPAddress for your server with the ending notation (:8080/pentaho).
- It may take a few minutes for the webpage to load up, but once it does, you’ll see the Pentaho User Console login screen. Login using the default user account.
User name: admin Password: password
- You’re in!
If you would like to access the server from a different machine, set a static IP address and a fully qualified domain name, but if all of your work will be local, you are all set.