Installing Jasper reporting for MySQL on CentOS 5.4
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
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