Postgres Pro
Downloads
Home   >   mailing lists

Thread: Connecting to server over an tunnel with identity file

Connecting to server over an tunnel with identity file

From
Elizabeth Kirby
Date:
I'm having trouble connecting using the ssh tunnel with an identity file.   I have a connection set up that works, but when I try to set up a new connection it says no password or public key available.   I tried copying the configuration that works, which includes the identity file that works, but get the same error message when I try to save the configuration.

I'm running on a m1 mac with sequoia 15.4.1.  Could the problem be that the os is blocking access to the file?   If so, how could it be fixed?  Or could it be something else?

 Thanks, Beth

Re: Connecting to server over an tunnel with identity file

From
Yogesh Mahajan
Date:
Hi Beth,

Can you please provide an error screenshot for the same? Also what all parameters are selected in 'SSH Tunnel' tab in Register-server dialog ?


Thanks,
Yogesh Mahajan
EnterpriseDB


On Tue, Apr 29, 2025 at 8:10 PM Elizabeth Kirby <bethkirby@gmail.com> wrote:
I'm having trouble connecting using the ssh tunnel with an identity file.   I have a connection set up that works, but when I try to set up a new connection it says no password or public key available.   I tried copying the configuration that works, which includes the identity file that works, but get the same error message when I try to save the configuration.

I'm running on a m1 mac with sequoia 15.4.1.  Could the problem be that the os is blocking access to the file?   If so, how could it be fixed?  Or could it be something else?

 Thanks, Beth

Re: Connecting to server over an tunnel with identity file

From
Elizabeth Kirby
Date:
Here's a screenshot, including the ssh tunnel parameters & the error message that I'm seeing.

This is a copy of a configuration that works, so I think that the settings should be correct.  I went back several versions of pgadmin & they all showed the same problem.  When I set up the config that works, I needed to generate a ssh key with a particular type of key (I've forgotten the name of the key).   This is the key file that is being referenced for the copy & that works, so I think the key file should be ok.

image.png

On Tue, Apr 29, 2025 at 9:23 PM Yogesh Mahajan <yogesh.mahajan@enterprisedb.com> wrote:
Hi Beth,

Can you please provide an error screenshot for the same? Also what all parameters are selected in 'SSH Tunnel' tab in Register-server dialog ?


Thanks,
Yogesh Mahajan
EnterpriseDB


On Tue, Apr 29, 2025 at 8:10 PM Elizabeth Kirby <bethkirby@gmail.com> wrote:
I'm having trouble connecting using the ssh tunnel with an identity file.   I have a connection set up that works, but when I try to set up a new connection it says no password or public key available.   I tried copying the configuration that works, which includes the identity file that works, but get the same error message when I try to save the configuration.

I'm running on a m1 mac with sequoia 15.4.1.  Could the problem be that the os is blocking access to the file?   If so, how could it be fixed?  Or could it be something else?

 Thanks, Beth
Attachment