CentOS 5.4 Tutorials

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.

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

Preliminary Note:

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

* (IP CentOS 5.4 x86_64 Base installation

Download and Install BitNami JasperSever Stack

# wget
# 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/ 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

# ./ start
# ./ stop

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

Now your MySQL reporting can begin.

By George

Technical Samurai specializing in open source IT Automation and Cloud Infrastructure.