Re: using ssh-agent

I haven't looked at pgadmin in quite some time, didn't know they added ssh
functionality, but the following would work in any case:

ssh -args -L5432:remote_host1:5432 user(at)remote_host1
ssh -args -L5433:remote_host2:5432 user(at)remote_host2

configure pgadmin sessions to connect to localhost:5432, and
localhost:5433, voila.

Sorry if this doesn't give you what you want

On Fri, Apr 18, 2014 at 9:53 AM, <berenger(dot)morel(at)neutralite(dot)org> wrote:

> I am trying to make pgadmin using a ssh tunnel. I do not want to install a
> xorg server on production servers just for pgadmin :) ( plus the fact that
> I would have to run a pgadmin on every server with a db... definitely a
> no-go. )
>
> In more verbose:
> I have pgadmin installed on my localhost Debian, i3 ( my window manager )
> is started with "ssh-agent startx" in ~/.bash_profile, so that I am able to
> use ssh-add to add my keys, and then to use ssh without it asking me my
> passphrases constantly. This works fine.
>
> I have added servers in pgadmin with uses the tab "SSH Tunnel", enabled
> "Use SSH tunneling", filled "Tunnel host", "Username", selected "identity
> file", and of course I have given Identity file. When I try to connect,
> pgadmin asks me the postgresql password ( this is normal ), and then my
> passphrase ( this is not normal, since I have added my passphrase to
> ssh-agent through ssh-add ).
>
> When I have given the identifiers pgadmin wants, things works ( only had
> few crashes, but not easy to reproduce, and I do not have any information
> about the reason, I do not always start pgadmin from terminal... ). The
> only problem is, is it possible to make pgadmin using ssh-agent stuff, like
> in commandline ssh usual commands?
> Because I connect to exactly 2 distant servers, and I do not like to enter
> my passphrases everytime there is a connection problem, a crash, or
> whatever. It would be really nicer if I could only type the 2 postgresql
> passwords ( which is still annoying, but I do not know if it can be helped.
> )
>
> PS: no need to make me in CC, I have subscribed to the list.
>
> Le 18.04.2014 13:07, Rick Dicaire a écrit :
>
>> Berenger, are you wanting to tunnel the pgadmin connection to the db
>> servers, or ssh X11 forward a remote pgadmin app to local desktop, or
>> ...?
>>
>> On Fri, Apr 18, 2014 at 4:33 AM, wrote:
>>
>> Hello.
>>>
>>> Is it possible to use pgadmin in combination with ssh-agent?
>>> I have configured ssh-agent and my Xorg session and it works well
>>> in command-line ( a ssh-add on a terminal allows any ssh connection
>>> on any other terminal ) but it seems pgadmin does not look at
>>> ssh-agent keys, which makes mandatory to type the passphrase to the
>>> system, and the password of the postgresql user I'm trying to
>>> connect. Since I use that ssh connection to connect to 2 DB
>>>
>> servers,
>>
>>> I have to type 4 passwords each time I'm trying to (re)connect,
>>>
>> when
>>
>>> I could only have two to type if I could configure pgadmin to
>>> support ssh-agent.
>>>
>>> --
>>> Sent via pgadmin-support mailing list
>>> (pgadmin-support(at)postgresql(dot)org [1])
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgadmin-support [2]
>>>
>>
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>

--
aRDy Music and Rick Dicaire present:
http://www.ardynet.com
http://www.ardynet.com:9000/ardymusic.ogg.m3u