Difference between revisions of "Installing AgileApps"

From AgileApps Support Wiki
imported>Aeric
(Created page with "==Prerequisites== # MySQL version 5.5. To configure MySQL version 5.5, see [http://agileappscloud.info/aadev/Configuring_the_MySQL_Server Configuring the MySQL Server]. # MySQL Q...")
Β 
Β 
(14 intermediate revisions by one other user not shown)
Line 1: Line 1:
==Prerequisites==
==Prerequisites==
# MySQL version 5.5. To configure MySQL version 5.5, see [http://agileappscloud.info/aadev/Configuring_the_MySQL_Server Configuring the MySQL Server].
:* MySQL Server - mysql-5.1.x or higher versions. We recommended you download mysql-5.5.x.
# MySQL Query browser (optional).
{{Note| If MySQL is not installed in the machine where AgileApps is installed, then make sure that MySQL binary is present in the local machine. Ensure that the command '''"mysql --version"''' returns the correct output. Without this, the mysql databases are not created in the remote machine.}}
:* MySQL Query Browser – version 1.1.x or higher (optional). We recommend you download the latest version.
:* Mail Server – ( QK SMTP Server / smtp4dev). We recommend you download the latest version.
:* Memcached – Memcached 1.4.10 or later for caching. If you select Ehcache during installation, then you can skip installing memcache.


