Install and configure Jasper Report Server on Ubuntu Server

By Durga Charan Ojha

October 10, 2014

0

9566

Contents hide

1 Install and configure Jasper Report Server on Ubuntu Server

2 (Configuring through terminal/putty)

3 Type the below command to start the download

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

Previous articleInstall Linux as Guest operating system on Oracle VM Virtual Box and configure Port Forwarding

Next articleMake bootable pen drive/usb drive – windows

16 COMMENTS

dilip January 20, 2016 At 12:55 pm

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

Reply
- durga January 21, 2016 At 4:57 am
  
  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
  
  Reply
fayssel yabahddou September 1, 2016 At 11:43 am

hi Durga , can a integrate jasper report server with openNMS

Reply
rajasekar June 3, 2017 At 12:17 pm

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

Reply
- durga June 5, 2017 At 2:49 pm
  
  Hi Rajsekar,
  here I found the latest version of Jasper report server released version
  so the first wget url to download the Jasper report server is
  http://downloads.sourceforge.net/project/jasperserver/JasperServer/JasperReports%20Server%20Community%20Edition%205.6.0/jasperreports-server-cp-6.3.0-linux-x64-installer.run
  
  rest you can follow the steps to install.
  
  Reply
  - kishore ch July 12, 2017 At 3:15 pm
    
    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.
    
    Reply
    - durga July 12, 2017 At 3:36 pm
      
      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
      
      Reply
venkata October 18, 2017 At 3:11 am

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

Reply
- Durga Charan Ojha October 23, 2017 At 6:46 pm
  
  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
  
  Reply
krishna November 22, 2017 At 7:43 pm

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

Reply
- Durga Charan Ojha November 23, 2017 At 3:44 pm
  
  Hi Krishna,
  Got your number in mail ..will call you asap.
  
  Thanks
  Durga
  
  Reply
Titto Xavier January 30, 2018 At 10:06 pm

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

Reply
- Durga Charan Ojha January 30, 2018 At 10:55 pm
  
  Hi Titto Xavier
  Can you please share more details. screenshot of the error also will help me to get the solution.
  Regards,
  Durga
  
  Reply
Soumya February 15, 2019 At 9:29 pm

Hi Durga,

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

Regards
Soumya

Reply
Malavika August 6, 2019 At 10:04 am

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

Reply
- Durga Charan Ojha August 6, 2019 At 10:56 am
  
  Hi Malavika,
  Will you please let me know the Ubuntu version ?
  
  Reply