Software Requirements
From AgileApps Support Wiki
Installing MySQL Version 8.0.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
|
Note: You must change the System Locale Language settings to English USA
|
|
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
|
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
|
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:
- com.softwareag.catalina.resource.pid-agileappsRN.properties
- 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
|
Note: You must change the System Locale Language settings to English USA
|
|
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
|
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.
|