Installing AgileApps

Prerequisites

1. MySQL version 5.5. To configure MySQL version 5.5, see Configuring the MySQL Server.
2. MySQL Query browser (optional).

Procedure

1. Install MySQL Query browser.
2. Configure MySQL Query browser as follows:

a. In the Connect to MySQL Server Instance wizard, provide the ServerHost (localhost), Port, Username, and Password.

Note:The ServerHost (localhost), Port, Username, and Password must be the same as provided during MySQL setup.

b. Create read-only users (rousers) in MySQL database to access reports and other pages by running the queries in the following sequence:

1. CREATE USER rouser identified by 'password';
2. GRANT SELECT on *.* to 'rouser'@'localhost';
3. GRANT SELECT on *.* to 'rouser'@'127.0.0.1';
4. 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 JTA library jar.

3. Provide the location of 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.