Support #11224

[SCP ID :##5522##] : Log real user IP, not DNS IP

Added by Zahir Abd Latif about 4 years ago. Updated almost 4 years ago.

Status:Closed - End of life cycleStart date:October 26, 2020
Priority:NormalDue date:October 27, 2020
Assignee:Nurul Athira Abdul Rahim% Done:

100%

Category:System EnhancementSpent time:-
Target version:-

Description

Hi,
Kindly attend below request:-

Log real user IP, not DNS IP

Log real IP testing.docx (4.58 MB) Nurul Athira Abdul Rahim, October 26, 2020 17:50

Support 11224 SCPID 5522 -Test Result Preprod.docx (959 KB) Erni Suhaireen Zulkifli, November 09, 2020 12:06

History

#1 Updated by Nurul Athira Abdul Rahim about 4 years ago

  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

#2 Updated by Najmi Pasarudin about 4 years ago

  • Status changed from New - Begin Life Cycle to Development / Work In Progress

#3 Updated by Norhaidah Md Dasuki almost 4 years ago

  • Category set to System Enhancement

#4 Updated by Najmi Pasarudin almost 4 years ago

Issue only happen in Production due to Load Balancer.
Also cannot test in IBAM because there is no IP value in Transaction Enquiry page.

Propose enhancement to add IP value to Transaction Enquiry page.

#5 Updated by Najmi Pasarudin almost 4 years ago

  • % Done changed from 0 to 50

#6 Updated by Najmi Pasarudin almost 4 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim
  • % Done changed from 50 to 90

Issue:
DB Log recorded BSN internal IP instead of client IP

Finding:
CDB only search IP in HttpServletRequest "X-Forwarded-For"

Solution:
Update CDB to search IP in HttpServletRequest:
  1. X-Forwarded-For
  2. Proxy-Client-remoteAddr
  3. WL-Proxy-Client-remoteAddr
  4. HTTP_CLIENT_remoteAddr
  5. HTTP_X_FORWARDED_FOR

Test URL:
https://10.10.95.121/bsn-admin-sit/common/Login.do
https://10.10.95.121/bsn-cdb-sit/commonLogin

Test scenario:
  1. Access CDB and create Bulk Payment
  2. Access IBAM
  3. Check IP details in IBAM>BBE>Audit Trail
  4. Check IP details in IBAM>CBE>BSNeBiz Transaction Eqnuiry
  5. Check IP details in IBAM>CBE>BSNeBiz User Activity Log
  6. Expected result, above IP should show client IP

#7 Updated by Nurul Athira Abdul Rahim almost 4 years ago

Tested and passed.

#8 Updated by Norhaidah Md Dasuki almost 4 years ago

  • Due date set to October 27, 2020
  • Start date changed from September 08, 2020 to October 26, 2020

#9 Updated by Nurul Athira Abdul Rahim almost 4 years ago

  • Status changed from System Integration Test to User Acceptance Test

30/10/20 - Tested and passed by Azyan

#10 Updated by Nurul Athira Abdul Rahim almost 4 years ago

  • Assignee changed from Nurul Athira Abdul Rahim to Nurul Hasnieza Bt Mohd Zamri

Kindly deploy this issue to UAT env.

#11 Updated by Nurul Hasnieza Bt Mohd Zamri almost 4 years ago

  • Assignee changed from Nurul Hasnieza Bt Mohd Zamri to Nurul Athira Abdul Rahim

Done deployment at UAT environment.

#12 Updated by Nurul Athira Abdul Rahim almost 4 years ago

  • Status changed from User Acceptance Test to Pending Prod Deployment
  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

Fixes has been verified.

Ready to be deploy to pre prod env.

#13 Updated by Erni Suhaireen Zulkifli almost 4 years ago

Tested and passed at preprod.
Kindly proceed with further action for prod deployment

#14 Updated by Nurul Hasnieza Bt Mohd Zamri almost 4 years ago

  • Status changed from Pending Prod Deployment to Pending Review
  • Assignee changed from Nurul Hasnieza Bt Mohd Zamri to Nurul Athira Abdul Rahim

Done deployment at 09/11/2020.

#15 Updated by Nurul Athira Abdul Rahim almost 4 years ago

  • Status changed from Pending Review to Closed - End of life cycle
  • % Done changed from 90 to 100

Migration ID ID0024

Also available in: Atom PDF