search

medic / cht-sync

Data synchronization between CouchDB and PostgreSQL for the purpose of analytics.
GNU General Public License v3.0
4 stars 5 forks source link

How we connect to MoH servers #120

Closed njuguna-n closed 4 months ago

njuguna-n commented 4 months ago

To connect to CHT instances hosted by MoH Kenya we need to SSH into a proxy and then SSH into the desired instance including the staging server. The purpose of this ticket is to determine the best way to connect to the staging instance to be able to test the DBT models we will be creating.

njuguna-n commented 4 months ago

We can create an SSH tunnel and have cht-sync running locally and connected to couchdb via the tunnel. The main advantage of this is that it is realtively easy to set up the tunnel and start testing but the main drawback is that there might some data in the test instance that it private and should not be cloned to people's work stations.

The other option is to have cht-sync running in the staging instance itself and connected to a postgres instance either running in a Docker container or in an external service. We are still trying to determine if there is already a staging postgres instance already deployed.

@alexosugo do you have any reservations about the data in the staging server being cloned on teammate's work stations?

dianabarsan commented 4 months ago

Can't we just connect to API instead?

alexosugo commented 4 months ago

@njuguna-n No reservations on the staging data. It's mostly testing data that doesn't belong to any actual users.

derickl commented 4 months ago

I believe there's a postgres server already set up in the staging instance

njuguna-n commented 4 months ago

@derickl would you happen to have the URL and credentials for that? Does it have enough resources for us to use it for cht-sync testing?

njuguna-n commented 4 months ago

We will be running cht-sync and cht-pipeline in EKS and use a postgres server hosted in EKS but is not internet facing. @witash already set up a connection to some prod instances as part of the effort to test some MoH KE models. Closing this issue as there is nothing further to do and no additional info required.