https://www.lifeonnetwork.com/install-configure-jasper-report-server-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

16 Comments

  1. dilip

    I am trying to install jasperreport in unattended mode but facing some postgres issues. Can you please help

    • durga

      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

  2. fayssel yabahddou

    hi Durga , can a integrate jasper report server with openNMS

  3. rajasekar

    LATEST VERSION java ,postgres, tomcat version list and how to install methode

  4. venkata

    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

  5. krishna

    Hi could you please provide ur contact number. I have some doubts in Jasper report software installtion in Linux using putty.

  6. Titto Xavier

    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/”

    • Hi Titto Xavier
      Can you please share more details. screenshot of the error also will help me to get the solution.
      Regards,
      Durga

  7. Soumya

    Hi Durga,

    Could you please share me the steps to install Jasper server only with Oracle database.

    Regards
    Soumya

  8. Malavika

    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

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.