==Procedure==
===Configuring MySQL Server Post Installation of MySQL===
# Install MySQL Query browser.
For information on configuring MySQL, based on the type of setup, refer to the following:
# Configure MySQL Query browser as follows:
:*[[Configuring the MySQL Server]]
:::a. In the '''Connect to MySQL Server Instance''' wizard, provide the ServerHost (localhost), Port, Username, and Password.
:*[[Configuring MySQL to Run on a Separate Server]]
::::'''Note:'''The ServerHost (localhost), Port, Username, and Password must be the same as provided during MySQL setup.
:*[[Creating a non-root MySQL User to Run Agile Apps]]
:::b. Create read-only users (rousers) in MySQL database to access reports and other pages by running the queries in the following sequence:
::::# CREATE USER rouser identified by ''''password';'''
::::# GRANT SELECT on *.* to ''''rouser'@'localhost';'''
::::# GRANT SELECT on *.* to ''''rouser'@'127.0.0.1';'''
::::# FLUSH PRIVILEGES;
:::c. Stop and Start MySQL from the Services tab of Task Manager.Β 
:::d. Execute the query: '''SELECT * FROM mysql.`user` u;'''
:::e. Change the '''result-set''' of MySQL Query browser using the edit mode.
:::f. Copy the password of the host %.
:::g. Paste the copied password for the hosts "localhost" and "127.0.0.1".
:::h. Apply the changes.
:3. Install AgileApps as follows:
:::a. Download '''Software AG Installer''' for Windows operating system from Empower Software Download Center.
:::b. Download AgileApps using SoftwareAG installer.
:::c. From the list of products, select AgileApps and the following components:
::::*Core Files 10.9
::::*Memcached 10.9 or EHCache
:::d. Select the language and click '''Next'''.
:::e. Continue to click '''Next''' till you click '''Accept''' on the Terms and Conditions page.
:::f. Configure AgileApps as follows:
::::1. Provide the location of the license file.
::::2. Provide the location of [http://agileappscloud.info/wiki/Software_Requirements JTA library jar].
::::3. Provide the location of [http://agileappscloud.info/wiki/Software_Requirements MySQL driver jar].
::::4. In the Database Connection screen, provide the Host, Port, Database user, and Password.Β 
:::::'''Note:''' The Port, Database user, Password must be the same as provided during MySQL setup.
::::5. Click '''Next''' in the subsequent screens and click '''Finish'''.


==Installation Procedure==
{{Note|When you install AgileApps using a non-root MySQL user with the [http://agileappscloud.info/aadev/index.php/Creating_a_non-root_MySQL_User_to_Run_Agile_Apps privileges], the service desk application is not available.}}
:1. To install AgileApps, browse to the '''Software Download Center''' in [https://empower.softwareag.com/default.asp Empower].
:2. Download the Software AG Installer file. The latest installer file is made available here. Select the appropriate installer file based on your operating system (Windows/Unix/Mac OS X). For information on using the installer file, see the ''Using the Software AG Installer'' guide available in [http://documentation.softwareag.com/ Software AG Product Documentation].
:3. Follow the instructions in the ''Using the Software AG Installer'' guide to install your product. During the installation, when you are on the '''Products''' screen, select AgileApps application and the following components:
:::*Core Files 10.13
:::*Memcached 10.13 or EHCache
:4. Select the language and click '''Next'''.
:5. Continue to click '''Next''' till you click '''Accept''' on the Terms and Conditions page.
:6. Configure AgileApps as follows:
::a. Provide the location of the license files for IS and AgileApps.
::b. Provide the location of [http://agileappscloud.info/aawiki/Software_Requirements MySQL driver jar].
::c. In the Database Connection screen, provide the Host, Port, Database user, and Password.Β 
:::'''Note:''' The Port, Database user, Password must be the same as provided during MySQL setup.
::d. Click '''Next''' in the subsequent screens and click '''Finish'''.
===Configuring the Property Files===
All the property files installed as a result of the AgileApps application installation are available at '''<Install-dir>/profiles/IS_default/configuration/com.softwareagplatform.config.propsloader''' folder. Change the following values in the listed property files:
:*In the '''com.softwareag.catalina.connector.https.pid-agileappsHttps-8284.properties''' file, change port number from '''8284''' to '''443'''.
:*In the '''com.softwareag.catalina.connector.http.pid-agileappsHttp-8283.properties''' file, change port number from '''8283''' to '''80''' and redirectPort from '''8284''' to '''443'''.
{{Note|If you are running more than one instance of AgileApps on the same machine, then ensure that the http/https port configuration for both AgileApps instances is different.}}
===Accessing AgileApps===
:1. Start the IS server at '''<INSTALL-DIR>/profiles/IS_default/bin'''.
:2. Access the Longjump user interface '''https://<host>/networking/Service''' using the following credentials. You will be prompted to reset the admin password after you log on.
::*user and password: Use the credentials you typed into the Software AG installer.
:3. On the left panel click '''create new tenant'''. Enter the required details in the Create your Account page. After you click '''Create My Account''', the application may take a few minutes to create the tenant. For more information on creating tenants, see [[Managing Tenants]].
:4. Log on to AgileApps using the URL https://<host>/networking/servicedesk/index.jsp with the credentials provided during the tenant creation. After you log on, you will be prompted to reset the password.
==Platform Installation and Configuration==
For more information related to installing and configuring AgileApps, see [[Platform Installation Guide]].


<noinclude>
<noinclude>

Latest revision as of 07:11, 17 January 2022

Prerequisites

  • MySQL Server - mysql-5.1.x or higher versions. We recommended you download mysql-5.5.x.

Notepad.png

Note: If MySQL is not installed in the machine where AgileApps is installed, then make sure that MySQL binary is present in the local machine. Ensure that the command "mysql --version" returns the correct output. Without this, the mysql databases are not created in the remote machine.

  • MySQL Query Browser – version 1.1.x or higher (optional). We recommend you download the latest version.
  • Mail Server – ( QK SMTP Server / smtp4dev). We recommend you download the latest version.
  • Memcached – Memcached 1.4.10 or later for caching. If you select Ehcache during installation, then you can skip installing memcache.

Configuring MySQL Server Post Installation of MySQL

For information on configuring MySQL, based on the type of setup, refer to the following:

Installation Procedure

Notepad.png

Note: When you install AgileApps using a non-root MySQL user with the privileges, the service desk application is not available.

1. To install AgileApps, browse to the Software Download Center in Empower.
2. Download the Software AG Installer file. The latest installer file is made available here. Select the appropriate installer file based on your operating system (Windows/Unix/Mac OS X). For information on using the installer file, see the Using the Software AG Installer guide available in Software AG Product Documentation.
3. Follow the instructions in the Using the Software AG Installer guide to install your product. During the installation, when you are on the Products screen, select AgileApps application and the following components:
  • Core Files 10.13
  • Memcached 10.13 or EHCache
4. Select the language and click Next.
5. Continue to click Next till you click Accept on the Terms and Conditions page.
6. Configure AgileApps as follows:
a. Provide the location of the license files for IS and AgileApps.
b. Provide the location of MySQL driver jar.
c. In the Database Connection screen, provide the Host, Port, Database user, and Password.
Note: The Port, Database user, Password must be the same as provided during MySQL setup.
d. Click Next in the subsequent screens and click Finish.

Configuring the Property Files

All the property files installed as a result of the AgileApps application installation are available at <Install-dir>/profiles/IS_default/configuration/com.softwareagplatform.config.propsloader folder. Change the following values in the listed property files:

  • In the com.softwareag.catalina.connector.https.pid-agileappsHttps-8284.properties file, change port number from 8284 to 443.
  • In the com.softwareag.catalina.connector.http.pid-agileappsHttp-8283.properties file, change port number from 8283 to 80 and redirectPort from 8284 to 443.

Notepad.png

Note: If you are running more than one instance of AgileApps on the same machine, then ensure that the http/https port configuration for both AgileApps instances is different.

Accessing AgileApps

1. Start the IS server at <INSTALL-DIR>/profiles/IS_default/bin.
2. Access the Longjump user interface https://<host>/networking/Service using the following credentials. You will be prompted to reset the admin password after you log on.
  • user and password: Use the credentials you typed into the Software AG installer.
3. On the left panel click create new tenant. Enter the required details in the Create your Account page. After you click Create My Account, the application may take a few minutes to create the tenant. For more information on creating tenants, see Managing Tenants.
4. Log on to AgileApps using the URL https://<host>/networking/servicedesk/index.jsp with the credentials provided during the tenant creation. After you log on, you will be prompted to reset the password.

Platform Installation and Configuration

For more information related to installing and configuring AgileApps, see Platform Installation Guide.