Re: PgAdmin forgets stored password on connection problem

From: Eugene Lisitsky <lisitsky(at)gmail(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: PgAdmin forgets stored password on connection problem
Date: 2009-11-11 17:35:29
Message-ID: a745310911110935g5636ce89h4c34b65d24debcf1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

2009/11/11 Dave Page <dpage(at)pgadmin(dot)org>

> On Wed, Nov 11, 2009 at 3:33 PM, Eugene Lisitsky <lisitsky(at)gmail(dot)com>
> wrote:
>
> > Is it possible to check error and fail reason: network, connection
> refused,
> > password incorrect, no access to such DB?
>
> Not reliably, because we only get CONNECTION_GOOD, CONNECTION_BAD as
> connection status flags from libpq, and in the event of a connection
> error, get a possibly-localised error message. There are no
> standardised codes for connection errors (unlike query results, for
> which you can get SQL status codes etc).
>

I thought lib provides you with a detailed info.

>
> > Or at least as a workaround fill the form with old password?
>
> We don't know it, unless you just typed it in. Libpq reads it from
> .pgpass and pgAdmin never touches it.
>
What do you think of adding one more button to the dialog "Use stored pass"
which just does nothing only sends the connection request?

I tried to work with sources, but svn version didn't compile at my computer.
Can you help me a little?

Compile errors like these:
g++ -DHAVE_CONFIG_H -I. -I.. -I/usr/include/postgresql -DSSL
-I/usr/lib/wx/include/base-unicode-release-2.8 -I/usr/include/wx-2.8
-D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -DwxUSE_GUI=0 -O2 -DEMBED_XRC
-I/usr/include/libxml2 -I/usr/include/libxml2
-DDATA_DIR=\"/usr/local/pgadmin3/share/pgadmin3/\" -Wall
-Wno-non-virtual-dtor -fno-strict-aliasing -I../pgadmin/include -MT
pgAdmin3.o -MD -MP -MF .deps/pgAdmin3.Tpo -c -o pgAdmin3.o `test -f
'./pgAdmin3.cpp' || echo './'`./pgAdmin3.cpp
In file included from ../pgadmin/include/pgAdmin3.h:21,
from ./pgAdmin3.cpp:13:
../pgadmin/include/utils/misc.h:120: error: 'wxPoint' has not been declared
../pgadmin/include/utils/misc.h:120: error: 'wxSize' has not been declared
In file included from ../pgadmin/include/pgAdmin3.h:22,
from ./pgAdmin3.cpp:13:
../pgadmin/include/ctl/ctlTree.h:26: error: expected class-name before '{'
token
../pgadmin/include/ctl/ctlTree.h:28: error: ISO C++ forbids declaration of
'wxPoint' with no type
../pgadmin/include/ctl/ctlTree.h:28: error: expected ',' or '...' before '&'
token
In file included from ../pgadmin/include/pgAdmin3.h:22,
from ./pgAdmin3.cpp:13:
......

and at the end:

./pgAdmin3.cpp: At global scope:
./pgAdmin3.cpp:171: error: variable or field 'OnSelect' declared void
./pgAdmin3.cpp:171: error: 'wxCommandEvent' was not declared in this scope
./pgAdmin3.cpp:171: error: 'ev' was not declared in this scope
make[2]: *** [pgAdmin3.o] Error 1
make[2]: Выход из каталога
`/home/e/eclipse-workspace/pgAdmin/src/pgadmin3/pgadmin'
make[1]: *** [all-recursive] Error 1
make[1]: Выход из каталога `/home/e/eclipse-workspace/pgAdmin/src/pgadmin3'
make: *** [all] Error 2

Thank you!

>
> >> There's definitely room for improvement here though - patches are
> >> welcome if anyone wants to spend some time on it.
> >
> > Unfortunately I'm not a C developer. But I can try :)
>
> :-)
>
> --
> Dave Page
> EnterpriseDB UK: http://www.enterprisedb.com
>

--
Yours,
Eugene Lisitsky

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Vladimir Kokovic' 2009-11-11 17:51:55 PostgreSQL 8.5
Previous Message Dave Page 2009-11-11 17:02:01 Re: PgAdmin forgets stored password on connection problem