Install and configure Jasper Report Server on Ubuntu Server
(Configuring through terminal/putty)
Type the below command to start the download
|
1 |
$ 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
|
1 |
$ chmod a+x jasperreports-server-cp-5.6.0-linux-x64-installer.run |
To start the Jasper server installation
|
1 |
$ 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
|
1 |
$ /opt/jasperreports-server-cp-5.6.0/ctlscript.sh start |
Setup plsql query adapter
Download extensions for jasperreports-extension
|
1 |
$ wget -c http://www.java2s.com/Code/JarDownload/jasperreports/jasperreports-extensions-3.5.3.jar.zip |
Unzip jasperreports-extensions-3.5.3.jar.zip
|
1 |
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
|
1 |
$ sudo vi classes/jasperreports.properties |
Then edit flows/queryBeans.xml. Change the line
|
1 2 3 4 5 6 7 |
<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.
|
1 2 |
<value>plsql</value> <value>PLSQL</value> |
Now finally restart the Jasper Server.
|
1 2 3 4 |
$ /opt/jasperreports-server-cp-5.6.0/ctlscript.sh stop $ /opt/jasperreports-server-cp-5.6.0/ctlscript.sh start <strong>You may also like:</strong> <a class="mentionable" href="https://www.lifeonnetwork.com/mac/solution-ssh_exchange_identification-connection-closed-remote-host/" target="_self" data-mentionable="379">ssh exchange identification connection closed by remote host</a> |
I am trying to install jasperreport in unattended mode but facing some postgres issues. Can you please help
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
hi Durga , can a integrate jasper report server with openNMS
LATEST VERSION java ,postgres, tomcat version list and how to install methode
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.
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.
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.:8080/jasperserver-pro
http://
Regards,
Durga