Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Destination PostgreSQL Database Connection Error on normalization step using SSH_KEY_AUTH #9569

Closed
VitaliiMaltsev opened this issue Jan 18, 2022 · 0 comments · Fixed by #9793
Assignees
Labels
needs-triage type/bug Something isn't working

Comments

@VitaliiMaltsev
Copy link
Contributor

VitaliiMaltsev commented Jan 18, 2022

Environment

  • Airbyte version: 0.35.5-alpha
  • OS Version / Instance: Ubuntu 18.04
  • Deployment: Docker
  • Source Connector and version: github:0.2.10
  • Destination Connector and version: postgres:0.3.13
  • Severity: Very Low / Low / Medium / High / Critical
  • Step where error happened: Deploy / Sync job / Setup new connection / Update connector / Upgrade Airbyte

Current Behavior

Trying to sync Source Github to Destination Postgres (SSH Key Authentification).
Failed sync on normalization step

2022-01-18 09:13:08 normalization >   user: testcaseuser
2022-01-18 09:13:08 normalization >   database: test
2022-01-18 09:13:08 normalization >   schema: public
2022-01-18 09:13:08 normalization >   search_path: None
2022-01-18 09:13:08 normalization >   keepalives_idle: 0
2022-01-18 09:13:08 normalization >   sslmode: None
2022-01-18 09:13:08 normalization >   Connection test: [ERROR]
2022-01-18 09:13:08 normalization > 
2022-01-18 09:13:08 normalization > 1 check failed:
2022-01-18 09:13:08 normalization > dbt was unable to connect to the specified database.
2022-01-18 09:13:08 normalization > The database returned the following error:
2022-01-18 09:13:08 normalization > 
2022-01-18 09:13:08 normalization >   >Database Error
2022-01-18 09:13:08 normalization >   connection to server at "localhost" (127.0.0.1), port 50001 failed: Connection refused
2022-01-18 09:13:08 normalization >   	Is the server running on that host and accepting TCP/IP connections?

Expected Behavior

Sync should be successful

Logs

logs-1-2.txt

Steps to Reproduce

  1. Use Source Github and Destination Postgres(SSH_KEY_AUTH) Integration tests accounts with credentials from lastpass
  2. Choose all streams and try to sync

NOTE: Connection with Postgres(SSH_PASSWORD_AUTH) works well, issue only with key authentification

@VitaliiMaltsev VitaliiMaltsev added type/bug Something isn't working needs-triage labels Jan 18, 2022
@VitaliiMaltsev VitaliiMaltsev moved this to Ready for implementation in GL Roadmap Jan 18, 2022
@grubberr grubberr moved this from Ready for implementation to Implementation in progress in GL Roadmap Jan 25, 2022
@grubberr grubberr linked a pull request Jan 25, 2022 that will close this issue
@grubberr grubberr moved this from Implementation in progress to Internal review in GL Roadmap Jan 25, 2022
@grubberr grubberr moved this from Internal review to Done in GL Roadmap Jan 27, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
needs-triage type/bug Something isn't working
Projects
No open projects
Archived in project
Development

Successfully merging a pull request may close this issue.

2 participants