Steps to configure AWS RDS database as Applications Manager's back-end

Steps to configure AWS RDS database as Applications Manager's back-end

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

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. 
  2. 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.
  3. Now create an RDS Instance with the PostgreSQL engine. 
    1. Engine type: PostgreSQL or Aurora PostgreSQL
    2. Recommended versionRefer here
      Note: Make sure that the DB port 5432 is open to make the necessary connection to it from the Applications Manager server.
  4. Get the following information from the database to connect to it:
    1. RDS Instance Endpoint [HostName]
    2. DB port
    3. DB username
    4. DB password
  5. Now go to Applications Manager installed EC2 server and change the database from the bundled PostgreSQL to the RDS Instance' PostgreSQL database by implementing the following steps:
    1. Edit the AMServer.properties file located under <Installation Directory>/Appmanager<version>/conf/ directory and change the value for am.db.port key, if required.
      1. Replace am.dbport.check=true with am.dbport.check=false.
      2. Replace am.db.port=15432 with am.db.port=<RDS_port>.
    2. Edit database_params.conf file located under <Installation Directory>/Appmanager<version>/working/conf/ directory and implement the following steps:
      1. 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
      2. Change the DB Username from username postgres AppModules to username <RDSDBUserName> AppModules
      3. 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
  6. Copy the file database_params.conf from step 4 and replace it under <Installation Directory>/Appmanager<version>/working/conf/ directory.
  7. 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:
    1. RDS Instance Endpoint [HostName] - Example: testmssqlrds.cxea2gyr4p1p.useast-1.rds.amazonaws.com
    2. DB port
    3. DB username
    4. 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.

                  New to ADSelfService Plus?

                    • Related Articles

                    • Installing Applications Manager in AWS

                      Applications Manager can be installed in EC2 instances in both Windows and Linux platforms. Applications Manager comes with bundled PostgreSQL. Installing Applications Manager in EC2 for Windows Go to EC2 console and launch an "Windows" instance with ...
                    • Steps to configure Azure PostgreSQL Database as Applications Manager's back-end

                      Applications Manager comes bundled with PostgreSQL. If you want to use your own PostgreSQL instead, follow the steps mentioned below: Prerequisites: A compatible PostgreSQL database should be accessible from Applications Manager installation. To know ...
                    • How to Install .NET agent on AWS Elastic Beanstalk?

                      One of the two options listed below can be used to install APM Insight agent onto a .NET web application hosted in Elastic Beanstalk environment via ebextensions. Deployment through AWS kit for Visual Studio. Deployment via uploading packages to AWS ...
                    • Connecting to Applications Manager's bundled database

                      Before you connect to Applications Manager's back-end database, it is important that you take a backup of the Applications Manager directory so that you don't make any changes/accidentally modify the database. Identify which database Applications ...
                    • ManageEngine Applications Manager High Availability setup with dual database (MySQL).

                      Apart from the Failover setup,  which uses a single database and dual Application Server, we also support a failover with dual database and Application Server. Failover support requires you to configure Applications Manager Secondary (Standby server) ...