Unable to create Postgres datasource that connects to RDS Database in VPC

  • I am using the online hosting @ https://hgobs.grafana.net/.

  • I am creating a new datasource to connect to RDS PostGres Proxy which is available in VPC

  • Postgres version that we are using is 17, I have select “15” from option drop down as it’s the closest that is available

  • I have created and successfully connected a “Private data source connect”/

  • Now I am configuring the datasource, and getting following error when I lock button “Save & test”. When I try with wrong port i.e. 123, it fails with a different error. as you can see in agent logs

There was an error when testing this data source, please check PDC agent logs.
driver: bad connection
Click here to learn more about this error.
Details
driver: bad connection

PDC Agent log

level=info caller=ssh.go:378 ts=2025-05-16T19:26:57.973010504Z msg="OpenSSH_9.9p2, OpenSSL 3.3.3 11 Feb 2025"
level=info caller=ssh.go:378 ts=2025-05-16T19:26:57.974600703Z msg="Pseudo-terminal will not be allocated because stdin is not a terminal."
level=info caller=ssh.go:378 ts=2025-05-16T19:26:59.036359663Z msg="Authenticated to private-datasource-connect-prod-sa-east-1.grafana.net ([15.229.189.251]:22) using \"publickey\"."
level=info caller=ssh.go:378 ts=2025-05-16T19:26:59.152448669Z msg="Allocated port 1234 for remote forward to socks:0"
level=info caller=ssh.go:378 ts=2025-05-16T19:26:59.375485974Z msg="This is Grafana Private Datasource Connect!\n"
level=info caller=ssh.go:378 ts=2025-05-16T19:29:42.648773904Z msg="  #0 client-session (t4 [session] r0 nm0 i3/0 o0/0 e[write]/0 fd -1/5/6 sock -1 cc -1 nc0 io 0x00/0x00)"
level=info caller=ssh.go:378 ts=2025-05-16T19:29:42.64880502Z msg="  #1 1.2.3.4 (t4 [forwarded-tcpip] r1 nm0 i3/0 o3/0 e[closed]/0 fd 4/4/-1 sock 4 cc -1 nc0 io 0x00/0x00)"
level=info caller=ssh.go:378 ts=2025-05-16T19:33:33.228641094Z msg="  #0 client-session (t4 [session] r0 nm0 i3/0 o0/0 e[write]/0 fd -1/5/6 sock -1 cc -1 nc0 io 0x00/0x00)"
level=info caller=ssh.go:378 ts=2025-05-16T19:33:33.228691571Z msg="  #1 1.2.3.4 (t4 [forwarded-tcpip] r1 nm0 i3/0 o3/0 e[closed]/0 fd 4/4/-1 sock 4 cc -1 nc0 io 0x00/0x00)"
level=info caller=ssh.go:378 ts=2025-05-16T19:35:20.684663965Z msg="  #0 client-session (t4 [session] r0 nm0 i3/0 o0/0 e[write]/0 fd -1/5/6 sock -1 cc -1 nc0 io 0x00/0x00)"
level=info caller=ssh.go:378 ts=2025-05-16T19:35:20.684687265Z msg="  #1 1.2.3.4 (t4 [forwarded-tcpip] r1 nm0 i3/0 o3/0 e[closed]/0 fd 4/4/-1 sock 4 cc -1 nc0 io 0x00/0x00)"
level=info caller=ssh.go:378 ts=2025-05-16T19:38:48.570574765Z msg="  #0 client-session (t4 [session] r0 nm0 i3/0 o0/0 e[write]/0 fd -1/5/6 sock -1 cc -1 nc0 io 0x00/0x00)"
level=info caller=ssh.go:378 ts=2025-05-16T19:38:48.570621176Z msg="  #1 1.2.3.4 (t4 [forwarded-tcpip] r1 nm0 i3/0 o3/0 e[closed]/0 fd 4/4/-1 sock 4 cc -1 nc0 io 0x00/0x00)"
level=info caller=ssh.go:378 ts=2025-05-16T19:39:35.972872223Z msg="  #0 client-session (t4 [session] r0 nm0 i3/0 o0/0 e[write]/0 fd -1/5/6 sock -1 cc -1 nc0 io 0x00/0x00)"
level=info caller=ssh.go:378 ts=2025-05-16T19:39:35.972974677Z msg="  #1 1.2.3.4 (t22 [forwarded-tcpip] r1 nm0 i0/10 o3/0 e[closed]/0 fd 7/7/-1 sock 7 cc -1 nc0 io 0x20/0x00)"
level=info caller=ssh.go:378 ts=2025-05-16T19:39:35.973003005Z msg="  #2 1.2.3.4 (t4 [forwarded-tcpip] r2 nm0 i3/0 o3/0 e[closed]/0 fd 4/4/-1 sock 4 cc -1 nc0 io 0x00/0x00)"
level=info caller=ssh.go:378 ts=2025-05-16T19:41:25.253386543Z msg="connect_to proxy-1744060217193-hg- port 123: failed."
level=info caller=ssh.go:378 ts=2025-05-16T19:41:25.365032421Z msg="  #0 client-session (t4 [session] r0 nm0 i3/0 o0/0 e[write]/0 fd -1/5/6 sock -1 cc -1 nc0 io 0x00/0x00)"
level=info caller=ssh.go:378 ts=2025-05-16T19:41:25.365101906Z msg="  #1 1.2.3.4 (t4 [forwarded-tcpip] r1 nm0 i3/0 o3/0 e[closed]/0 fd -1/-1/-1 sock -1 cc -1 nc0 io 0x00/0x00)"
level=info caller=ssh.go:378 ts=2025-05-16T20:05:50.950287551Z msg="  #0 client-session (t4 [session] r0 nm0 i3/0 o0/0 e[write]/0 fd -1/5/6 sock -1 cc -1 nc0 io 0x00/0x00)"
level=info caller=ssh.go:378 ts=2025-05-16T20:05:50.950363232Z msg="  #1 1.2.3.4 (t4 [forwarded-tcpip] r1 nm0 i3/0 o3/0 e[closed]/0 fd 4/4/-1 sock 4 cc -1 nc0 io 0x00/0x00)"
level=info caller=keymanager.go:310 ts=2025-05-16T20:22:58.366142789Z msg="new client SSH certificate generated" validfor=59m59.633867584s
level=info caller=ssh.go:378 ts=2025-05-16T20:23:45.78305538Z msg="  #0 client-session (t4 [session] r0 nm0 i3/0 o0/0 e[write]/0 fd -1/5/6 sock -1 cc -1 nc0 io 0x00/0x00)"
level=info caller=ssh.go:378 ts=2025-05-16T20:23:45.783111129Z msg="  #1 1.2.3.4 (t4 [forwarded-tcpip] r1 nm0 i3/0 o3/0 e[closed]/0 fd 4/4/-1 sock 4 cc -1 nc0 io 0x00/0x00)"