search

StatCan / aaw

Documentation for the Advanced Analytics Workspace Platform
https://statcan.github.io/aaw/
Other
69 stars 12 forks source link

Communication issue between vetting app and database (in dev) #1347

Closed menmarc closed 2 years ago

menmarc commented 2 years ago

The vetting management application can't connect to its database: here's the error we're getting:

FATAL: Client from Azure Virtual Networks is not allowed to access the server. Please make sure your Virtual Network is correctly configured. 3 FATAL: SSL connection is required. Please specify SSL options and retry.

Here are the network rules ticket that were applied and reverted https://github.com/StatCan/aaw-network-policies/commit/08b41225d6f3f1e811ad142f2e5e8eca70f029f2

chuckbelisle commented 2 years ago

@menmarc please provide the connection string being used

menmarc commented 2 years ago

@chuckbelisle in dev that would be postgresql://vettingadmin@daaasvetting:PASSWORD@daaasvetting.postgres.database.azure.com:5432/vetting

vexingly commented 2 years ago

Reverted the changes made to the dev subnet for ticket https://github.com/StatCan/daaas-private/issues/17 (not related to the network policy changes): https://github.com/StatCan/terraform-aaw-managed-databases/pull/59

vexingly commented 2 years ago

Can you test this now @menmarc ?

menmarc commented 2 years ago

@vexingly seems to be working now. Thank you ;)