Re: saved passwords deleted

On Tue, 2012-02-14 at 21:25 +0000, Dave Page wrote:
> On Tue, Feb 14, 2012 at 9:21 PM, Vik Reykja <vikreykja@gmail.com> wrote:
> > On Tue, Feb 14, 2012 at 22:03, Guillaume Lelarge <guillaume@lelarge.info>
> > wrote:
> >>
> >> On Mon, 2010-11-08 at 16:16 +0100, Guillaume Lelarge wrote:
> >> > Le 06/11/2010 22:35, Guillaume Lelarge a écrit :
> >> > > Le 05/11/2010 17:18, Michael Shapiro a écrit :
> >> > >> I noticed that if I have a problem connecting to a server for which I
> >> > >> have a
> >> > >> saved password, the entry in pgpass.conf is deleted.
> >> > >> When I later succeed in connecting, the server then prompts for a
> >> > >> password
> >> > >> (and the pgpass.conf entry is added back).
> >> > >>
> >> > >> Is it possible to not delete the entry if the connection fails?
> >> > >>
> >> > >
> >> > > Right now, no. And I can't find this dialog now, must be too tired.
> >> > >
> >> > > But, yes, it could probably be a good idea to add such an option.
> >> > >
> >> >
> >> > I also created a ticket to remind us to work on this dialog.
> >> >
> >>
> >> I tried quite some time to reproduce the issue tonight, and failed to do
> >> so. The only time it removes the password is when I unchecked the "Store
> >> password" checkbox, which appears to be a valid behaviour.
> >>
> >> Unless you're able to show me how to do this, I'm afraid we won't do
> >> anything on that matter (because there is nothing to do).
> >
> >
> > This is how it happens to me (on Windows at work, I haven't tried on linux
> > at home and I don't have a mac):
> >
> > 1. connect to server, save password
> > 2. disconnect from server
> > 3. stop server
> > 4. connect to server (fails, of course)
> > 5. start server
> > 6. connect to server
> >
> > pgAdmin asks for my password
>
> That's intentional. A failed connection attempt causes the password to
> be dropped to prevent you getting stuck in a situation where you
> cannot login without manually editing the file to get round some
> random authentication issue.
>

Yes, that's what I found too. And the password is still available in the
file. We can probably be a bit smarter, and check the connection error
we got.


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com