The recommended software components for this version of ExtraView are listed under the Server Requirements page. It is possible that other components will work, but they may not have been certified these for use with ExtraView. This page provides some specific information on third-party software components and how they should be configured.
The database should be created using the AL32UTF16 / UTF-8 character set. ExtraView may run successfully using other character sets, but it has not been tested and certified on these and ExtraView will not provide support for them. In addition, it is very important that the multi-threaded MTS system options are turned off.
You must install the Oracle software separately from ExtraView, before beginning the installation of ExtraView. You will be provided with scripts to create the necessary tablespaces and the schema user with the necessary privileges.
The database should be created using the UCS-2 character set. ExtraView may run successfully using other character sets, but it has not been tested and certified on these and ExtraView will not provide support for them.
The database must be configured with mixed mode authentication turned on.
You must install SQL Server software separately from ExtraView, before beginning the installation of ExtraView.
JDBC Driver for Microsoft SQL Server
The JDBC driver provided by Microsoft is not supported by ExtraView, as it has several problems which have not been repaired by Microsoft, particularly as they support the use of database BLOB’s. ExtraView includes the jTDS JDBC driver for use with SQL Server. It is strongly recommended that you use this driver.
Please ensure that the database installation is configured per the guidelines listed further on in this guide.
Apache Derby can be used as a database with ExtraView. You must patch your version of Derby to handle compatibility issues. The supported Derby version is 10.5.1.1. The patched files are:
db-derby-10.5.1.1-src/java/engine/org/apache/derby/iapi/types/DataTypeDescriptor.java
db-derby-10.5.1.1-src/java/engine/org/apache/derby/impl/sql/compile/BaseTypeCompiler.java
Note that the version of Derby shipped with the downloadable version of ExtraView that embeds Derby has these files already patched.
Note: The Derby database is not intended for major deployments of mission critical systems. ExtraView Corp recommends one of the other supported databases for implementations that have strategic importance to your company, or will store a large number of issues or will support a large number of users.
The package can be downloaded from http://www.apache.org. It is strongly recommended that you configure your web server with SSL (Secure Sockets Layer). This is a fundamental requirement for a secure environment and ExtraView Corporation cannot provide any assurances for the security of the ExtraView environment without this basic configuration.
This is an alternative to the Apache web server and also requires a separate license, available from Microsoft Corporation. ExtraView Corporation does not provide this license as part of ExtraView. When using IIS, Apache Tomcat is required to be installed as an application server. It is strongly recommended that you configure your web server with SSL (Secure Sockets Layer). This is a fundamental requirement for a secure environment and ExtraView Corporation cannot provide any assurances for the security of the ExtraView environment without this basic configuration.
The package can be downloaded from http://www.apache.org.
This is an alternative to Apache Tomcat, and requires a separate license, available directly from Oracle. ExtraView Corporation does not provide this license as part of ExtraView.
Full installation instructions for JBoss with ExtraView are not provided, but please use these points along with the standard JBoss installation instructions:
The ExtraView runPatches.sh file should be modified, in order to make it conform to the typical JBoss path structure. The servlet jar for JBoss is in different location to where the file is expected. These settings should replace the settings in the file:
JAVA_HOME=/app/java/jdk1.x.x.x/jre/
JBOSS_HOME=/app/user_domains/xxx/jbossxxdomains/xxx-tst/xxx-tst_server1/
EV_BASE=$JBOSS_HOME/deployments/uimsxxx.war/
SERVLET_JAR=/app/jboss/jboss-eap-x.x.x/modules/system/layers/base/javax
/servlet/api/main/jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar
Load balancing under an Apache server needs modifications from the standard instructions:
Modify the worker.properties file
# Worker for area [xxx(2657)]URL [http://tst.my_company.com/yyy/]
worker.amrndhl277_15619.type=ajp13
worker.amrndhl277_15619.host=amrndhl277
worker.amrndhl277_15619.port=15619
worker.amrndhl277_15619.route=*yyy-tst_server1*
# Worker for area [xxx(2657)]URL [http://tst.my_company.com/uims/]
worker.amrndhl278_15619.type=ajp13
worker.amrndhl278_15619.host=amrndhl278
worker.amrndhl278_15619.port=15619
worker.amrndhl278_15619.route=*yyy-tst_server2*
# LB Worker for area [xxx(2657)] URL [http://tst.my_company.com/uims/]:
worker.lb_yyy_tst.my_company.com_80.type=lb
worker.lb_yyy_tst.my_company.com_80.balance_workers=amrnd
*worker.lb_yyy_tst.my_company.com_80.sticky_session=1*Modify the server.xml file
Add a subsystem with an instance-id property that matches the route property in for each work defined above.
<subsystem xmlns="urn:jboss:domain:web:1.1"... instance-id="*yyy-tst_server1”*>
<subsystem xmlns="urn:jboss:domain:web:1.1"... instance-id="*yyy-tst_server2*">The package can be downloaded from http://www.oracle.com.
This is only required if you want to compile your own version of Apache, as opposed to use a pre-compiled version.
The GNU C compiler (GCC) from the Free Software Foundation (FSF) is recommended. However, as an alternative, ensure your vendor’s compiler is ANSI compliant. You can find the homepage of GNU at http://www.gnu.org and the GCC distribution under http://www.gnu.org/order/ftp.html.
The CLI is an optional component of ExtraView. If you will be using the CLI, you must install this software. You may download an open source version of the Strawberry Perl software from here.
In addition, you will need to download the following additional Perl modules from CPAN (Comprehensive Perl Archive Network). The required modules are:
ExtraView must be able to access Microsoft Exchange or an SMTP-based email server, in order to generate outbound email notifications.
If you are configuring ExtraView to accept incoming emails to create new issues and/or update existing issues, then you will require a mailbox to be available exclusively to ExtraView.
The current server recommendations can be viewed and downloaded by clicking here.