Installing #Jasper reporting for #MySQL on #CentOS 5.4

On November 6, 2009, in Centos, by How2CentOS

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.

Tagged with:  

centosThe psacct package contains several utilities for monitoring process activities, including ac, lastcomm, accton and sa. The ac command displays statistics about how long users have been logged on. The lastcomm command displays information about previous executed commands. The accton command turns process accounting on or off. The sa command summarizes information about previously executed commmands. Install the psacct package if you’d like to use its utilities for monitoring process activities on your CentOS 5.4 system.

Installing the psacct package

Use yum command if you are using CentOS 5.4 / Fedora 11 / RHEL 5.4:

# yum install psacct

Continue reading »

Tagged with:  

How to install #XEN 3.4.1 on #CentOS 5.4

On October 23, 2009, in Centos, by How2CentOS

centosxenWhat is Xen?

The Xen hypervisor, the powerful open source industry standard for virtualization, offers a powerful, efficient, and secure feature set for virtualization of x86, x86_64, IA64, ARM, and other CPU architectures. It supports a wide range of guest operating systems including Windows, Linux, Solaris, and various versions of the BSD operating systems.

Continue reading »

Tagged with:  

Adding #CentOS 5.4 to local #YUM Repository

On October 14, 2009, in Centos, by How2CentOS

centos
What is CentOS?

CentOS is 100% compatible rebuild of the Red Hat Enterprise Linux, in full compliance with Red Hat’s redistribution requirements. CentOS is for people who need an enterprise class operating system stability without the cost of certification and support.

Following the release of RHEL 5.4, CentOS 5.4 has just hit the CentOS mirrors. Time to update the Local CentOS YUM repository script.

Adding CentOS 5.4 to the YUM repository script

Create the following additional Directories for CentOS 5.4:

# mkdir -p /var/www/html/centos/5.4/os/i386
# mkdir -p /var/www/html/centos/5.4/updates/i386
# mkdir -p /var/www/html/centos/5.4/os/x86_64
# mkdir -p /var/www/html/centos/5.4/updates/x86_64

Add the CentOS 5.4 repository to the bash script which will rsync your local YUM repository server with a CentOS 5.4 YUM mirror.

CentOS Mirror list – http://www.centos.org/modules/tinycontent/index.php?id=30

# vi yum-repo-update.sh

#!/bin/sh

rsync="rsync -avrt --bwlimit=256"

mirror=ftp.is.co.za::IS-Mirror/centos

verlist="5.3 5.4"
archlist="i386 x86_64"
baselist="os updates"
local=/var/www/html/centos/

for ver in $verlist
do
 for arch in $archlist
 do
  for base in $baselist
  do
    remote=$mirror/$ver/$base/$arch/
    $rsync $remote $local/$ver/$base/$arch/
  done
 done
done

NB! Please read creating a Local CentOS YUM repository on CentOS 5.x before implementing.

Upgrading from CentOS 5.3 ( or CentOS 5.0 / 5.1 / 5.2 ):

If you are already running CentOS 5.3 or an older CentOS 5 distro, all you need to do is update your machine via yum by running :

# yum update

Tagged with:  
Get Adobe Flash playerPlugin by wpburn.com wordpress themes
Afrigator
Blog WebMastered by All in One Webmaster.