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):
- Install Applications Manager in an AWS EC2 Instance with bundled PostgreSQL backend.
- Now create an RDS Instance with the PostgreSQL engine.
- Engine type: PostgreSQL or Aurora PostgreSQL
- Recommended version: Refer hereNote: Make sure that the DB port 5432 is open to make the necessary connection to it from the Applications Manager server.
- Get the following information from the database to connect to it:
- RDS Instance Endpoint [HostName]
- DB port
- DB username
- DB password
- 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:
- 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
- Copy the file database_params.conf from step 4 and replace it under <Installation Directory>/Appmanager<version>/working/conf/ directory.
- Now start the Applications Manager server.
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.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):
- 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.
- 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
- 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.
- Now start the Applications Manager server.
New to ADSelfService Plus?
Related Articles
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 ...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 ...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) ...Configuring AWS Application Load Balancer (ALB) for routing traffic to Applications Manager Failover setup
Step 1: Failover Setup Follow this document and set up the Applications Manager Failover. It is recommended that you deploy the database server in the Cloud infrastructure as well. To use PGSQL, you can use bundled PGSQL with Applications Manager. To ...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 ...