Recommended Software

The recommended software components for this version of ExtraView are listed in this section. It is possible that other components will work, but they may not have been certified these for use with ExtraView.

Database

Oracle Standard Edition, Versions 10.2, 11.2

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.

If you are using Oracle 10g, then you must install version 10.2.0.4 or higher.

You must install 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.

Microsoft SQL Server 2005, 2008, 2008 R2

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.

MySQL, Version 5.1

You must install version 5.1 or later for ExtraView to be operational. Please ensure that the database installation is configured per the guidelines listed here.

Apache Derby, version 10.5.1.1

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-srcjavaengineorgapachederbyiapitypesDataTypeDescriptor.java
db-derby-10.5.1.1-srcjavaengineorgapachederbyimplsqlcompileBaseTypeCompiler.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.

Web Servers

Apache Web Server, Versions, 2.0, 2.2

The package can be downloaded from http://www.apache.org.

Microsoft IIS Version 5.0, 6.0

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.

Application Servers

Apache Tomcat Application Server, Versions 5.5, 6.0, 7.0

The package can be downloaded from http://www.apache.org. ExtraView recommends using version 7.0.

BEA WebLogic Server, Version 9.2

This is an alternative to Apache Tomcat, and requires a separate license, available directly from BEA. ExtraView Corporation does not provide this license as part of ExtraView.

Java Support

Java 2 JDK or JRE, Standard Edition, Version 1.6

The package can be downloaded from http://www.oracle.com To circumvent a critical bug in Java, you must install build 25 or greater.

ANSI C Compiler

GNU C Compiler

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.

Command Line Interface

Perl, Version 5.12.3

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:

  • Mail::Sendmail
  • Mail::POP3Client
  • Mail::Sender
  • MIME::Parser
  • HTML::FormatText

Email

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 POP3 mailbox to be available exclusively to ExtraView.

If you are using Microsoft Exchange as your mail server, the recommended configuration is to establish and configure a POP3 account on the server. If this is not possible, then an Exchange mailbox configured to use OWA is acceptable.

Overall Server Recommendations

The current server recommendations can be downloaded by clicking here.