{"id":22549,"date":"2024-02-15T14:48:40","date_gmt":"2024-02-15T22:48:40","guid":{"rendered":"https:\/\/docs.extraview.com\/v22\/book\/recommended-software\/"},"modified":"2024-02-15T16:32:15","modified_gmt":"2024-02-16T00:32:15","slug":"recommended-software","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v22\/recommended-software\/","title":{"rendered":"Recommended Software"},"content":{"rendered":"<p>The recommended software components for this version of ExtraView are listed under the <a href=\"\/server-requirements\/\">Server Requirements <\/a>page. It is possible that other components will work, but they may not have been certified these for use with ExtraView.&nbsp; This page provides some specific information on third-party software components and how they should be configured.<\/p>\n<h3>\n\tDatabase<\/h3>\n<h4>\n\tOracle Standard Edition, Version 11.2.0.2 or later versions of 11.2<\/h4>\n<p>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.&nbsp;<\/p>\n<p>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.<\/p>\n<h4>\n\tMicrosoft SQL Server 2008, 2008 R2, 2012<\/h4>\n<p>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.<\/p>\n<p>The database must be configured with mixed mode authentication turned on.<\/p>\n<p>You must install SQL Server software separately from ExtraView, before beginning the installation of ExtraView.<\/p>\n<p><b>JDBC Driver for Microsoft SQL Server<\/b><\/p>\n<p>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\u2019s. ExtraView includes the jTDS JDBC driver for use with SQL Server. It is strongly recommended that you use this driver.<\/p>\n<h4>\n\tMySQL, Versions 5.6<\/h4>\n<p>Please ensure that the database installation is configured per the guidelines listed <a href=\"\/mysql-database-configuration\/\">further<\/a> on in this guide.<\/p>\n<h4>\n\tApache Derby, version 10.5.1.1<\/h4>\n<p>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:<\/p>\n<p>db-derby-10.5.1.1-src\/java\/engine\/org\/apache\/derby\/iapi\/types\/DataTypeDescriptor.java<br \/>\n\tdb-derby-10.5.1.1-src\/java\/engine\/org\/apache\/derby\/impl\/sql\/compile\/BaseTypeCompiler.java<\/p>\n<p>Note that the version of Derby shipped with the downloadable version of ExtraView that embeds Derby has these files already patched.<\/p>\n<p class=\"textGreyBg\">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.<\/p>\n<h3>\n\tWeb Servers<\/h3>\n<h4>\n\tApache Web Server, Version 2.4<\/h4>\n<p>The package can be downloaded from <a href=\"http:\/\/www.apache.org\" target=\"_blank\" rel=\"noopener\">http:\/\/www.apache.org<\/a>.&nbsp; It is strongly recommended that you configure your web server with SSL (Secure Sockets Layer).&nbsp; 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.<\/p>\n<h4>\n\tMicrosoft IIS Version 6.0<\/h4>\n<p>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.&nbsp; It is strongly recommended that you configure your web server with SSL (Secure Sockets Layer).&nbsp; 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.<\/p>\n<h3>\n\tApplication Servers<\/h3>\n<h4>\n\tApache Tomcat Application Server, Versions 8.0<\/h4>\n<p>The package can be downloaded from <a href=\"http:\/\/www.apache.org\" target=\"_blank\" rel=\"noopener\">http:\/\/www.apache.org<\/a>.<\/p>\n<h4>\n\tBEA WebLogic Server, Version 12c Release 2<\/h4>\n<p>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.<\/p>\n<h4>\n\tJBoss 7.0<\/h4>\n<p>Full installation instructions for JBoss with ExtraView are not provided, but please use these points along with the standard JBoss installation instructions:<\/p>\n<ul>\n<li>\n<p>The ExtraView&nbsp;<code>runPatches.sh <\/code>file should be modified, in order to make it conform to the typical JBoss path structure.&nbsp; The servlet jar&nbsp;for JBoss is&nbsp;in&nbsp;different location to where the file is expected.&nbsp; These settings should replace the settings in the file:<\/p>\n<pre>\r\n<code>JAVA_HOME=\/app\/java\/jdk1.x.x.x\/jre\/\r\nJBOSS_HOME=\/app\/user_domains\/xxx\/jbossxxdomains\/xxx-tst\/xxx-tst_server1\/\r\nEV_BASE=\/deployments\/uimsxxx.war\/\r\nSERVLET_JAR=\/app\/jboss\/jboss-eap-x.x.x\/modules\/system\/layers\/base\/javax\r\n  \/servlet\/api\/main\/jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar<\/code>\r\n<\/pre>\n<\/li>\n<li>\n<p>Load balancing under an Apache server needs modifications from the standard instructions:<\/p>\n<ul>\n<li>\n<p>Modify the <code>worker.properties<\/code> file<\/p>\n<pre>\r\n<code># Worker for area [xxx(2657)]URL [http:\/\/tst.my_company.com\/yyy\/]\r\nworker.amrndhl277_15619.type=ajp13\r\nworker.amrndhl277_15619.host=amrndhl277\r\nworker.amrndhl277_15619.port=15619\r\nworker.amrndhl277_15619.route=*yyy-tst_server1*\r\n# Worker for area [xxx(2657)]URL [http:\/\/tst.my_company.com\/uims\/]\r\nworker.amrndhl278_15619.type=ajp13\r\nworker.amrndhl278_15619.host=amrndhl278\r\nworker.amrndhl278_15619.port=15619\r\nworker.amrndhl278_15619.route=*yyy-tst_server2*\r\n# LB Worker for area [xxx(2657)] URL [http:\/\/tst.my_company.com\/uims\/]:\r\nworker.lb_yyy_tst.my_company.com_80.type=lb\r\nworker.lb_yyy_tst.my_company.com_80.balance_workers=amrnd\r\n*worker.lb_yyy_tst.my_company.com_80.sticky_session=1*<\/code><\/pre>\n<\/li>\n<li>\n<p>Modify the <code>server.xml <\/code>file<\/p>\n<p>Add a subsystem with an instance-id property that matches the route property in for each work defined above.<\/p>\n<ul>\n<li>\n\t\t\t\t\t\tAMRNDHL277<\/p>\n<pre>\r\n<code>&lt;subsystem xmlns=\"urn:jboss:domain:web:1.1\"... instance-id=\"*yyy-tst_server1\u201d*&gt;<\/code><\/pre>\n<\/li>\n<li>\n\t\t\t\t\t\tAMRNDHL278<\/p>\n<pre>\r\n<code>&lt;subsystem xmlns=\"urn:jboss:domain:web:1.1\"... instance-id=\"*yyy-tst_server2*\"&gt;<\/code><\/pre>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3>\n\tJava Support<\/h3>\n<h4>\n\tJava 2 JDK or JRE, Standard Edition, Version 1.8<\/h4>\n<p>The package can be downloaded from <a href=\"http:\/\/www.oracle.com\" target=\"_blank\" rel=\"noopener\">http:\/\/www.oracle.com<\/a>.<\/p>\n<h3>\n\tANSI C Compiler<\/h3>\n<h4>\n\tGNU C Compiler<\/h4>\n<p><em>This is only required if you want to compile your own version of Apache, as opposed to use a pre-compiled version.<\/em><\/p>\n<p>The GNU C compiler (GCC) from the Free Software Foundation (FSF) is recommended. However, as an alternative, ensure your vendor\u2019s 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.<\/p>\n<h3>\n\tCommand Line Interface<\/h3>\n<h4>\n\tPerl, Version 5.12.3<\/h4>\n<p>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 <a href=\"http:\/\/www.perl.org\/get.html\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>In addition, you will need to download the following additional Perl modules from <a href=\"http:\/\/www.cpan.org\/modules\/index.html\" target=\"_blank\" rel=\"noopener\">CPAN<\/a> (Comprehensive Perl Archive Network). The required modules are:<\/p>\n<ul>\n<li>\n\t\tMail::Sendmail<\/li>\n<li>\n\t\tMail::POP3Client<\/li>\n<li>\n\t\tMail::Sender<\/li>\n<li>\n\t\tMIME::Parser<\/li>\n<li>\n\t\tHTML::FormatText<\/li>\n<\/ul>\n<h3>\n\tEmail<\/h3>\n<p>ExtraView must be able to access Microsoft Exchange or an SMTP-based email server, in order to generate outbound email notifications.<\/p>\n<p>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.<\/p>\n<h3>\n\tOverall Server Recommendations<\/h3>\n<p>The current server recommendations can be viewed and downloaded by clicking <a href=\"\/server-requirements\/\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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.&nbsp; This page provides some specific information on third-party software components and how they should be configured. Database Oracle Standard&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-22549","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Recommended Software - Product Documentation<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.extraview.com\/v22\/recommended-software\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Recommended Software - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"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.&nbsp; This page provides some specific information on third-party software components and how they should be configured. Database Oracle Standard...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v22\/recommended-software\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-16T00:32:15+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/recommended-software\/\",\"url\":\"https:\/\/docs.extraview.com\/v22\/recommended-software\/\",\"name\":\"Recommended Software - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v22\/#website\"},\"datePublished\":\"2024-02-15T22:48:40+00:00\",\"dateModified\":\"2024-02-16T00:32:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v22\/recommended-software\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v22\/recommended-software\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/recommended-software\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v22\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Recommended Software\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/#website\",\"url\":\"https:\/\/docs.extraview.com\/v22\/\",\"name\":\"ExtraView Product Documentation\",\"description\":\"ExtraView Documentation\",\"publisher\":{\"@id\":\"https:\/\/docs.extraview.com\/v22\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.extraview.com\/v22\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/#organization\",\"name\":\"ExtraView Corporation\",\"url\":\"https:\/\/docs.extraview.com\/v22\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"contentUrl\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"ExtraView Corporation\"},\"image\":{\"@id\":\"https:\/\/docs.extraview.com\/v22\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Recommended Software - Product Documentation","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.extraview.com\/v22\/recommended-software\/","og_locale":"en_US","og_type":"article","og_title":"Recommended Software - Product Documentation","og_description":"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.&nbsp; This page provides some specific information on third-party software components and how they should be configured. Database Oracle Standard...","og_url":"https:\/\/docs.extraview.com\/v22\/recommended-software\/","og_site_name":"Product Documentation","article_modified_time":"2024-02-16T00:32:15+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v22\/recommended-software\/","url":"https:\/\/docs.extraview.com\/v22\/recommended-software\/","name":"Recommended Software - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v22\/#website"},"datePublished":"2024-02-15T22:48:40+00:00","dateModified":"2024-02-16T00:32:15+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v22\/recommended-software\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v22\/recommended-software\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v22\/recommended-software\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v22\/"},{"@type":"ListItem","position":2,"name":"Recommended Software"}]},{"@type":"WebSite","@id":"https:\/\/docs.extraview.com\/v22\/#website","url":"https:\/\/docs.extraview.com\/v22\/","name":"ExtraView Product Documentation","description":"ExtraView Documentation","publisher":{"@id":"https:\/\/docs.extraview.com\/v22\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.extraview.com\/v22\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.extraview.com\/v22\/#organization","name":"ExtraView Corporation","url":"https:\/\/docs.extraview.com\/v22\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.extraview.com\/v22\/#\/schema\/logo\/image\/","url":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","contentUrl":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","width":512,"height":512,"caption":"ExtraView Corporation"},"image":{"@id":"https:\/\/docs.extraview.com\/v22\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"carl.koppel","author_link":"https:\/\/docs.extraview.com\/v22\/author\/carl-koppel\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/pages\/22549","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/comments?post=22549"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/pages\/22549\/revisions"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/media?parent=22549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}