xReporter Prerequisites
Overview
Coral makes use of xReporter as it's reporting engine. xReporter is an open-source, web-based database reporting framework that is available at http://xreporter.cocoondev.org. It, in turn, is build on top of several open source Apache projects including Tomcat, Cocoon, and Phoenix. From the perspective of the Coral administrator, xReporter is an excellent choice because it makes use of the same set of roles that are used by Coral to determine which reports can be run by which users. For example, someone with a lab-wide role of "admin" can see and run a broad range of reports including those that inlcude charges for laboratory use for all lab members. Conversely, a "normal" lab member is only allowed to run a more limited set of reports. For example, they can generate reports based on their own lab charges or their own lab activities, but are not allowed to generate reports for other labmembers. In addition to being able to view reports from any web browser, reports may also be easily generated in either Excel (*.xls) or Acrobat (*.pdf) formats.
Because xReporter relies on installation and configuration of several third-party components, we have elected to bundle xReporter with compatible versions of Tomcat, Cocoon, Phoenix, and JK Connectors. Moreover, we have done our best to package and configure these components in a way that should largely automate this process and yet provide sufficient flexibilty to accommodate the web environments found at various research facilities.
Assumptions
We assume that there is a running Web server on the machine on which xReporter will be installed. This webserver will likely be hased on the Apache 2.0 or 2.2 series. In addition to the main web server, we assume that apxs (supporte for APache eXtraS) is installed. If this is a Linux machine, it means that you need not only the httpd RPM but also the httpd-devel RPM.
You will need an appropriate JDK (Java Development Kit) and a reasonably new version of apache ant. The original release of Coral-compatible xReporter (and related Tomcat, Cocoon, and Phoenix modules) only ran under the older j2sdk1.4.2. The most recent releases of Coral-compatible xReporter (and newer Tomcat, Cocoon, and Phoenix modules) will only run under jdk1.5.0 or jdk1.6.0. Accordingly, the choices that you can make when configuring xReporter depend heavily on which JDK you are running.
If you are running j2sdk1.4.2 you must choose:
- Tomcat version 4.1 (jakarta-tomcat-4.1.31).
- Cocoon version 2.1.6 (cocoon-2.1.6).
- Phoenix version 4.0.4 (phoenix-4.0.4).
If you are running jdk1.5.0 or jdk1.6.0you must choose:
- Tomcat version 5.5 or 6.0 (apache-tomcat-5.5.23 or apache-tomcat-6.0.14, respectively).
- Cocoon version 2.1.10 (cocoon-2.1.10).
- Phoenix version 4.0.4 upgraded for J2SE 5.0 service (phoenix-4.0.4-tiger).