Re: PgAdmin with SSH tunnel
On 2018-06-10, wrote: > > On Sat, Jun 09, 2018 at 03:23:06PM +0300, Georgi Naplatanov wrote: >> Hi, >> >> I'm using Debian Stretch and I'm trying to connect to PostgreSQL server >> (Debian 9) with PgAdmin (Debian 9) through SSH tunnel. >> >> PgAdmin has built-in SSH support but when I try to connect to remote >> PostgreSQL server I get this error in PgAdmin: >> >> Error: SSH error: Error when starting up SSH session with error code -8 >> [Unable to exchange encryption keys] >> >> I use key pair for OpenSSH authentication. > > You could try to ssh into it with -v (or even -vvv) to increase the > client's verbosity (or perhaps there's a corresponding option in > PgAdmin's client). That might give you more insight into what's going > on. > I read the following response to a similar conundrum (for what it's worth): If you require access to a Postgres 9.5 database, you can manually create the SSH tunnel, and then connect using pgAdmin3 by setting the host to localhost. On Linux or Mac, you can use the following: ssh -L 5432::5432 . It doesn't seem likely that pgAdmin3 will receive any updates with the direction pgAdmin4 is heading.
Re: PgAdmin with SSH tunnel
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sat, Jun 09, 2018 at 03:23:06PM +0300, Georgi Naplatanov wrote: > Hi, > > I'm using Debian Stretch and I'm trying to connect to PostgreSQL server > (Debian 9) with PgAdmin (Debian 9) through SSH tunnel. > > PgAdmin has built-in SSH support but when I try to connect to remote > PostgreSQL server I get this error in PgAdmin: > > Error: SSH error: Error when starting up SSH session with error code -8 > [Unable to exchange encryption keys] > > I use key pair for OpenSSH authentication. You could try to ssh into it with -v (or even -vvv) to increase the client's verbosity (or perhaps there's a corresponding option in PgAdmin's client). That might give you more insight into what's going on. Cheers - -- tomás -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) iEYEARECAAYFAlsc1OEACgkQBcgs9XrR2kYS4ACdEJXMpUtrCxMOXhkrQE9+hYIp dREAn3c/Gr6NQCo75vCilLSDN32Pg119 =h8DB -END PGP SIGNATURE-
PgAdmin with SSH tunnel
Hi, I'm using Debian Stretch and I'm trying to connect to PostgreSQL server (Debian 9) with PgAdmin (Debian 9) through SSH tunnel. PgAdmin has built-in SSH support but when I try to connect to remote PostgreSQL server I get this error in PgAdmin: Error: SSH error: Error when starting up SSH session with error code -8 [Unable to exchange encryption keys] I use key pair for OpenSSH authentication. Any ideas what is wrong? Kind regards Georgi