JasperServer 3.5 with PostgreSQL 8.3 on Linux

JasperServer (JS) builds on JasperReports (JR) as a comprehensive family of Business Intelligence (BI) products, providing robust static and interactive reporting, report server, and data analysis capabilities. For business intelligence users, Jaspersoft offers JasperAnalysis, which runs seamlessly on JasperServer.

Note: This blog is updated based on JS-3.5 GA release

What’s New in JasperServer 3.5

JasperServer now includes these features:

  • Upgrade Mondrian to 3.0
    • Dimension sharing within a cube
    • Support for dozens of new scalar functions in MDX
  • New JasperAnalysis UI
    • Improved look and feel as well as an improved tool bar within analysis views.

Read More

Tips for Linux / Unix Systems Administrator

How to un-mount the unresponsive media drive

First, let’s simulate it. Stick a disk in your CD/DVD drive, open up a terminal, and mount the CD/DVD drive. If your system automatically mount, then you can skip the mounting part.

root@server:~# mount /media/cdrom
root@server:~# cd /media/cdrom
root@server:~# while [ 1 ]; do echo "All your drives are belong to us!"; sleep 30; done

Now lets open up a second terminal and try to eject the media drive:

root@server:~# eject

Read More

How to make Microsoft Outlook prompt on empty subject

It’s important and mandatory that the emails we send have relevant “subject” to it. Almost all email clients have this feature, where it will prompt user about the empty subject.

Unfortunately, when i started using Microsoft Office Outlook (previously i was using Thunderbird) as this is what my new company is using, i notice that Ms Outlook doesn’t prompt if i missed out the subject.

Then i Google it and found the solution for it. Please follow the simple steps below which will prevent you from sending a mail without a subject.Read More

JasperServer Installation on Linux

This documents updated for JasperServer version 3.0.0

What is JasperServer

JasperServer is an open source business intelligence suite, built by the developers of JasperReports. It providing common services like security and metadata management, and the capability to easily add additional functionality.It also provides a Web and Web services based environment for reporting, data analysis (OLAP), and data integration.

What is JasperReports

JasperReports is a powerful open source Java reporting tool that has the ability to deliver rich content onto the screen, to the printer or into PDF, HTML, XLS, CSV and XML files. It is entirely written in Java and can be used in a variety of Java enabled applications, including J2EE or Web applications, to generate dynamic content. Its main purpose is to help creating page oriented, ready to print documents in a simple and flexible manner.Read More

SSH Tunneling

SSH Tunneling is also known as Port Forwarding is a way to forward insecure TCP traffic through SSH Secure Shell. For an example, we can make a secure POP3 access by forwarding non-standard local port to remote POP3 port using SSH.

ssh -f user@mail-server -L 2000:localhost:110 -N

-f –> Requests ssh to go to background just before command execution
-L –> port:host:hostport -> Specifies that the given port on the local (client) host is to be forwarded to the given host and port on the remote side.
-N –> Do not execute a remote command. This is useful for just forwarding ports.Read More