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...")
Β 
imported>Aeric
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 DAP 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';'''
==Installation Procedure==
::::# GRANT SELECT on *.* to ''''rouser'@'localhost';'''
:1. To install DAP, browse to the '''Software Download Center''' in [https://empower.softwareag.com/default.asp Empower].
::::# GRANT SELECT on *.* to ''''rouser'@'127.0.0.1';'''
: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].
::::# FLUSH PRIVILEGES;
: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:
:::c. Stop and Start MySQL from the Services tab of Task Manager.
:::*Core Files 10.9
:::d. Execute the query: '''SELECT * FROM mysql.`user` u;'''
:::*Memcached 10.9 or EHCache
:::e. Change the '''result-set''' of MySQL Query browser using the edit mode.
:4. Select the language and click '''Next'''.
:::f. Copy the password of the host %.
:5. Continue to click '''Next''' till you click '''Accept''' on the Terms and Conditions page.
:::g. Paste the copied password for the hosts "localhost" and "127.0.0.1".
:6. Configure AgileApps as follows:
:::h. Apply the changes.
::a. Provide the location of the license file.
:3. Install AgileApps as follows:
::b. Provide the location of [http://agileappscloud.info/wiki/Software_Requirements JTA library jar].
:::a. Download '''Software AG Installer''' for Windows operating system from Empower Software Download Center.
::c. Provide the location of [http://agileappscloud.info/wiki/Software_Requirements MySQL driver jar].
:::b. Download AgileApps using SoftwareAG installer.
::d. In the Database Connection screen, provide the Host, Port, Database user, and Password.Β  Β 
:::c. From the list of products, select AgileApps and the following components:
:::'''Note:''' The Port, Database user, Password must be the same as provided during MySQL setup.
::::*Core Files 10.9
::e. Click '''Next''' in the subsequent screens and click '''Finish'''.
::::*Memcached 10.9 or EHCache
Β 
:::d. Select the language and click '''Next'''.
===Configuring the Property Files===
:::e. Continue to click '''Next''' till you click '''Accept''' on the Terms and Conditions page.
All the property files installed as a result of the AgileApps application installation are available at '''<Install_dir>/profiles/LJP/configuration/com.softwareagplatform.config.propsloader''' folder. Change the following values in the listed property files:
:::f. Configure AgileApps as follows:
:*In the '''com.softwareag.catalina.connector.https.pid-8284.properties''' file, change port number from '''8284''' to '''443'''.
::::1. Provide the location of the license file.
:*In the '''com.softwareag.catalina.connector.http.pid-8283.properties''' file, change port number from '''8283''' to '''80''' and redirectPort from '''8284''' to '''443'''.
::::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].
===Accessing AgileApps===
::::4. In the Database Connection screen, provide the Host, Port, Database user, and Password.Β  Β 
:1. Start the IS server at '''<INSTALL_DIR>/profiles/LJP/bin'''.
:::::'''Note:''' The Port, Database user, Password must be the same as provided during MySQL setup.
: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.
::::5. Click '''Next''' in the subsequent screens and click '''Finish'''.
::*user:- admin@longjump.com
::*password:- longjump123
: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.





Revision as of 06:43, 16 April 2018

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 DAP 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

1. To install DAP, 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.9
  • Memcached 10.9 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 file.
b. Provide the location of JTA library jar.
c. Provide the location of MySQL driver jar.
d. 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.
e. 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/LJP/configuration/com.softwareagplatform.config.propsloader folder. Change the following values in the listed property files:

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

Accessing AgileApps

1. Start the IS server at <INSTALL_DIR>/profiles/LJP/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:- admin@longjump.com
  • password:- longjump123
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.