Difference between revisions of "Software Requirements"

From AgileApps Support Wiki
imported>Aeric
Β 
(65 intermediate revisions by 3 users not shown)
Line 1: Line 1:
<includeonly>===Software Requirements===</includeonly>
<includeonly>===Software Requirements===</includeonly>
<noinclude>__TOC__</noinclude>
<noinclude>__TOC__</noinclude>
====Required for Installation====
Β 
====Installing MySQL Version 8.0.xx====
<!--
Stefka Dimitrova maintains the spreadsheet with OS and DB requirements:
DRAFT VERSION:
http://iwiki.eur.ad.sag:8080/display/RNDROS/%282015Oct%29+webMethods+and+Intelligent+Business+Operations+System+Requirements+9.9 (for webMethods 9.9)
Β 
PUBLISHED AT:
http://documentation.softwareag.com/webmethods/wmsuites/wmsuites_vers.htm
Β 
Marianne Fuller maintains the installation document for the standard SAG installation:
https://iwiki.eur.ad.sag/display/RNDWMSE/2015Oct+%289.9%29+Release+Installer+Designs+and+Install+Doc
Β  / Installation Guide
-->
{| border="1" cellpadding="5" cellspacing="0"
|-valign="top"
|Operating System
|
* RedHat Enterprise Linux Server - Version 7, Version 8 (recommended), or Version 9
{{Note| For RedHat Enterprise Linux Server, ensure that you perform the steps mentioned in the [[Additional Step for RedHat]] article.}}
* SUSE Linux Enterprise Server - Version 11 or Version 12 (recommended)
* CentOS Linux - Release 7
{{Note| You must change the System Locale Language settings to English USA}}
* Windows Server 2016
Β 
|-valign="top"
|MySQL Server||
*MySQL Version 8.0.xx (i.e 8.0.29) (Community Edition or Enterprise Edition)
*MySQL Commercial or Community Client
*MySQL Commercial or Community Server
*MySQL Commercial or Community libraries
*MySQL Commercial or Community compatibility libraries
*MySQL Commercial or Enterprise common files
If you are a platform user, see [[Configure the MySQL Server]].
<br>To know more about MySQL 8 removed functionality, please click <span class="plainlinks">[https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html#mysql-nutshell-removals here]</span>
Β 
{{Note|
* The '''MySQL RDS version 8''' certification with the AgileApps version 10.16 is still '''in progress'''.
* The primary difference between MySQL v8 on-premises and MySQL v8 RDS is the restricted access to the parameters on RDS, which requires certain additional configuration steps to complete the setup and data migration.
* The deprecated ASC or DESC qualifiers for GROUP BY clauses are removed. This impacts the custom SQL used in the application and results in a database syntax error. It is recommended that the application designer reviews the custom SQL used in the application to adopt MYSQL 8.
** Java [[execSQL|execSQL API]]
** REST [[REST_API:execSQL_Resource|execSQL Resource]]
**SQL Browser [[SQL Browser|SQL Browser]] }}
Β 
|-valign="top"
| <span id="libs">Libraries</span> || Download the '''third-party libraries''' and save them in a folder.<br>You may want to integrate them into the system during the installation.
:* Download mysql-connector-java-8.0.29.jar [https://dev.mysql.com/downloads/connector/j/ here]
{{Note| If mysql j/connector 8 series is used then set below properties in jdbc connection url string}}
Β 
'''scrollTolerantForwardOnly=true'''
<br>'''Example''':
<br>Edit below files present in <Install-dir>/profiles/IS_default/configuration/com.softwareagplatform.config.propsloader folder and add '''scrollTolerantForwardOnly=true''' in jdbc connection url values in the below listed property files:
Β 
#com.softwareag.catalina.resource.pid-agileappsRN.properties
#com.softwareag.catalina.resource.pid-agileappsQuartz.properties
Β 
|}
Β 
====Installing MySQL Version 5.7.xx====
<!--
<!--
Stefka Dimitrova maintains the spreadhsheet with OS and DB requirements:
Stefka Dimitrova maintains the spreadsheet with OS and DB requirements:
DRAFT VERSION: Β 
DRAFT VERSION: Β 
http://iwiki.eur.ad.sag:8080/display/RNDROS/%282015Oct%29+webMethods+and+Intelligent+Business+Operations+System+Requirements+9.9 (for webMethods 9.9)
http://iwiki.eur.ad.sag:8080/display/RNDROS/%282015Oct%29+webMethods+and+Intelligent+Business+Operations+System+Requirements+9.9 (for webMethods 9.9)
Line 18: Line 76:
|Operating System
|Operating System
|
|
* RedHat Enterprise Linux Server - Version 5 or Version 6
* RedHat Enterprise Linux Server - Version 7, Version 8 (recommended), or Version 9
* SUSE Linux Enterprise Server - Version 11 Β 
* SUSE Linux Enterprise Server - Version 11 or Version 12 (recommended)
* 64 bit OS recommended
* CentOS Linux - Release 7
{{Note| You must change the System Locale Language settings to English USA}}
* Windows Server 2016


|-valign="top"
|-valign="top"
|MySQL Server||
|MySQL Server||
*MySQL Version {{MySqlVersion}}.xxΒ  (Community Edition or Community Enterprise Edition)
*MySQL Version 5.7.xxΒ  (Community Edition or Enterprise Edition)
*MySQL Client
*MySQL Commercial or Community Client
*MySQL Shared libraries
*MySQL Commercial or Community Server
*MySQL Shared compatibility libraries
*MySQL Commercial or Community libraries
*MySQL Headers and libraries
*MySQL Commercial or Community compatibility libraries
For a new install, [[Configure the MySQL Server]] for use by the platform.
*MySQL Commercial or Enterprise common files
If you are a platform user, see [[Configure the MySQL Server]].


|-valign="top"
|-valign="top"
| <span id="libs">Libraries</span> || Download these '''third-party libraries''' to a folder of your choosing.<br>You'll provide their during the installation, to integrate them into the system.
| <span id="libs">Libraries</span> || Download the '''third-party libraries''' and save it in a folder.<br>You may want to integrate them into the system during the installation.
:* mysql-connector-java-5.1.24-bin.jar, downloaded from [http://dev.mysql.com/downloads/connector/j/ here]
:* Download mysql-connector-java-5.1.24-bin.jar [http://dev.mysql.com/downloads/connector/j/ here].
:* jta.jar, downloaded from [http://download.oracle.com/otndocs/jcp/7287-jta-1.0.1a-class-oth-JSpec/?submit=Download here]
:* Download jta.jar [http://download.oracle.com/otndocs/jcp/7287-jta-1.0.1a-class-oth-JSpec/?submit=Download here]
|}
|}


Line 43: Line 104:
|
|
;Mail Server Configuration: Β 
;Mail Server Configuration: Β 
:*Choose any of postfix, sendmail, etc. Β 
:*Choose any postfix, sendmail or so on. Β 
:*This mail server should run on TCP Port 25
:*Run the mail server on TCP Port 25<br>The mail server should always be up and running for the platform functionality to work as expected
:*The mail server should always be up and running for the platform functionality to work as expected
:*Test and verify the Mail Server MTA ([http://en.wikipedia.org/wiki/Mail_transfer_agent Mail Transfer Agent]) with the following command:
:*Test and verify the Mail Server MTA ([http://en.wikipedia.org/wiki/Mail_transfer_agent Mail Transfer Agent]) with this command:
::<tt>echo "test mail" | mail -s "hello" admin-name@myserviceproviderdomain.com</tt>
::<tt>echo "test mail" | mail -s "hello" admin-name@myserviceproviderdomain.com</tt>
::An email message should be received at the specified address. If the confirmation message does not arrive, check the mail log to discover the cause.
An email message should be received at the specified address. If the confirmation message does not arrive, check the mail log to discover the cause.


<span id="memcached"></span>
<span id="Cache"></span>
|-valign="top"
|-valign="top"
|Memcached
|Cache
|
|
;Memcached 1.4.10 for caching:
;Memcached 1.4.10 for caching:
:* Memcached can be downloaded from http://memcached.org/<br/>
:*Downloaded Memcached from http://memcached.org/<br/>
:* Memcached requires installation of <tt>libevent</tt> library version 2.0.16 (An event notification library) for your Operating System. It can be downloaded from http://www.monkey.org/~provos/libevent/
::Memcached requires installation of <tt>libevent</tt> library version 2.0.16 (An event notification library) for your Operating System. It can be downloaded from http://www.monkey.org/~provos/libevent/. For more information, see [[Configuring memcached]].
:* ''Learn More:'' [[Configuring memcached]]
;Ehcache for caching:
Ehcache is available in the Common Tomcat profile. For more information, see [[Configuring Ehcache]].


|-valign="top"
|-valign="top"
| Web Server ||
| Web Server ||
;Optional, but Recommended:
;Apache HTTP server 2.2.21 (Optional, but recommended):
;Apache HTTP server 2.2.21:
The Apache web server can be placed in front of the Tomcat appserver to deliver static content more efficiently.<br>It is recommended for systems with large numbers of [[Static Resources]] and Documents<br>The following modules must be compiled into Apache during installation:
:*The Apache web server can be placed in front of the Tomcat appserver to deliver static content more efficiently.
:::* <tt>mod_proxy</tt>
:*It is recommended for systems with large numbers of [[Static Resources]] and Documents
:::* <tt>mod_ssl</tt>
:*The following modules must be compiled into Apache during installation:
:::* <tt>mod_expires</tt>
::<tt>mod_proxy</tt>
:::* <tt>mod_headers</tt>
::<tt>mod_ssl</tt>
For more information, see [[Installing and Configuring Apache for Use with the Platform]].
::<tt>mod_expires</tt>
Β 
::<tt>mod_headers</tt>
|-valign="top"
:* ''Learn more:'' [[Installing and Configuring Apache for Use with the Platform]]
| Java ||
The installation and operation of the AgileApps Cloud platform requires Java 8. However, the custom code in Java Class continues to be validated against Java 6 syntax as the instrumentation engine responsible for monitoring resource utilization works only on Java 6 byte codes.


|-valign="top"
|-valign="top"
| Browser Support ||
| Browser Support ||
IE - Internet Explorer
FF - Firefox
;Application excluding Process:
;Application excluding Process:
:*IE8Β  yes
:*Internet Explorer 11
:*IE9Β  yes
:*Microsoft Edge
:*IE10 yes
:*Firefox 32 (Minimum requirement)
:*IE11 yes
:*Chrome 48.0.2564 (Minimum requirement)
:*FF32 yes
:*FF33 yes
:*FF34 yes
:*FF41 yes
:*FF42 yes
:*FF43 yes
:*FF44 yes
:*Chrome 48.0.2564 yes
;Process Model:
;Process Model:
:*IE8Β  no
:*Does not support Internet Explorer
:*IE9Β  no
:*Does not support Microsoft Edge
:*IE10 no
:*Firefox 32 (Minimum requirement)
:*IE11 no
:*Chrome 48.0.2564 (Minimum requirement)
:*FF32 yes
As part of the security processes, the '''Remember me on this computer''' option is removed from the browser's login page.
:*FF33 yes
::{{Common:ProcessEditingNote}}
:*FF34 yes
:: [[Accessibility Mode]] requires Firefox
:*FF41 yes
:*FF42 yes
:*FF43 yes
:*FF44 yes
:*Chrome 48.0.2564 yes
|}
|}


Line 115: Line 162:
:* Add the following command to your system startup process:
:* Add the following command to your system startup process:
::<tt>soffice -headless -accept="socket,host=127.0.0.1,port=8100;urp;" -nofirststartwizard</tt>
::<tt>soffice -headless -accept="socket,host=127.0.0.1,port=8100;urp;" -nofirststartwizard</tt>
{{Note|If you have a problem with glibc library version incompatibility while installing OpenOffice 3.4.x (usually happens on RedHat with version 5.6 and lower), you should download and install [http://ftp.rz.tu-bs.de/pub/mirror/openoffice-archive/stable/3.2.0/ OpenOffice 3.20]}}
{{Note|If you have a problem with glibc library version incompatibility while installing OpenOffice 3.4.x (for RedHat with version 5.6 and lower), you should download and install [http://ftp.rz.tu-bs.de/pub/mirror/openoffice-archive/stable/3.2.0/ OpenOffice 3.20]}}


|-valign="top"
|-valign="top"
| HornetQ (optional) ||
| HornetQ (optional) ||
;HornetQ 2.2.14:
;HornetQ 2.2.14:
:* The Messaging Server is an optional platform component that:
The Messaging Server is an optional platform component that:
::* Handles messages sent by a [[Twitter Search]]
<!--::* Handles messages sent by a [[Twitter Search]]. Commenting out due to LJP-8904-->
::* Handles the on-screen notifications when people are viewing the same Case, to prevent editing-collisions.
::* Handles the on-screen notifications to prevent editing collisions when users view the same Case.
:* Obtain it from http://www.jboss.org/hornetq/downloads.html
Get HornetQ from http://www.jboss.org/hornetq/downloads.html. For more information, see [[Installing the Messaging Server]].
:* ''Learn more:'' [[Installing the Messaging Server]]


|-valign="top"
|-valign="top"
| Charting Libraries (optional) ||
| Charting Libraries (optional) ||
Additional libraries are needed to email a chart or report.
Additional libraries are needed to email a chart or a report. For more information, see [[Install the Chart Handling Libraries]].
Β 
''Learn more:'' [[Install the Chart Handling Libraries]]
|}
|}
<noinclude>
<noinclude>

Latest revision as of 11:40, 2 November 2023

Installing MySQL Version 8.0.xx

Operating System
  • RedHat Enterprise Linux Server - Version 7, Version 8 (recommended), or Version 9

Notepad.png

Note: For RedHat Enterprise Linux Server, ensure that you perform the steps mentioned in the Additional Step for RedHat article.

  • SUSE Linux Enterprise Server - Version 11 or Version 12 (recommended)
  • CentOS Linux - Release 7

Notepad.png

Note: You must change the System Locale Language settings to English USA

  • Windows Server 2016
MySQL Server
  • MySQL Version 8.0.xx (i.e 8.0.29) (Community Edition or Enterprise Edition)
  • MySQL Commercial or Community Client
  • MySQL Commercial or Community Server
  • MySQL Commercial or Community libraries
  • MySQL Commercial or Community compatibility libraries
  • MySQL Commercial or Enterprise common files

If you are a platform user, see Configure the MySQL Server.
To know more about MySQL 8 removed functionality, please click here

Notepad.png

Note:

  • The MySQL RDS version 8 certification with the AgileApps version 10.16 is still in progress.
  • The primary difference between MySQL v8 on-premises and MySQL v8 RDS is the restricted access to the parameters on RDS, which requires certain additional configuration steps to complete the setup and data migration.
  • The deprecated ASC or DESC qualifiers for GROUP BY clauses are removed. This impacts the custom SQL used in the application and results in a database syntax error. It is recommended that the application designer reviews the custom SQL used in the application to adopt MYSQL 8.
Libraries Download the third-party libraries and save them in a folder.
You may want to integrate them into the system during the installation.
  • Download mysql-connector-java-8.0.29.jar here

Notepad.png

Note: If mysql j/connector 8 series is used then set below properties in jdbc connection url string

scrollTolerantForwardOnly=true
Example:
Edit below files present in <Install-dir>/profiles/IS_default/configuration/com.softwareagplatform.config.propsloader folder and add scrollTolerantForwardOnly=true in jdbc connection url values in the below listed property files:

  1. com.softwareag.catalina.resource.pid-agileappsRN.properties
  2. com.softwareag.catalina.resource.pid-agileappsQuartz.properties

Installing MySQL Version 5.7.xx

Operating System
  • RedHat Enterprise Linux Server - Version 7, Version 8 (recommended), or Version 9
  • SUSE Linux Enterprise Server - Version 11 or Version 12 (recommended)
  • CentOS Linux - Release 7

Notepad.png

Note: You must change the System Locale Language settings to English USA

  • Windows Server 2016
MySQL Server
  • MySQL Version 5.7.xx (Community Edition or Enterprise Edition)
  • MySQL Commercial or Community Client
  • MySQL Commercial or Community Server
  • MySQL Commercial or Community libraries
  • MySQL Commercial or Community compatibility libraries
  • MySQL Commercial or Enterprise common files

If you are a platform user, see Configure the MySQL Server.

Libraries Download the third-party libraries and save it in a folder.
You may want to integrate them into the system during the installation.
  • Download mysql-connector-java-5.1.24-bin.jar here.
  • Download jta.jar here

Required for Basic Platform Functionality

Mail Server
Mail Server Configuration
  • Choose any postfix, sendmail or so on.
  • Run the mail server on TCP Port 25
    The mail server should always be up and running for the platform functionality to work as expected
  • Test and verify the Mail Server MTA (Mail Transfer Agent) with the following command:
echo "test mail" | mail -s "hello" admin-name@myserviceproviderdomain.com

An email message should be received at the specified address. If the confirmation message does not arrive, check the mail log to discover the cause.

Cache
Memcached 1.4.10 for caching
Memcached requires installation of libevent library version 2.0.16 (An event notification library) for your Operating System. It can be downloaded from http://www.monkey.org/~provos/libevent/. For more information, see Configuring memcached.
Ehcache for caching

Ehcache is available in the Common Tomcat profile. For more information, see Configuring Ehcache.

Web Server
Apache HTTP server 2.2.21 (Optional, but recommended)

The Apache web server can be placed in front of the Tomcat appserver to deliver static content more efficiently.
It is recommended for systems with large numbers of Static Resources and Documents
The following modules must be compiled into Apache during installation:

  • mod_proxy
  • mod_ssl
  • mod_expires
  • mod_headers

For more information, see Installing and Configuring Apache for Use with the Platform.

Java

The installation and operation of the AgileApps Cloud platform requires Java 8. However, the custom code in Java Class continues to be validated against Java 6 syntax as the instrumentation engine responsible for monitoring resource utilization works only on Java 6 byte codes.

Browser Support
Application excluding Process
  • Internet Explorer 11
  • Microsoft Edge
  • Firefox 32 (Minimum requirement)
  • Chrome 48.0.2564 (Minimum requirement)
Process Model
  • Does not support Internet Explorer
  • Does not support Microsoft Edge
  • Firefox 32 (Minimum requirement)
  • Chrome 48.0.2564 (Minimum requirement)

As part of the security processes, the Remember me on this computer option is removed from the browser's login page.

Important:
To edit a Process Model, use Firefox or Chrome. Other browsers may work poorly, or not all.
Accessibility Mode requires Firefox

Required for Additional Functionality

OpenOffice (optional)
OpenOffice 3.2.0 or higher
soffice -headless -accept="socket,host=127.0.0.1,port=8100;urp;" -nofirststartwizard

Notepad.png

Note: If you have a problem with glibc library version incompatibility while installing OpenOffice 3.4.x (for RedHat with version 5.6 and lower), you should download and install OpenOffice 3.20

HornetQ (optional)
HornetQ 2.2.14

The Messaging Server is an optional platform component that:

  • Handles the on-screen notifications to prevent editing collisions when users view the same Case.

Get HornetQ from http://www.jboss.org/hornetq/downloads.html. For more information, see Installing the Messaging Server.

Charting Libraries (optional)

Additional libraries are needed to email a chart or a report. For more information, see Install the Chart Handling Libraries.