search

CDCgov / prime-devops

Apache License 2.0
4 stars 2 forks source link

Whitelist IP to permit connection to PG DB #133

Open jsutantio opened 4 months ago

jsutantio commented 4 months ago

What type of help do you need? I'm trying to connect Power BI to the postgresql database, and despite having the correct credentials, I'm not able to establish a connection (it times-out or the "connected host has failed to respond") CDC IT has already whitelisted my persistent VM IP to allow it to hit Azure in the first place, but it seems like we need further whitelisting to the specific databases.

Please describe how you'd like us to help. Please whitelist my VM IP to the following Postgresql databases: IP: 10.128.67.145 DB 1: pdhstaging-pgsql-replica DB 2: pdhprod-pgsql-replica

supriyaaddagada commented 4 months ago

Created a change request CHG0037151 to CDC, will provide an update based on ticket updates

supriyaaddagada commented 2 months ago

Gillen, Jonathon is working on the change request CHG0037151 for this, he has implemented the firewall change but the connection from PowerBI to Prime reportstream is still not working