Project

General

Profile

Actions
Copy link

Feature #311

closed

Reg : Application & DB server segregation

Added by Payodhi over 1 year ago. Updated over 1 year ago.

Status:
Closed
Priority:
High
Assignee:
Shiva_CIMS
Start date:
11/21/2023
Due date:
11/30/2023
% Done:

0%

Estimated time:
Project categorization:
New

Description

Dear Shiva,

According to recommendations from RBL Infosec & RBL Suggestion, it is advised to establish a 2-tier architecture for our LOS application.
Therefore, we kindly request you to promptly segregate the application and database servers.

Files

Download all files
BRD_Application & DB Server Segregation.DOCX (59.2 KB) BRD_Application & DB Server Segregation.DOCX BRD Payodhi, 11/21/2023 11:06 AM
Functional_TC_RBL_Application & DB server Segregation xlsx.xlsx (22.9 KB) Functional_TC_RBL_Application & DB server Segregation xlsx.xlsx Functional Test Case Vijayakumar, 01/17/2024 04:18 PM
Security_TC_NOCPL_Application & DB server Segregation.xlsx (24.7 KB) Security_TC_NOCPL_Application & DB server Segregation.xlsx Rajkumar, 01/17/2024 05:19 PM
Release_Document_Application & DB Segregation.docx (44.8 KB) Release_Document_Application & DB Segregation.docx Shiva_CIMS, 01/18/2024 10:33 PM
Actions
Copy link
 #1

Updated by Vijayakumar over 1 year ago

Dear Shiva,

We are okay with it; please proceed with the necessary actions.

Actions
Copy link
 #2

Updated by Shiva_CIMS over 1 year ago

  • Status changed from New to In Progress
  • Assignee changed from Shiva_CIMS to Rajkumar

Greetings,

Please generate a new database server for segregation and provide the corresponding IP address.

Additional Notes:

1. Create a new subdomain for testing purposes and restore the live database on the new database server.

Subdomains:

1. rblandroid.nocpl.in
2. rblro.nocpl.in
3. rblbm.nocpl.in
4. rblapi.nocpl.in
5. rblcb.nocpl.in
6. rblpsm.nocpl.in

Actions
Copy link
 #3

Updated by Rajkumar over 1 year ago

  • Assignee changed from Rajkumar to Shiva_CIMS

We have established new servers and a domain for RBL server segregation. Please refer to the details below for your information.

Note : RBL_DB has been restored in new DB server.

Server Details :

S.no Server Name Server Public IP Server Private IP
1 RBL-DB-NOCPL 3.108.211.52 172.31.24.56

S.no New Subdomain
1 rblcb.nocpl.in
2 rblandroid.nocpl.in
3 rblbm.nocpl.in
4 rblao.nocpl.in
5 rblpsm.nocpl.in
6 rblapi.nocpl.in
7 rblro.nocpl.in

Actions
Copy link
 #4

Updated by Shiva_CIMS over 1 year ago

  • Assignee changed from Shiva_CIMS to Vijayakumar

Greetings,

We have successfully completed the DB and Application server segregation and tested the connectivity and confirm us for Production Deployment.

Actions
Copy link
 #5

Updated by Vijayakumar over 1 year ago

Dear Shiva,

After thorough testing on both mobile and web platforms, we confirm that it is functioning properly. Please proceed with moving it to production.

Actions
Copy link
 #6

Updated by Rajkumar over 1 year ago

Greetings,

Please find the security test case.

Actions
Copy link
 #7

Updated by Shiva_CIMS over 1 year ago

Greetings,

I appreciate your confirmation, and I wanted to inform you that the deployment has been successfully implemented in the production environment.

Thank you,

Actions
Copy link
 #8

Updated by Payodhi over 1 year ago

  • Status changed from Resolved to Closed
  • Assignee changed from Payodhi to Shiva_CIMS

Dear Shiva,

Thanks for your valuable support.

Actions
Copy link

Also available in: Atom PDF