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

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.
13 Comments on this post.
  • dilip
    20 January 2016 at 12:55 pm
    Leave a Reply

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

    • durga
      21 January 2016 at 4:57 am
      Leave a Reply

      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

  • fayssel yabahddou
    1 September 2016 at 11:43 am
    Leave a Reply

    hi Durga , can a integrate jasper report server with openNMS

  • rajasekar
    3 June 2017 at 12:17 pm
    Leave a Reply

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

  • venkata
    18 October 2017 at 3:11 am
    Leave a Reply

    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

    • Durga Charan Ojha
      23 October 2017 at 6:46 pm
      Leave a Reply

      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

  • krishna
    22 November 2017 at 7:43 pm
    Leave a Reply

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

    • Durga Charan Ojha
      23 November 2017 at 3:44 pm
      Leave a Reply

      Hi Krishna,
      Got your number in mail ..will call you asap.

      Thanks
      Durga

  • Titto Xavier
    30 January 2018 at 10:06 pm
    Leave a Reply

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

    • Durga Charan Ojha
      30 January 2018 at 10:55 pm
      Leave a Reply

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

    Leave a Reply

    *

    *

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

    RELATED BY