Installing Applications Manager in EC2 for Windows

1. Go to EC2 console and launch an "Windows" instance with "At least 16GB" memory.
   
• Refer hardware requirements for more information.
  
• If RDS is used for backend, ensure that the DB is accessible by the EC2 instance.
  
2. Connect to the launched EC2 instance. To know more about connecting to the Windows instance, refer here.
3. Download the Applications Manager executable file here.
   
4. Run the downloaded file and install the Applications Manager.
   
5. If RDS is used for backend, uncheck the checkbox "Launch Applications Manager now" at the end of installation process and follow the steps mentioned in the "Use RDS PostgreSQL/MSSQL or Aurora PostgreSQL as backend for Applications Manager" section below.
   

Use RDS PostgreSQL/MSSQL or Aurora PostgreSQL as backend for Applications Manager

1. Verify the DB permissions required to run Applications Manager. Refer here.
   
2. Go to the RDS console, create an instance with the below configurations:
   
1. Engine type : PostgreSQL/MSSQL or Aurora PostgreSQL
2. Recommended version : Refer here.
   
3. Ensure that the VPC is same as EC2, if RDS DB is private.
   
4. Make note of the master username and password.
   
5. After creating the instance, navigate to Connectivity & Security tab, and make note of Endpoint and port.
   
3. After succesful installation, edit the AMServer.properties file.
1. The file can be found under <Installation Directory>/Appmanager<version>/conf/AMServer.properties.
   
2. Replace am.dbport.check=true with am.dbport.check=false.
   
3. Replace am.db.port=15432 with am.db.port=<RDS port>.
   
4. Edit the database_params.conf file:
1. For PGSQL, goto ../Appamanger/working/conf/PGSQL/database_params.conf.
   
2. For MSSQL, goto ../Appamanger/working/conf/MSSQL/database_params.conf.
3. Change the host and port details:
   
1. url jdbc:postgresql://localhost:15435/amdb to url jdbc:postgresql://<RDS host>:<RDS port>/amdb
   
4. Change the database username:
   
1. username dbuser AppModules to username <DB username> AppModules
   
5. Change the database password:
   
1. encryptedpassword eK6L4W0cd6469 AppModules to password <DB password> AppModules.
   
6. Save the file.
   
5. Copy the file database_params.conf from step 4 and replace it here: <Installation Directory>/Appmanager<version>/working/conf/database_params.conf.
   

• Ensure that EC2 and RDS security groups have correct inbound and outbound rules.
  
• For windows instances, we have to create a windows firewall rule to access a port. To create a rule, refer here.
  
• To ensure that EC2 and RDS are be able to communicate with each other, add the IP and port to inbound and outbound rules in both the security groups.
• To allow everyone,  add "All Traffic" with 0.0.0.0/0.
  

If you have any other issues, kindly check the list of troubleshooting links given below:

Please double check the RDS endpoints, port, username and password before troubleshooting.

Troubleshooting links

• To add custom IP addresses to security groups of EC2 and RDS, refer here.
• For RDS connection problems from EC2. Refer here.
  
• For RDS connection in VPC problems. Refer here.