1. Download the latest version from Pentaho Community Web Site
2. Extract it (e.g., ”/opt”)
3. Grant execution rights to the BI folder and substructure

    chmod u+x bi-folder -R

4. Make sure your JAVA_HOME variable is set properly and add it to your path by

    echo $JAVA_HOME
    export JAVA_HOME=/path/to/my/java/lib (e.g., /usr/lib/jvm/java-6-sun) 
    export PATH=$PATH:$JAVA_HOME

   Alternatively you can set your variables in .bashrc.

5. Add BI paths (admin console & BI server) to your system PATH to be executable from everywhere
6. Now you can start BI by executing start-pac.sh (only works if started within the admin-console folder) for the admin console and start-pentaho.sh for the BI server.

1. Copy your data base JDBC driver into the BI folders, e.g.:

    /opt/biserver-ce-3.7.0-stable/administration-console/jdbc
    /opt/biserver-ce-3.7.0-stable/biserver-ce/tomcat/lib

2. Optional you can migrate the sample repository into your DB. See the README.txt in biserver-ce/data/ in your BI folder.
3. After starting the Administrator Console you can easily add a new data connection
   • Insert connection name
   • Select appropriate driver class
   • Insert DB user name & password
   • Define URL according to following syntax:

     jdbc:[DB-Type(e.g.mysql, postgresql)]://[host][,failoverhost...][:port]/[database] 
      # e.g.: jdbc:postgresql://localhost:5432/mydb

We found a way – thanks to several posts of the VMware Community – which we want to preserve here:

1. Set up a new virtual machine using the Windows Vista (32 or 64 bit) template (some believe only the XP template works).
2. After complete installation, Windows 7 hangs up while booting
3. Power down the VM and turn off the network adapter
4. Boot again and do an advanced install of the VMware Tools excluding SVGA drivers as well as drivers for performance measurement.
5. Turn off the VM.
6. Change network adapter option in the .VMX file from ‘ethernet0.virtualDev = “e1000”’ to ‘ethernet0.virtualDev = “vmxnet”’.
7. Enable the network adapter at ‘power on’.
8. Now it should boot without problems!

• Migrating an existing or even fresh VM with Windows 7 onto a VM ESXi 3.5 did not work at all. VM ESXi tags the machine as ‘invalid’.
• Detailed Information about VM network adapters can be found in the references.
• We have not tested it for the 64bit version, though, the problem should be the same.
• Another solution, of course, is upgrading your VM ESX to ESXi 5.

VMware Community – Thread on Win7 & VM ESX

VMware Knowledge Base on Network Adapters

If you own a VM Workstation edition you just create a new virtual machine and select your .VDMK when you are ask to create a new or select an existing virtual machine disk.

In case you set the option “dynamically resizeable” in VirtualBox you might want to try these instructions. Here are the main steps to undertake this mission:

1. Convert your .VDI to a .raw image by the vboxmanage shell command:

   vboxmanage internalcommands converttoraw .VirtualBox/HardDisks/myvm.vdi vmware/myvm.raw

2. Convert the .raw image to a .VMDK file:

   qemu-img convert -O vmdk myvm.raw myvm.vmdk

3. Create a VM with VMplayer and exchange the .VMDK with your own, either by renaming or changing the config in the .vmx file.

Make sure your user has read rights to the .VMDK or is owner.

Running VirtualBox and VMplayer or the like in parallel leads to problems, e.g.

VirtualBox can’t operate in VMX root mode. Please disable the KVM kernel extension, recompile your kernel and reboot (VERR_VMX_IN_VMX_ROOT_MODE).

If you execute the VM software and then want to start a vm out of VirtualBox you will have to disable your KVM like this:

sudo rmmod kvm-intel   # for intel processors
sudo rmmod kvm-amd     # similar for amd

To enable the KVM module again just type

modprobe kvm-intel
modprobe kvm-amd

in your shell.

Fly together forever

1. Backup your home directory
2. Backup software in /opt
3. Backup essential files
   • /etc/apt/sources.list
   • /etc/hosts
   • .bashrc or another bash profile file

4. Make and backup a list of installed applications

    dpkg --get-selections > installed-software

1. Re-install your Ubuntu
2. Copy essential files
3. Copy software profiles from your home folder

4. Install dselect and start installing your applications

    sudo apt-get install dselect
    dselect

5. In parallel you already can copy your data back on your machine, as dselect will take a while.
6. Copy software to /opt and add it to your menu

• Transfer of keyrings
• Application menu

To save some trouble set the $JAVA_HOME variable in .bashrc etc.

 export $JAVA_HOME=/your/java/home/path  (e.g., /usr/lib/jvm/java-6-sun)
export PATH=$PATH:$JAVA_HOME/bin

If you have to have two versions or as in my case Open Java is re-installing through means of magic, select the right version by

 sudo update-alternatives --config java

So far so good…