Saturday, September 23, 2017
Home > Linux > Install and configure Jasper Report Server on Ubuntu Server

Install and configure Jasper Report Server on Ubuntu Server

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

Give permission to run as super user

To start the Jasper server installation

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

Setup plsql query adapter
Download extensions for jasperreports-extension

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

net.sf.jasperreports.query.executer.factory.plsql=com.jaspersoft.jrx.query.PlSqlQueryExecuterFactory
 

Then edit flows/queryBeans.xml. Change the line

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.

Now finally restart the Jasper Server.

Durga Charan Ojha
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.
https://lifeonnetwork.com/

7 thoughts on “Install and configure Jasper Report Server on Ubuntu Server

    1. 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,

        I little bit confusion tomcat …. i all ready have the tomcat installation in system.
        But inside the jar folder there is another tomcat … i mean it is installed the other or ?.

        and also after starting the jasper …what is the url i need to use to open in web.

        1. Hi Kishore,
          To check status of Tomcat
          $ ps -ef | grep tomcat

          Do you think both are running on different port ?
          $ sudo service tomcat7 status
          you can either disable/turn off the service.

          Web log in for Jasper, can try with the port number.
          http://:8080/jasperserver-pro

          Regards,
          Durga

Leave a Reply

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