Configuring AWS RDS as Applications Manager’s backend database

Browse through the following topics to configure AWS RDS as a database backend in Applications Manager:

• Configuring AWS RDS PostgreSQL database
• Configuring AWS RDS MS SQL database

Note: Make sure to verify the DB permissions required to run Applications Manager. Learn more

Steps to configure AWS RDS - PostgreSQL database

The following steps are to connect to the AWS RDS PostgreSQL database as a backend in Applications Manager which is installed in an AWS EC2 Instance and is in the same network (AWS VPC):

1. Install Applications Manager in an AWS EC2 Instance with bundled PostgreSQL backend.

   Note: Unselect the Launch option in the Installation setup after choosing bundled PostgreSQL as the backend. This step is to avoid creating all the Applications Manager-related tables in the bundled PostgreSQL DB.

2. Now create an RDS Instance with the PostgreSQL engine.
   • Engine type: PostgreSQL or Aurora PostgreSQL
   • Recommended version:Refer here

     Note: Make sure that the DB port 5432 is open to make the necessary connection to it from the Applications Manager server.

3. Get the following information from the database to connect to it:
   • RDS Instance Endpoint [HostName]
   • DB port
   • DB username
   • DB password
4. Now go to Applications Manager-installed EC2 server and change the database from the bundled PostgreSQL to the RDS Instance’s PostgreSQL database by implementing the following steps:
   • Edit the AMServer.properties file located under <Installation Directory>/Appmanager<version>/conf/ directory and change the value for am.db.port key, if required.
     • Replace am.dbport.check=true with am.dbport.check=false.
     • Replace am.db.port=15432 with am.db.port=<RDS_port>.
   • Edit database_params.conf file located under <Installation Directory>/Appmanager<version>/working/conf/ directory and implement the following steps:
     • Change the host and port details as below:

       From:
       url jdbc:postgresql://localhost:15433/amdb?dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8
       
       To:
       url jdbc:postgresql://RDSInstanceEndpoint:Port/amdb?dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8

     • Change the DB Username from username postgres AppModules to username <RDSDBUserName> AppModules
     • Change the DB password by removing the encrypted part in the below line and also modify the password from encryptedpassword appmanager AppModules to password <dbpassword> AppModules
5. Copy the file database_params.conf from step 4 and replace it under <Installation Directory>/Appmanager<version>/working/conf/ directory.
6. Now start the Applications Manager server.

Steps to configure AWS RDS - MS SQL database

The following steps are to connect to AWS RDS MS SQL database as a backend in Applications Manager which is installed in an AWS EC2 Instance and is in the same network (AWS VPC):

1. Create a RDS Instance with MS SQL engine.

   Note: Make sure that the DB port 1433 is open to make necessary connection to it from Applications Manager server.

2. Get the following information from the database to connect to it:
   • RDS Instance Endpoint [HostName] - Example: testmssqlrds.cxea2gyr4p1p.useast-1.rds.amazonaws.com
   • DB port
   • DB username
   • DB password
3. Install Applications Manager by choosing MS SQL database in the installation setup and enter the above information to get connected to the MS SQL database of AWS RDS instance.
4. Now start the Applications Manager server.