Install and configure Jasper Report Server on Ubuntu Server

Install and configure Jasper Report Server on Ubuntu Server

(Configuring through terminal/putty)

Type the below command to start the download

$ wget -c http://downloads.sourceforge.net/project/jasperserver/JasperServer/JasperReports%20Server%20Community%20Edition%205.6.0/jasperreports-server-cp-5.6.0-linux-x64-installer.run

Give permission to run as super user

$ chmod a+x jasperreports-server-cp-5.6.0-linux-x64-installer.run

To start the Jasper server installation

$ sudo ./jasperreports-server-cp-5.6.0-linux-x64-installer.run

It will show you the license page. Read through it and select y when it prompts

Do you accept this license? [y/n]: y shows up.

It will ask to choose complete install or custom install. Choose custom.

It will ask to select a folder for install destination.

choose the default /opt/jasperreports-server-cp-5.6.0.

It will ask you to use bundled tomcat or existing one. Choose bundled.

Leave the tomcat port as default else assign one like – 8088

Assign one shutdown port as – 8089

Choose Postgresql as Bundled and default port as – 5432

Choose to create sample database and proceed

Now after Jasper Server installation lets start Tomcat server

$ /opt/jasperreports-server-cp-5.6.0/ctlscript.sh start

Setup plsql query adapter
Download extensions for jasperreports-extension

$ wget -c http://www.java2s.com/Code/JarDownload/jasperreports/jasperreports-extensions-3.5.3.jar.zip

Unzip jasperreports-extensions-3.5.3.jar.zip

sudo unzip jasperreports-extensions-3.5.3.jar.zip

Copy the jasperreports-extensions-3.5.3.jar inside this folder /opt/jasperreports-server-cp-
5.6.0/apache-tomcat/webapps/jasperserver/WEB-INF/lib/

Now cd /opt/jasperreports-server-cp-5.6.0/apache-tomcat/webapps/jasperserver/WEB-INF
and add one line to classes/jasperreports.properties

$ sudo vi classes/jasperreports.properties

Then edit flows/queryBeans.xml. Change the line

<property name="queryLanguages" ref="queryLanguages">
<list>
<value>sql</value>
<value>plsql</value>
<value>hql</value>
</list>
</property>

Then edit applicationContext.xml. Search for supportedQueryLanguages and add these to the following for PL/SQL Language. You will find supportedQueryLanguages in two places so add the below lines twice.

<value>plsql</value>
<value>PLSQL</value>

Now finally restart the Jasper Server.

$ /opt/jasperreports-server-cp-5.6.0/ctlscript.sh stop
$ /opt/jasperreports-server-cp-5.6.0/ctlscript.sh start

You may also like: ssh exchange identification connection closed by remote host