Installing Jasper reporting for MySQL on CentOS 5.4

bitnami_stackcentosWhat is BitNami?

BitNami Native Installers automate the setup of a BitNami Stack on Windows, Linux or Mac OS X. Each installer includes all of the software necessary to run out of the box (the Stack). The process is simple; just download, click next-next-next and you are done! BitNami Stacks are completely self contained and will not interfere with other software on your system.

http://bitnami.org/

What is Jasper for MySQL?

JasperServer Professional is a high-performance standalone and embeddable report server that provides non-technical business users with:

  • Drag and drop ad hoc report building
  • Drag and drop dashboarding with live-refresh, and mash-ups with external content
  • A rich business metadata layer for easy ad hoc query
  • Integrated and in-memory data analysis
  • Built-in charting and integration with third-party visualization tools
  • Self-service parameterized web reporting
  • Report scheduling, distribution and historical versioning
  • A secure report and metadata repository
  • Access to any data source including relational, XML, Hibernate, EJB, POJO, and custom
  • Row and column level data security

http://www.jaspersoft.com/jasperserver

Preliminary Note:

I am using a CentOS 5.4 x86_64 base installation in this tutorial

  • server1.example.co.za (IP 10.0.0.100): CentOS 5.4 x86_64 Base installation

Download and Install BitNami JasperSever Stack

# wget http://bitnami.org/files/stacks/jasperserver/bitnami-jasperserver-3.5.0-0-linux-installer.bin
# chmod 755 ./bitnami-jasperserver-3.5.0-0-linux-installer.bin
# ./bitnami-jasperserver-3.5.0-0-linux-installer.bin
----------------------------------------------------------------------------
Welcome to the BitNami JasperServer Stack Setup Wizard.

----------------------------------------------------------------------------
Installation folder

Please, choose a folder to install BitNami JasperServer Stack

Select a folder [/opt/jasperserver-3.5.0-0]:

----------------------------------------------------------------------------
MySQL Information

Please enter your MySQL database information:

MySQL Server port [3306]:

----------------------------------------------------------------------------
MySQL Credentials

Please enter your database root user password

MySQL Server root password :
Re-enter password :
----------------------------------------------------------------------------
Setup is now ready to begin installing BitNami JasperServer Stack on your computer.

Do you want to continue? [Y/n]:

In this installation I went ahead and chose all the defaults

Note: if you get this error:

-bash: ./bitnami-jasperserver-3.5.0-0-linux-installer.bin: /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory

make sure the i386 version of ibstdc++ is installed:

# rpm -qa | grep ibstdc++
# yum install libstdc++

Starting and Stopping the JasperServer

# ./catalina.sh start
# ./catalina.sh stop

Once you have started the JasperServer point your browser to the following URL to access the JasperServer GUI

http://server1.example.co.za:8080/jasperserver/login.html

jasperserver
Now your MySQL reporting can begin.