Creating Zabbix line chart CPU utilization report using iReports

Posted on September 13th, 2010

Hello All.
We are about to create nice looking reports with Jasper Soft’s iReport designer and deploy it to Jasper Reports Server. We will create an xml report descriptor (jrxml file) which can be deployed to Jasper server to create and send the reports by email on the scheduled basis.

Read the rest of this entry »

Tags: reports, Zabbix
Filed under JasperReports, Reporting, Zabbix | 1 Comment »

Running JasperServer under Solaris 9 SPARC

Posted on July 8th, 2010

1. Download java_ee_sdk-5_01-solaris-sparc.sh. Install it, say in /opt/j2ee1.5
2. Download jboss-5.0.1.GA.zip and unpack it into, for example /opt/jboss
3. Download jasperserver-ce-3.7.0-bin.zip and unpack it into /opt/jasper.
4. Create user and group jboss, then chown -R jboss:jboss /opt/jasper /opt/jboss
give him .bash_profile with environment to run Jboss and jakarta ant. (my ant located in /usr/sfw/bin)

PATH=/opt/j2ee1.5/jdk/bin:/usr/sfw/bin:$PATH
JAVA_HOME=/opt/j2ee1.5/jdk
export PATH JAVA_HOME

5. Install mysql server, and grant jasperdb user all priviliges on all the databases and tables.
6.

 cd /opt/jasper/jasperserver-ce-3.7.0-bin/buildomatic
cp sample_conf/dist/default_master.properties .
vi default_master.properties

Edit the file like this

appServerDir = /opt/jboss
appServerType = jboss
dbType=mysql
dbUsername=jasperdb
dbPassword=password
dbHost=mysqlhost
remote.test.host=jasper.mydomain.com
remote.test.port=8080
remote.test.app-context-path=jasperserver

Note the jasper.mydomain.com must be hostname of your application server.
Next, create and load the database, deploy web application. Note that the application server must be stopped.

./js-ant clean-config
./js-ant gen-config
./js-ant create-js-db
./js-ant create-sugarcrm-db
./js-ant create-foodmart-db
./js-ant load-sugarcrm-db
./js-ant load-foodmart-db
./js-ant update-foodmart-db
./js-ant init-js-db-ce
./js-ant import-minimal-ce
./js-ant import-sample-data-ce
./js-ant deploy-webapp-ce

Finally, start Jboss.

cd /opt/jboss/bin
./run.sh -b 0.0.0.0

and login to the Jasper Server using jasperadmin/jasperadmin login/password.

To enable JasperServer use of mysql database, you should download mysql-connector-java-5.1.13.zip, unpack it and copy mysql-connector-java-5.1.13-bin.jar to /opt/jboss/server/all/lib directory.

To send emails for scheduled reports correct email server settings in the js.quartz.properties file located in WEB-INF directory

report.scheduler.mail.sender.host=mail.localhost.com
report.scheduler.mail.sender.username=admin
report.scheduler.mail.sender.password=password
report.scheduler.mail.sender.from=admin@localhost.com
report.scheduler.mail.sender.protocol=smtp
report.scheduler.mail.sender.port=25

Filed under JasperReports | 1 Comment »