Jaspersoft BI Tools

iReport,Jaspersoft Design Studio,Jaspersoft Server, Schema Workbench,Analysis,Dashboards, Self Service BI, Domains,Topics,Ad-Hoc Reports, Jaspersoft ETL, Embedding BI,HTML-5 charts, Fusion Charts,JFree Charts,Drill down reports , Drill down Dashboards,Visualize.js, Performance Tuning, D3 Charts, Jaspersoft Customization

Tuesday, January 21, 2014

iReport 5.5 CE(or any community iReport) installation steps in Ubuntu server


Hello guys,
This small post will teach you how easily you can download and install iReport in Ubuntu machine.

1. Get the software from below site

    http://ncu.dl.sourceforge.net/project/ireport/iReport/iReport-5.5.0/iReport-5.5.0.zip


Or you can also download iReport 5.5.0.tar.gz using below link

http://sourceforge.net/projects/ireport/files/iReport/iReport-5.5.0/iReport-5.5.0.tar.gz/download

You need to unzip using tar -xvf <zipfilename> on terminal.


2. Unzip in your fav location

  Example :
   root@admin:/home/softwares-installed/

You wil get a folder named below
 iReport-5.5.0

NOTE : command to unzip
unzip  iReport-5.5.0.zip


3. SET jdkhome in ireport.conf file
Location of the ireport.conf file:
root@admin:/home/softwares-installed/iReport-5.5.0/etc#nano ireport.conf


Un comment jdkhome and give the jdk path installed in ubuntu machine
For example:

jdkhome="/opt/jdk1.7.0_25/"


4. Go to this location and run ireport file from terminal
root@admin:/home/softwares-installed/iReport-5.5.0/bin# ./ireport


NOTE : 
You must install java software before in ubuntu or windows before you install iReport in either of the OS's.


Exporting project folder from jasper community server 5.0.0(will work for all the CP versions) - buildomatic export example - Ubunutu server

Exporting project folder from jasper community server  

You will learn how to import project folder of jasperserver in your Ubuntu machine(folder)
Exporting=Downloading

1) PuTTY/Ubuntu Terminal
 Give username and password and login to the Ubuntu server

2) Go to the location of jasperserver cp 5.0.0(or any version)
Example:
root@sadakar-server:cd /opt/jasperreports-server-cp-5.0.0

3) Navigate to buildomatic folder
Example:
root@sadakar-server:cd /opt/jasperreports-server-cp-5.0.0/cd buildomatic 

4) Execute js-export.sh file with the destination path.

Syntax :
root@sadakar-server:opt/jasperreports-server-cp-5.0.0/buildomatic#./js-export.sh  <location of the folder in jasper server>  --output-zip  <location of exporting folder>/<exporting_filename.zip>
Example
root@sadakar-server:/opt/jasperreports-server-cp-5.0.0/buildomatic# ./js-export.sh /reports/Demos_Sadakar --output-zip /home/sadakar/delete/sadakar.zip

NOTE: ( Give ./ before js-export)

Sample output on command prompt

Using CE setup
Using Bundled version of Java
First resource path:/opt/jasperreports-server-cp-5.0.0/buildomatic/conf_source/ieCe/applicationContext-search.xml
Started to load resources
Resource name: applicationContext.xml
Resource name: applicationContext-cascade.xml
Resource name: applicationContext-data-snapshots.xml
Resource name: applicationContext-events-logging.xml
Resource name: applicationContext-export-config.xml
Resource name: applicationContext-export-import.xml
Resource name: applicationContext-logging.xml
Resource name: applicationContext-olap-connection.xml
Resource name: applicationContext-report-scheduling.xml
Resource name: applicationContext-search.xml
Resource name: applicationContext-security.xml
Resource name: applicationContext-themes.xml
Resource name: applicationContext-virtual-data-source.xml
Creating ActionModelService object.
Creating action model infrastructure.

Testing whether export(downloading) successful or not
 Go to the location where you exported the project folder
In this example

root@sadakar-server:/home/sadakar/delete# ls
demo.war   sadakar.zip









Wednesday, January 15, 2014

Installing Jasper Server In AWS EC2 / LINUX/UBUNTU



 Things we need to find out before installing Jasperserver in AWS EC2 / Linux.
   1)      Identifying whether your CPU is a 64bit or not. Use below command to find it
uname –m
Our CPU is a 64 bit.

   2)      Identify whether Jasperserver default port 8080 is open or not? Below command helps you to identify it.
netstat -an | grep 8080| grep LISTEN

If nothing has not returned, then your port 8080 is free to use.
Installing Jasperserver
   3)      Created a folder Helical and Jasperserver under home.
/home/Helical/Jasperserver.

   4)      Downloaded Jasperserver 30-days trial from here http://www.jaspersoft.com/thanks-download-30-day
File name: Jasperreports-server-5.5-linux-x64-installer.run

Command used to download:

Community server 5.5 CP

If you face an Error saying “ -bash: wget: command not found.” Then it means wget package is not installed. Installed wget package using

yum install wget

Repeat wget command again.

   5)      Downloaded “jasperreports-server-5.5-linux-x64-installer.run” under the location “/home/Helical/Jasperserver”.

   6)      Apply chmod 777 for the downloaded file
  
It was confirmed that port 8080 is not in use with any other process. Thus i am going forward with Jasperserver installation as
“./ jasperreports-server-5.5-linux-x64-installer.run”
Results of each step:
      A)     Welcome to the JasperReports Server 5.5 Setup Wizard and its License Agreement. Do as it says and finals asks you to accept the license or not.
Press [Enter] to continue :
Reading the agreement
Accepting the License (y/n): Y
      B)      It asks you to select the option of installation (Install All or Custom). If it is for the first time Installation select first option.
Please choose an install option below:
[1] Install All Components and Samples  (requires disk space of: 1.3 GB)
[2] Custom Install
Please choose an option [1] : 1




      C)     It asks you to select a folder to install. By default it takes “/opt/jasperreports-server-5.5”
             


        Press Enter simple Instead saying Yes(Y).
     D)     It asks you to confirm the Installation by Continuing. Say (Y)
              Do you want to continue? [Y/n]: Y

            



Start Your Jasperserver from the place you have installed it. Here the Jasperserver installed path is “/home/Helical/Jasperserver/y”.
Starting Jasperserver:
You can start the jasperserver in any one of the way sh ctlscript.sh start (or)  ./ ctlscript.sh start
Check the Status of the Service:
sh ctlscript.sh status
Once again the check the port number 8080 is engaged or not.
By default jasperserver uses Postgres Database thus from this installation even postgres DB will also be available on Port Number 5432 in your machine. No need to install it explicitly.
Location of Postgres: “/home/Helical/Jasperserver/y/postgresql/bin”
Now you must be able to access the Jasperserver from “ipaddress:8080/jasperserver-pro”. If not able to access it Check whether 8080 is configured to access TCP/IP incoming and outgoing in iptables.
Edit iptables as root user using vi /etc/sysconfig/iptables

Add a rule saying

-A INPUT -p tcp -m state --state NEW -m tcp --dport 8080 -j ACCEPT

Now you must be able to access the Jasperserver.