Monday, 5 June 2017

Installing Birt on Linux

This is a simple post of how to install the Birt reporting engine on Linux. In this example I am installing on Linux Mint 18.1 but the same will apply to other versions and distros based on Debian/Ubuntu.

You can use your package manager or the command line apt-get tool.

Step 1: Install Apache2 and Mysql
Apache 2 is the web server of choice for a lot of Linux installations. Mysql is a free database engine. I would assume that these tools would already be installed on your system by the time you wanted to get birt up and running.

$ sudo apt-get install apache2 mysql-server

Step 2: Install Tomcat8
At the time of writing, this is the latest version of Tomcat

$ sudo apt-get install tomcat8

Step 3: Webapps folder
This is generally downloaded from the Birt-eclipse website ( Unzip the file, the folder we're interested in is the WebViewerExample, you can rename this as you wish and copy or link it under /var/lib/tomcat8/webapps/

Step 4: jdbc driver

For MySQL:

$ sudo apt-get install libmysql-java

For Microsoft SQL Server, download from SourceForge, unzip the file, copy the jtds-*.jar file to /var/lib/tomcat8/lib

Step 5 restart birt

$ sudo service tomcat8 restart

 Additional Steps
Assuming you're using Eclipse to design the report, you will need to install the mysql driver into that, the download for the jar file is here