Unable to connect to postgres thru vpn or flyctl

I use a wireguard tunnel to backup my database on a regular basis. Suddenly I started to get connection timeout, and I can’t figure out what’s happening… this is what I can see

fly logs -a XXXXXX
2023-03-15T13:28:17Z app[148e301a370689] lax [info]2023/03/15 13:28:17 unexpected error fetching cert: durable SSH server error: malformed _orgcert.internal record: Invalid public key format
2023-03-15T13:28:18Z app[148e301a370689] lax [info]2023/03/15 13:28:18 unexpected error: [ssh: no auth passed yet, durable SSH server error: malformed _orgcert.internal record: Invalid public key format]

fly ssh issue --agent
? Select Organization: XXXXXX
Error can’t connect to SSH agent: dial unix: missing address

fly status -a XXXXXX
ID STATE ROLE REGION HEALTH CHECKS IMAGE CREATED UPDATED
148e301a370689 started leader lax 3 total, 3 passing flyio/postgres:14.6 (v0.0.34) 2023-03-09T18:25:10Z 2023-03-10T17:21:11Z

flyctl postgres connect -a XXXXX
Connecting to fdaa:0:93b6:a7b:7d17:92d2:4fcd:2… complete
Error error connecting to SSH server: ssh: handshake failed: ssh: unable to authenticate, attempted methods [none publickey], no supported methods remain

fly doctor -a XXXXX
Testing authentication token… ←[0;32mPASSED
←[0mTesting flyctl agent… ←[0;32mPASSED
←[0mTesting local Docker instance… Nope
Pinging WireGuard gateway (give us a sec)… ←[0;32mPASSED
←[0m
App specific checks for XXXXX:
Checking that app has ip addresses allocated… Nope
No ip addresses assigned to this app. If the app is not intended to receive traffic, this is fine.
Otherwise, it likely means that the services configuration is not correctly setup to receive http, tls, tcp, or udp traffic.
Fly Launch configuration (fly.toml) · Fly Docs
No ipv4 or ipv6 ip addresses allocated to app XXXXXXX

My application running in fly.io connects ok

forget it.

suddenly it started to work again. I don’t get it. been trying to figure out this for a few days and now it works :person_facepalming:

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.