본문으로 건너뛰기
cccskills
무료GitHub에 공개

estuary-ssh-tunnels

Diagnose and fix SSH tunnel connection issues for Estuary captures and materializations. Use when seeing tunnel failures, connection timeouts, or permission denied errors. Use when user says "SSH tunnel failed", "connection timeout via tunnel", "permission denied SSH", "tunnel not working", "network-tunnel failed", "no pubkey loaded", "bastion host not connecting", or "RSA key format".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

연동 도구MySQL
설치 방법 보기

포함된 파일(1)

  • SKILL.md4.6 KB

SKILL.md(원문)

설치하기 전에 에이전트에게 전달되는 지시 내용을 확인할 수 있습니다.

SSH Tunnel Troubleshooting for Estuary

Quick Checklist

Before deep debugging, verify these common issues:

  1. SSH Endpoint format: Must be ssh://user@hostname:port

    • Check for typos, spaces, missing hyphens
    • AWS regions use hyphens: us-west-2 not us-west 2
  2. Private key format: Must be RSA PEM format

    • Must start with -----BEGIN RSA PRIVATE KEY-----
    • NOT -----BEGIN OPENSSH PRIVATE KEY----- (OpenSSH format)
    • NOT -----BEGIN PRIVATE KEY----- (PKCS#8 format)
    • Ed25519 and ECDSA keys are not supported — only RSA
  3. IP allowlisting: Estuary data plane IPs must be allowed on:

    • Bastion/SSH server security group (port 22)
    • Database security group (from bastion's private IP)
    • Find the IPs for your data plane at Admin → Settings → Data Planes in the Estuary UI
    • Note: data plane IPs can change after infrastructure scaling — re-verify allowlists if a previously working tunnel stops connecting
  4. Data plane selection: The user should verify the correct data plane is selected in the Estuary UI when editing the connector. Each data plane has different egress IPs — using the wrong one means the wrong IPs are connecting.

Testing SSH Connectivity

If the quick checklist doesn't resolve the issue, instruct the user to test SSH connectivity from a machine that can reach the bastion host (e.g., their local machine or another server in the same network):

Test SSH connection

ssh -i /path/to/private_key -o StrictHostKeyChecking=no -v user@bastion-host -p 22

A successful connection confirms the key, username, and network path are correct.

Test the tunnel

ssh -i /path/to/private_key -o StrictHostKeyChecking=no \
    -L 3306:database-endpoint:3306 \
    user@bastion-host -N -v &

Then test the database connection through the tunnel (substitute the client and port for the relevant database type — MySQL 3306, PostgreSQL 5432, SQL Server 1433):

Important: The database address used here (and in the connector's address config field) must be the address as seen from the bastion host — not from the user's local machine. If the database is on a private subnet visible to the bastion (e.g., db.internal:5432), use that address.

mysql -h 127.0.0.1 -P 3306 -u dbuser -p

If this works locally but Estuary's connector fails, the issue is likely IP allowlisting — the user's machine can reach the bastion but Estuary's data plane IPs cannot.

Note: If the Test Connection button fails but the configuration looks correct, try Save and Publish anyway — test connectivity is sometimes stricter than the runtime connection.

Error Reference

Error MessageCauseSolution
network-tunnel failedGeneric tunnel failureCheck SSH endpoint format, key format, firewall rules
network-tunnel ready but connector still failingKnown false positive — this log can appear even when the tunnel failedCheck log entries before "tunnel ready" for the real error
Permission denied (publickey)Auth failureCheck key format (must be RSA PEM), username, key content — also check for trailing whitespace or extra newlines in the pasted key
no pubkey loadedKey format issueConvert key to RSA PEM format (see below)

Key Format Conversion

If the private key starts with -----BEGIN OPENSSH PRIVATE KEY-----, it needs to be converted to RSA PEM format:

ssh-keygen -p -N "" -m pem -f /path/to/key

To generate a new compatible key from scratch:

ssh-keygen -m PEM -t rsa -b 4096 -f mykey

Then add the public key (mykey.pub) to ~/.ssh/authorized_keys on the bastion host.

Common Endpoint Format Mistakes

# WRONG - space in region
ssh://estuary@ec2-35-87-112-173.us-west 2.compute.amazonaws.com:22

# WRONG - missing hyphen
ssh://estuary@ec2-35-87-112-173.uswest2.compute.amazonaws.com:22

# CORRECT
ssh://estuary@ec2-35-87-112-173.us-west-2.compute.amazonaws.com:22

Related Skills

  • estuary-logs — Start here to pull task logs and find the exact tunnel error message and timestamps
  • estuary-catalog-status — Check whether the task is running, failed, or disabled before debugging the tunnel

리뷰

아직 리뷰가 없습니다. 사용해 본 소감을 남겨 주세요.

댓글

로그인 없이 쓸 수 있습니다. 사용 후기, 질문, 작동하지 않은 환경 등을 편하게 남겨 주세요.

아직 댓글이 없습니다. 첫 댓글을 남겨 보세요.

보내면 바로 공개됩니다. 이메일 주소나 전화번호 같은 개인 정보는 쓰지 마세요. URL은 2개까지입니다.

0 / 1,000자

이 양식은 reCAPTCHA로 보호되며 Google 개인정보처리방침 및 서비스 약관이 적용됩니다.

같은 저장소의 스킬

Create an Alpaca capture using flowctl to stream stock trade data into Estuary collections. Use when setting up an Alpaca Market Data source for historical and real-time stock trades. Use when user says "capture Alpaca", "stream stock trades", "Alpaca market data", or "connect Alpaca to Estuary".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

estuary/agent-skills72026년 9월 25일 업데이트

Create a capture for ANY Estuary connector using dynamic schema discovery. Use when the user wants to capture from a source that doesn't have a dedicated skill (e.g., Kafka, Salesforce, HubSpot, Stripe, S3, GCS, Kinesis, or any of the 148+ connectors). Use when user says "capture from <source>", "stream from <source>", "connect <source> to Estuary", or "set up <source> capture" and no connector-specific skill exists.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

estuary/agent-skills72026년 9월 25일 업데이트

Create an HTTP Ingest (webhook) capture to receive data via HTTP POST requests. Use when setting up webhooks from GitHub, Shopify, Stripe, or any JSON source. Use when user says "set up webhook capture", "HTTP ingest to Estuary", "receive POST requests to Estuary", or "webhook capture".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

estuary/agent-skills72026년 9월 25일 업데이트

Create a HubSpot Real-Time capture using flowctl to stream CRM data into Estuary collections. Use when setting up a HubSpot source for contacts, companies, deals, tickets, or other HubSpot resources. Use when user says "capture HubSpot", "stream from HubSpot", "HubSpot CDC", or "connect HubSpot to Estuary".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

estuary/agent-skills72026년 9월 25일 업데이트

Create a MongoDB CDC capture using flowctl. Use when setting up real-time streaming from MongoDB Atlas, DocumentDB, or self-hosted MongoDB. Use when user says "capture MongoDB", "stream from Mongo", "MongoDB CDC", or "connect MongoDB to Estuary".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

estuary/agent-skills72026년 9월 25일 업데이트

Create a MySQL CDC capture using flowctl with binlog replication. Use when setting up streaming from MySQL, Amazon RDS MySQL, or Aurora MySQL. Use when user says "capture MySQL", "stream from MySQL", "MySQL CDC", "binlog replication", or "connect MySQL to Estuary".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

estuary/agent-skills72026년 9월 25일 업데이트

estuary의 스킬 모두 보기

이 스킬의 문제 신고