27.8 C
Cuttack
Tuesday, November 23, 2021
HomeLinuxInstall and configure Jasper Report Server on Ubuntu Server

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
net.sf.jasperreports.query.executer.factory.plsql=com.jaspersoft.jrx.query.PlSqlQueryExecuterFactory
 

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
Durga Charan Ojhahttps://lifeonnetwork.com/
I am a proud Indian, proud father, a blogger, Being in a profession as System administrator, my passion is troubleshooting computer issues, I do like sharing solutions through blogging making videos of solving issues.
RELATED ARTICLES

16 COMMENTS

    • Hi Dillip,
      Will surely help you configuring Jasper Report here… Please do share the error and uptil which command you have tried and successful.

      Regards,
      Durga

  1. Hi Durga,

    is it really necessary to install tomcat , prior to installing jasperreports-server-cp-6.3.0-linux-x64-installer.run, as I have a tomcat installed on 8080, and when I ran this jasperreports-server-cp-6.3.0-linux-x64-installer.run it again asked me for port then I gave 8081. now which one will the jasper use.

    Thanks,
    Venkata

    • Hi Venkata, Jasper report with Tomcat bundled will install Tomcat.. if you have already installed then you can skip installing it. I would suggest to go with bundled one comes with Jasper report.

      Regards,
      Durga

  2. I got a warning “problem running post-installation step. Installation may not complete correctly ” as a prompt.
    So I can’t get the url “http:localhost:port/”

  3. sudo ./jasperreports-server-cp-5.6.0-linux-x64-installer.run
    ./jasperreports-server-cp-5.6.0-linux-x64-installer.run: 1: ./jasperreports-server-cp-5.6.0-linux-x64-installer.run: Syntax error: “(” unexpected

    Some Error, please help

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular