JasperReports Server 8.0 Manual Installation

The following article describes how to manually install JasperReports Server 8.0.

Note: Assumption is the installation is without samples.

To manually install JasperReports Server 8.0:

1. Create and initialize jasperserver database.

a. Start sqlplus client and run the following commands:

create user jasperserver identified by password; (as sys user)

grant connect, resource to jasperserver; (as sys user)

grant unlimited tablespace to jasperserver; (as sys user)

connect jasperserver/password@ORCL (use your password, your SID)

@/opt/jasperreports-server-pro-8.0-bin/buildomatic/install_resources/sql/oracle/js-pro-create.ddl

@/opt/jasperreports-server-pro-8.0-bin/buildomatic/install_resources/sql/oracle/js-pro-create-audit.ddl

@/opt/jasperreports-server-pro-8.0-bin/buildomatic/install_resources/sql/oracle/quartz.ddl

2. Create and initialize audit database (split installation):

a. create user jsaudit identified by password; (as sys user)

grant connect, resource to jsaudit; (as sys user)

grant unlimited tablespace to jsaudit; (as sys user)

connect jsaudit/password@ORCL

@/opt/jasperreports-server-pro-8.0-bin/buildomatic/install_resources/sql/oracle/js-sequence-create.ddl

@/opt/jasperreports-server-pro-8.0-bin/buildomatic/install_resources/sql/oracle/js-pro-create-audit.ddl

3. Import required resources (minimal-resources and themes):

Exit sqlplus client and go to <js-install>/buildomatic path. Modify “default_master.properties” file with required values. If it’s required, configure audit split installation type. For example, here are some properties from default_master.properties:

dbUsername=jasperserver

dbPassword=password

sysUsername=jasperserver

sysPassword=password

dbHost=localhost

dbPort=1521

sid=ORCL

#audit props

installType=split

audit.dbHost=localhost

audit.dbPort=1521

audit.sid=ORCL

audit.dbUsername=jsaudit

audit.dbPassword=password

audit.dbName=jsaudit

audit.sysUsername=system

audit.sysPassword=password

You can set sysUsername and sysPassword to be the same as dbUsername and dbPassword.

Next, execute the following command:

./js-ant import-minimal-pro

4. Create server setting with audit db schema name (auditDB=JSAUDIT):

Go to <js-install>/buildomatic/bin path and edit db-common.xml file.

Add the following target in the end of file, before </project>:

    <target name="import-profile-attributes">

        <import-profile-attribute key="auditDB" attrValue="${audit.dbName}"/>

    </target>

Save and exit the file and run the following command from the command line:

./js-ant import-profile-attributes

Note: The server setting auditDB=JSAUDIT is needed for audit reports to work properly on Oracle in case of split installation.

5. Deploy JasperReports Server:

./js-ant deploy-webapp-pro

6. Add license file

Copy the jasperserver.license file in <js-install> to the home directory for your operating system /home/<user> and start your application server.