MP TGW egress route back to CP
MP Firewall rule to allow traffic from CP to MP NOMIS
MP hmpps-test subnet NACLs rules updated to allow traffic from CP
Security group changes on the Instances in MP that are being connected
PTTP TGW egress route back to CP
Ports required - 1521
Here is an example of the JDBC connection for NOMIS from prison api to azure DB:
jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (HOST = 10.40.37.132) (protocol = tcp) (port = 1521))(FAILOVER = YES)(CONNECT_DATA = (SERVICE_NAME = NOMIS_APIRO_TAF)(FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC))))
davidkelliott
commented
2 years ago
User Story
Connectivity between NOMIS in Azure and NOMIS Test in Mod Platform
See thread here: https://mojdt.slack.com/archives/C01A7QK5VM1/p1641834843001700
Following guidance here - https://docs.google.com/document/d/1Z9ddlu5XDAq6B6_uH2isKbcntx-nod5abNENc72wRv0/edit We can enable connectivity with the following:
MP TGW egress route back to CP MP Firewall rule to allow traffic from CP to MP NOMIS MP hmpps-test subnet NACLs rules updated to allow traffic from CP Security group changes on the Instances in MP that are being connected PTTP TGW egress route back to CP
Ports required - 1521
Here is an example of the JDBC connection for NOMIS from prison api to azure DB: jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (HOST = 10.40.37.132) (protocol = tcp) (port = 1521))(FAILOVER = YES)(CONNECT_DATA = (SERVICE_NAME = NOMIS_APIRO_TAF)(FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC))))
Value
Questions / Assumptions
Definition of done
Reference
How to write good user stories