Error connecting Postgres source via StrongDM

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

The user is facing an error while trying to connect a Postgres source via StrongDM in Airbyte. They have added StrongDM to several Airbyte components but are still encountering the error. A new pod named ‘rce-postgres-check’ is starting and failing to connect. The user is seeking guidance on how to add a StrongDM sidecar to this pod.


Question

HI , i’m trying to create postgres source that will connect via strongdm to the database , it failed with the error below. i add strongdm side to serval of the airbyte components , but still getting this error.
i notice that when i create the connector a new pod starting rce-postgres-check-56e19187-24fe-4b74-9af7-69d8e2bc272f-0-lsjzz and look like it trying to connect and failed , any one know how can i add strongdm sidecar to this pod?


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["postgres-source", "strongdm", "connector", "pod", "sidecar"]
2

Close to Airbyte components – same namespace, same network. It’s an idea to explore; you need to figure out the rest :wink:

3

Are you sure that configuration is correct? Where is your deployment and where is your database?

I think creating jobs like check is done dynamically somewhere in those classes
https://github.com/airbytehq/airbyte-platform/blob/42e80bb7495a772eec9d368e375d3d7bb6022036/airbyte-workload-launcher/src/main/kotlin/pods/factories/OrchestratorPodFactory.kt|OrchestratorPodFactory.kt
https://github.com/airbytehq/airbyte-platform/blob/42e80bb7495a772eec9d368e375d3d7bb6022036/airbyte-commons-worker/src/main/java/io/airbyte/workers/process/KubePodProcess.java#L1|KubePodProcess.java
so probably there is no easy way to add sidecar except building your own customized Airbyte components.

What about creating a proxy with a sidecar? In that way proxy would connect with PostgreSQL.

4

Hi <@U05JENRCF7C> thanks for your answer, not sure where should create a proxy?