Installation and Configuration of the Pentaho Java Print Server



Introduction

This section explains how to install and config the Pentaho Java Print server on an Ubuntu 12.04 LTS server. This is necessary if you want to print reports directly within OpenERP. 

Instructions for setting up the Pentaho Java server and OpenERP add-on are on the WillowIT Git-Hub website:  

The approach I took was slightly different, as I was missing various applications and libraries on my Ubuntu 12.04 LTS Server.  This may not be applicable to everyone, so check before you run the follow steps. 

1. Download and Install OpenJDK 6.0 prebuilt OpenJDK packages

Install the OpenJDK packages of you haven't already done so. On the command line, type:
$ sudo apt-get install openjdk-6-jre
$ sudo apt-get install openjdk-6-jdk
The openjdk-6-jre package contains just the Java Runtime Environment. You'll also need to install the openjdk-6-jdk package.


2. Install Apache Ant

$ sudo apt-get install ant


3. Install apache Ivy

$ sudo apt-get install ivy

this installs ivy but doesn't seem to install the library into the correct directory, as I was getting this error when trying to compile:

failed to create task or type antlib:org.apache.ivy.ant:retrieve

so I needed to do the follow steps too: 
  • Download Ivy from the Apache website http://ant.apache.org/ 
  • rename the file ivy-.2.3.0.jar to ivy.jar (or whatever is the latest version)
    • sudo mv ivy-2.3.0.jar ivy.jar
  • move the file it to the following directory  /usr/share/ant/lib 
    • sudo mv ivy-2.3.0.jar /usr/share/ant/lib/

5. Download the Willow-It java server

6. Build the war file

Follow the instructions on the WillowIT Github website :

cd <extracted_path>/java_server
$ sudo ant war

The server will then compile (takes about 4 minutes). It creates a file called pentaho-reports-for-openerp.war. If the build completed successfully, the WAR file can be found in the build/jar directory.

7. Launching the server

For testing purposes, a standalone server that listens on port 8090 (by default) can be launched using the "launch" target:

$ sudo ant launch
This takes about 10 minutes to compile and run the server for the first time. In the console you'll see the server startup and download missing libraries. The console will then inform you that is  waiting and accepting requests as follows.


[java] INFO AbstractBoot - Pentaho Reporting Engine Classic 3.9.0-GA.15546 started.

[java] INFO StandaloneReportServer - Attempting to start XML-RPC server at /0.0.0.0:8090

[java] INFO StandaloneReportServer - Started successfully

[java] INFO StandaloneReportServer - Accepting requests


You can test that the server is accepting connection by opening a browser with the following URL:
  • http://192.168.178.29:8090/pentaho-reports-for-openerp
Use the IP address of your own server. The Pentaho is listening on port 8090.


In the console you should receive see this error appear.

RequestException: GET

     [java] ERROR XmlRpcErrorLogger - org.apache.xmlrpc.webserver.Connection$Bad



That's it !

No you just need to install and configure the Pentaho Module for OpenERP

Ref:

1. Installation of  TomCat (Optional if you don't have apache installed)

You may need to install TomCat if you don't already have Apache installed. Here asre the details.

a) Check the current version and rename the command line directory and file name below v7.0.XX with the correct version number


wget http://mirror.atlanticmetro.net/apache/tomcat/tomcat-7/v7.0.XX/bin/apache-tomcat-7.0.XX.tar.gz


Untar the file
tar xvzf apache-tomcat-7.0.XX.tar.gz



Finish up the Tomcat installation on the VPS by moving the files to a convenient directory.
sudo mv apache-tomcat-7.0.29  ~/path/to/tomcat


/usr/lib/jvm/Java-6-openjdk-adm64/lib/tools.jar