Re: pgAdmin with SSHTunneling support

On Thu, Nov 1, 2012 at 11:38 AM, Akshay Joshi
<akshay(dot)joshi(at)enterprisedb(dot)com> wrote:
>
>
> On Wed, Oct 31, 2012 at 10:30 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>
>> Hi
>>
>> On Tue, Oct 23, 2012 at 12:33 PM, Akshay Joshi
>> <akshay(dot)joshi(at)enterprisedb(dot)com> wrote:
>> >
>> > Here the problem is we don't have an entry in the "pgpass" file for
>> > the
>> > localip:port pair(one end of the SSH tunnel). At the first attempt to
>> > connect
>> > to server it looks for the pgpass entry If stored password is
>> > checked, in
>> > this case user will find the error message. In the second attempt it
>> > first
>> > prompted for the database password which will be store in the
>> > variable
>> > and in this case user will not bet any error and then for the subsequent
>> > attempts it uses the password which is stored in the variable. If we
>> > restart pgAdmin, again the same problem will occur.
>>
>> OK, I'm still seeing the issue here. When I first try to connect it
>> always seems to fail to prompt me for a password and then gives an
>> error. I think the solution is to simply always ask for the password,
>> if the server requests it.
>
>
> As I understand you correctly, we will always prompt for the database
> password and SSH Tunneling password/pass-phrase if SSH tunneling is on and
> even if
> store password is set to true??

That's what I'm thinking - unless you have another solution that would
fix the issue and allow the password to be stored (I know we did talk
about adding temp entries to the file a while back)?

If we're going to ignore saved passwords though, we probably need to
warn the user when they enable tunnelling (a message box if the option
is checked perhaps, and then un-check it).

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company